ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,572 rows where county = "Limestone" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1622 | 1622 | 2020-03-13 | Limestone | Alabama | 1083 | 1 | 0 |
1938 | 1938 | 2020-03-14 | Limestone | Alabama | 1083 | 1 | 0 |
2314 | 2314 | 2020-03-15 | Limestone | Alabama | 1083 | 1 | 0 |
2743 | 2743 | 2020-03-16 | Limestone | Alabama | 1083 | 1 | 0 |
3219 | 3219 | 2020-03-17 | Limestone | Alabama | 1083 | 1 | 0 |
3766 | 3766 | 2020-03-18 | Limestone | Alabama | 1083 | 1 | 0 |
4407 | 4407 | 2020-03-19 | Limestone | Alabama | 1083 | 1 | 0 |
5177 | 5177 | 2020-03-20 | Limestone | Alabama | 1083 | 1 | 0 |
6093 | 6093 | 2020-03-21 | Limestone | Alabama | 1083 | 1 | 0 |
7127 | 7127 | 2020-03-22 | Limestone | Alabama | 1083 | 1 | 0 |
8267 | 8267 | 2020-03-23 | Limestone | Alabama | 1083 | 1 | 0 |
9494 | 9494 | 2020-03-24 | Limestone | Alabama | 1083 | 4 | 0 |
10859 | 10859 | 2020-03-25 | Limestone | Alabama | 1083 | 6 | 0 |
12163 | 12163 | 2020-03-25 | Limestone | Texas | 48293 | 1 | 0 |
12396 | 12396 | 2020-03-26 | Limestone | Alabama | 1083 | 13 | 0 |
13794 | 13794 | 2020-03-26 | Limestone | Texas | 48293 | 1 | 0 |
14057 | 14057 | 2020-03-27 | Limestone | Alabama | 1083 | 16 | 0 |
15550 | 15550 | 2020-03-27 | Limestone | Texas | 48293 | 1 | 0 |
15835 | 15835 | 2020-03-28 | Limestone | Alabama | 1083 | 16 | 0 |
17420 | 17420 | 2020-03-28 | Limestone | Texas | 48293 | 1 | 0 |
17718 | 17718 | 2020-03-29 | Limestone | Alabama | 1083 | 16 | 0 |
19375 | 19375 | 2020-03-29 | Limestone | Texas | 48293 | 1 | 0 |
19690 | 19690 | 2020-03-30 | Limestone | Alabama | 1083 | 20 | 0 |
21436 | 21436 | 2020-03-30 | Limestone | Texas | 48293 | 2 | 0 |
21762 | 21762 | 2020-03-31 | Limestone | Alabama | 1083 | 22 | 0 |
23575 | 23575 | 2020-03-31 | Limestone | Texas | 48293 | 2 | 0 |
23918 | 23918 | 2020-04-01 | Limestone | Alabama | 1083 | 23 | 0 |
25786 | 25786 | 2020-04-01 | Limestone | Texas | 48293 | 2 | 0 |
26140 | 26140 | 2020-04-02 | Limestone | Alabama | 1083 | 25 | 0 |
28072 | 28072 | 2020-04-02 | Limestone | Texas | 48293 | 3 | 0 |
28437 | 28437 | 2020-04-03 | Limestone | Alabama | 1083 | 30 | 0 |
30408 | 30408 | 2020-04-03 | Limestone | Texas | 48293 | 3 | 0 |
30794 | 30794 | 2020-04-04 | Limestone | Alabama | 1083 | 31 | 0 |
32803 | 32803 | 2020-04-04 | Limestone | Texas | 48293 | 3 | 1 |
33198 | 33198 | 2020-04-05 | Limestone | Alabama | 1083 | 32 | 0 |
35241 | 35241 | 2020-04-05 | Limestone | Texas | 48293 | 3 | 1 |
35637 | 35637 | 2020-04-06 | Limestone | Alabama | 1083 | 33 | 0 |
37717 | 37717 | 2020-04-06 | Limestone | Texas | 48293 | 3 | 1 |
38125 | 38125 | 2020-04-07 | Limestone | Alabama | 1083 | 32 | 0 |
40245 | 40245 | 2020-04-07 | Limestone | Texas | 48293 | 6 | 1 |
40667 | 40667 | 2020-04-08 | Limestone | Alabama | 1083 | 32 | 0 |
42813 | 42813 | 2020-04-08 | Limestone | Texas | 48293 | 6 | 1 |
43240 | 43240 | 2020-04-09 | Limestone | Alabama | 1083 | 35 | 0 |
45403 | 45403 | 2020-04-09 | Limestone | Texas | 48293 | 7 | 1 |
45838 | 45838 | 2020-04-10 | Limestone | Alabama | 1083 | 36 | 0 |
48024 | 48024 | 2020-04-10 | Limestone | Texas | 48293 | 9 | 1 |
48467 | 48467 | 2020-04-11 | Limestone | Alabama | 1083 | 36 | 0 |
50682 | 50682 | 2020-04-11 | Limestone | Texas | 48293 | 11 | 1 |
51129 | 51129 | 2020-04-12 | Limestone | Alabama | 1083 | 37 | 0 |
53357 | 53357 | 2020-04-12 | Limestone | Texas | 48293 | 11 | 1 |
53807 | 53807 | 2020-04-13 | Limestone | Alabama | 1083 | 37 | 0 |
56045 | 56045 | 2020-04-13 | Limestone | Texas | 48293 | 11 | 1 |
56499 | 56499 | 2020-04-14 | Limestone | Alabama | 1083 | 37 | 0 |
58750 | 58750 | 2020-04-14 | Limestone | Texas | 48293 | 11 | 1 |
59207 | 59207 | 2020-04-15 | Limestone | Alabama | 1083 | 38 | 0 |
61468 | 61468 | 2020-04-15 | Limestone | Texas | 48293 | 11 | 1 |
61925 | 61925 | 2020-04-16 | Limestone | Alabama | 1083 | 38 | 0 |
64196 | 64196 | 2020-04-16 | Limestone | Texas | 48293 | 11 | 1 |
64658 | 64658 | 2020-04-17 | Limestone | Alabama | 1083 | 40 | 0 |
66943 | 66943 | 2020-04-17 | Limestone | Texas | 48293 | 11 | 1 |
67406 | 67406 | 2020-04-18 | Limestone | Alabama | 1083 | 40 | 0 |
69703 | 69703 | 2020-04-18 | Limestone | Texas | 48293 | 11 | 1 |
70168 | 70168 | 2020-04-19 | Limestone | Alabama | 1083 | 40 | 0 |
72472 | 72472 | 2020-04-19 | Limestone | Texas | 48293 | 11 | 1 |
72937 | 72937 | 2020-04-20 | Limestone | Alabama | 1083 | 40 | 0 |
75248 | 75248 | 2020-04-20 | Limestone | Texas | 48293 | 11 | 1 |
75713 | 75713 | 2020-04-21 | Limestone | Alabama | 1083 | 40 | 0 |
78030 | 78030 | 2020-04-21 | Limestone | Texas | 48293 | 11 | 1 |
78496 | 78496 | 2020-04-22 | Limestone | Alabama | 1083 | 38 | 0 |
80821 | 80821 | 2020-04-22 | Limestone | Texas | 48293 | 11 | 1 |
81289 | 81289 | 2020-04-23 | Limestone | Alabama | 1083 | 40 | 0 |
83622 | 83622 | 2020-04-23 | Limestone | Texas | 48293 | 11 | 1 |
84090 | 84090 | 2020-04-24 | Limestone | Alabama | 1083 | 41 | 0 |
86427 | 86427 | 2020-04-24 | Limestone | Texas | 48293 | 11 | 1 |
86898 | 86898 | 2020-04-25 | Limestone | Alabama | 1083 | 41 | 0 |
89242 | 89242 | 2020-04-25 | Limestone | Texas | 48293 | 11 | 1 |
89714 | 89714 | 2020-04-26 | Limestone | Alabama | 1083 | 41 | 0 |
92059 | 92059 | 2020-04-26 | Limestone | Texas | 48293 | 11 | 1 |
92532 | 92532 | 2020-04-27 | Limestone | Alabama | 1083 | 42 | 0 |
94888 | 94888 | 2020-04-27 | Limestone | Texas | 48293 | 12 | 1 |
95362 | 95362 | 2020-04-28 | Limestone | Alabama | 1083 | 44 | 0 |
97728 | 97728 | 2020-04-28 | Limestone | Texas | 48293 | 13 | 1 |
98207 | 98207 | 2020-04-29 | Limestone | Alabama | 1083 | 44 | 0 |
100578 | 100578 | 2020-04-29 | Limestone | Texas | 48293 | 12 | 1 |
101057 | 101057 | 2020-04-30 | Limestone | Alabama | 1083 | 44 | 0 |
103433 | 103433 | 2020-04-30 | Limestone | Texas | 48293 | 12 | 1 |
103912 | 103912 | 2020-05-01 | Limestone | Alabama | 1083 | 44 | 0 |
106297 | 106297 | 2020-05-01 | Limestone | Texas | 48293 | 12 | 1 |
106777 | 106777 | 2020-05-02 | Limestone | Alabama | 1083 | 44 | 0 |
109166 | 109166 | 2020-05-02 | Limestone | Texas | 48293 | 13 | 1 |
109646 | 109646 | 2020-05-03 | Limestone | Alabama | 1083 | 45 | 0 |
112040 | 112040 | 2020-05-03 | Limestone | Texas | 48293 | 13 | 1 |
112521 | 112521 | 2020-05-04 | Limestone | Alabama | 1083 | 47 | 0 |
114922 | 114922 | 2020-05-04 | Limestone | Texas | 48293 | 13 | 1 |
115404 | 115404 | 2020-05-05 | Limestone | Alabama | 1083 | 48 | 0 |
117881 | 117881 | 2020-05-05 | Limestone | Texas | 48293 | 13 | 1 |
118363 | 118363 | 2020-05-06 | Limestone | Alabama | 1083 | 49 | 0 |
120845 | 120845 | 2020-05-06 | Limestone | Texas | 48293 | 13 | 1 |
121329 | 121329 | 2020-05-07 | Limestone | Alabama | 1083 | 54 | 0 |
123824 | 123824 | 2020-05-07 | Limestone | Texas | 48293 | 13 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);