[Wikitech-l] Is the page status in the database?

2009-01-15 Thread Eugenio Tacchini
Hello everybody, I'm looking, for academic research purposes, for the "status" of wikipedia pages. For "status" I mean: - stub - normal - good article - featured Is there any coloumn in the mediawiki database schema that can give me this information? Thanks in advance. Cheers, Eugenio _

Re: [Wikitech-l] Is the page status in the database?

2009-01-15 Thread Marco Schuster
On Thu, Jan 15, 2009 at 5:00 PM, Eugenio Tacchini wrote: > Hello everybody, > I'm looking, for academic research purposes, for the "status" of > wikipedia pages. For "status" I mean: > - stub revision.rev_len > - normal pretty obvious - everything above stub level > - good article > - featured tem

Re: [Wikitech-l] Is the page status in the database?

2009-01-15 Thread Chad
On Thu, Jan 15, 2009 at 11:00 AM, Eugenio Tacchini wrote: > Hello everybody, > I'm looking, for academic research purposes, for the "status" of > wikipedia pages. For "status" I mean: > - stub > - normal > - good article > - featured > > Is there any coloumn in the mediawiki database schema that c

Re: [Wikitech-l] Is the page status in the database?

2009-01-15 Thread Eugenio Tacchini
Hello, thanks for your reply. At 17.18 15/01/2009 +0100, you wrote: >On Thu, Jan 15, 2009 at 5:00 PM, Eugenio Tacchini wrote: >> Hello everybody, >> I'm looking, for academic research purposes, for the "status" of >> wikipedia pages. For "status" I mean: >> - stub >revision.rev_len This i

Re: [Wikitech-l] Is the page status in the database?

2009-01-15 Thread Eugenio Tacchini
At 11.18 15/01/2009 -0500, you wrote: >None of this information is stored in the database really. A count of >real articles vs. stubs is sort of stored in the site_stats. The content >pages that aren't stubs are counted in ss_good_articles. However, >ss_total_pages is all pages, content or not

Re: [Wikitech-l] Is the page status in the database?

2009-01-15 Thread Aryeh Gregor
On Thu, Jan 15, 2009 at 11:54 AM, Eugenio Tacchini wrote: > Thanks for yor reply. > > I don't need a generale measure but I need the status for each single > page; as far as I have seen probably the only solution is to look at > the corresponding templates, maybe via the table marco suggested me.

Re: [Wikitech-l] Is the page status in the database?

2009-01-16 Thread Eugenio Tacchini
At 16.15 15/01/2009 -0500, you wrote: >On Thu, Jan 15, 2009 at 11:54 AM, Eugenio Tacchini wrote: >> Thanks for yor reply. >> >> I don't need a generale measure but I need the status for each single >> page; as far as I have seen probably the only solution is to look at >> the corresponding