stevieflow / uk_lottery_scrapedownload_1

UK Lottery scrapedownload


Address: Department for Culture Media and Sport, 2-4 Cockspur Street, London, SW1Y 5DH

BEGINPREVIEWSQL
select substr(`Grant date`, 0, 5) as month, sum(`Grant amount`) as total, count(*) as ngrants from swdata group by month order by month desc limit 10
ENDPREVIEWSQL

Forked from ScraperWiki

Contributors stevieflow

This scraper has not yet been run

Data

Downloaded 0 times

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (0 Bytes) Use the API

rows 10 / 358907

Local authority Project description Grant amount DBID link Grant date Distributing body Recipient ID
West Dorset
Jurassic Coast Earth Festival 2012
100000
AE
2011-08-10
Arts Council England
Lyme Regis Development Trust
18112605
Cornwall
Journey to the Fifth Province
9500
AE
2011-08-10
Arts Council England
Donal Cox
18031323
Tonbridge and Malling
Projection of single digital images & audio visual
4500
AE
2011-08-10
Arts Council England
Tonbridge Camera Club
17987093
Brighton and Hove
The Book of Invisible Bridges
10000
AE
2011-08-10
Arts Council England
Boca2Mouth
17983020
Teignbridge
Making It Home
5086
AE
2011-08-10
Arts Council England
Rosalyn Maynard
17966889
Birmingham
Development of mental health work
18500
AE
2011-08-10
Arts Council England
Geese Theatre Company
17694251
Teignbridge
HOME DARTMOOR
23500
AE
2011-08-10
Arts Council England
Garry Fabian Miller
17678716
Havering
African Nights Fever
9630
AE
2011-08-09
Arts Council England
African Culture Arts and Sport Network
18019075
Mid Suffolk
The Suffolk Psychogeophysics Summit 2011
7319
AE
2011-08-09
Arts Council England
Ryan Jordan
18005940
Sheffield
What Matters to You
5005
AE
2011-08-09
Arts Council England
Lisa Watts
17997838

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (0 Bytes) Use the API

rows 10 / 276

qmonth quarter isomonth
1997-03
1997Q1
1997-01
1997-03
1997Q1
1997-02
1997-03
1997Q1
1997-03
1997-06
1997Q2
1997-04
1997-06
1997Q2
1997-05
1997-06
1997Q2
1997-06
1997-09
1997Q3
1997-07
1997-09
1997Q3
1997-08
1997-09
1997Q3
1997-09
1997-12
1997Q4
1997-10

Statistics

Total run time: less than 5 seconds

Total cpu time used: less than 5 seconds

Total disk space used: 24.9 KB

History