ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Greene" and state = "Alabama" sorted by county descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14049 | 14049 | 2020-03-27 | Greene | Alabama | 1063 | 1 | 0 |
15827 | 15827 | 2020-03-28 | Greene | Alabama | 1063 | 3 | 0 |
17710 | 17710 | 2020-03-29 | Greene | Alabama | 1063 | 3 | 0 |
19681 | 19681 | 2020-03-30 | Greene | Alabama | 1063 | 3 | 0 |
21753 | 21753 | 2020-03-31 | Greene | Alabama | 1063 | 3 | 0 |
23909 | 23909 | 2020-04-01 | Greene | Alabama | 1063 | 4 | 0 |
26131 | 26131 | 2020-04-02 | Greene | Alabama | 1063 | 4 | 0 |
28427 | 28427 | 2020-04-03 | Greene | Alabama | 1063 | 5 | 0 |
30784 | 30784 | 2020-04-04 | Greene | Alabama | 1063 | 5 | 0 |
33188 | 33188 | 2020-04-05 | Greene | Alabama | 1063 | 6 | 0 |
35627 | 35627 | 2020-04-06 | Greene | Alabama | 1063 | 8 | 0 |
38115 | 38115 | 2020-04-07 | Greene | Alabama | 1063 | 10 | 0 |
40657 | 40657 | 2020-04-08 | Greene | Alabama | 1063 | 12 | 0 |
43230 | 43230 | 2020-04-09 | Greene | Alabama | 1063 | 13 | 0 |
45828 | 45828 | 2020-04-10 | Greene | Alabama | 1063 | 13 | 0 |
48457 | 48457 | 2020-04-11 | Greene | Alabama | 1063 | 14 | 0 |
51119 | 51119 | 2020-04-12 | Greene | Alabama | 1063 | 17 | 0 |
53797 | 53797 | 2020-04-13 | Greene | Alabama | 1063 | 18 | 0 |
56489 | 56489 | 2020-04-14 | Greene | Alabama | 1063 | 18 | 0 |
59197 | 59197 | 2020-04-15 | Greene | Alabama | 1063 | 19 | 0 |
61915 | 61915 | 2020-04-16 | Greene | Alabama | 1063 | 22 | 0 |
64648 | 64648 | 2020-04-17 | Greene | Alabama | 1063 | 24 | 0 |
67396 | 67396 | 2020-04-18 | Greene | Alabama | 1063 | 29 | 0 |
70158 | 70158 | 2020-04-19 | Greene | Alabama | 1063 | 29 | 0 |
72927 | 72927 | 2020-04-20 | Greene | Alabama | 1063 | 32 | 0 |
75703 | 75703 | 2020-04-21 | Greene | Alabama | 1063 | 32 | 0 |
78486 | 78486 | 2020-04-22 | Greene | Alabama | 1063 | 40 | 0 |
81279 | 81279 | 2020-04-23 | Greene | Alabama | 1063 | 41 | 0 |
84080 | 84080 | 2020-04-24 | Greene | Alabama | 1063 | 44 | 0 |
86888 | 86888 | 2020-04-25 | Greene | Alabama | 1063 | 44 | 0 |
89704 | 89704 | 2020-04-26 | Greene | Alabama | 1063 | 46 | 0 |
92522 | 92522 | 2020-04-27 | Greene | Alabama | 1063 | 46 | 0 |
95352 | 95352 | 2020-04-28 | Greene | Alabama | 1063 | 47 | 1 |
98197 | 98197 | 2020-04-29 | Greene | Alabama | 1063 | 50 | 1 |
101047 | 101047 | 2020-04-30 | Greene | Alabama | 1063 | 55 | 1 |
103902 | 103902 | 2020-05-01 | Greene | Alabama | 1063 | 54 | 1 |
106767 | 106767 | 2020-05-02 | Greene | Alabama | 1063 | 55 | 1 |
109636 | 109636 | 2020-05-03 | Greene | Alabama | 1063 | 58 | 1 |
112511 | 112511 | 2020-05-04 | Greene | Alabama | 1063 | 61 | 1 |
115394 | 115394 | 2020-05-05 | Greene | Alabama | 1063 | 61 | 2 |
118353 | 118353 | 2020-05-06 | Greene | Alabama | 1063 | 64 | 2 |
121319 | 121319 | 2020-05-07 | Greene | Alabama | 1063 | 67 | 2 |
124299 | 124299 | 2020-05-08 | Greene | Alabama | 1063 | 70 | 3 |
127284 | 127284 | 2020-05-09 | Greene | Alabama | 1063 | 70 | 3 |
130274 | 130274 | 2020-05-10 | Greene | Alabama | 1063 | 70 | 3 |
133264 | 133264 | 2020-05-11 | Greene | Alabama | 1063 | 73 | 3 |
136254 | 136254 | 2020-05-12 | Greene | Alabama | 1063 | 73 | 4 |
139245 | 139245 | 2020-05-13 | Greene | Alabama | 1063 | 74 | 4 |
142241 | 142241 | 2020-05-14 | Greene | Alabama | 1063 | 76 | 4 |
145240 | 145240 | 2020-05-15 | Greene | Alabama | 1063 | 79 | 4 |
148243 | 148243 | 2020-05-16 | Greene | Alabama | 1063 | 81 | 4 |
151252 | 151252 | 2020-05-17 | Greene | Alabama | 1063 | 81 | 4 |
154264 | 154264 | 2020-05-18 | Greene | Alabama | 1063 | 87 | 4 |
157280 | 157280 | 2020-05-19 | Greene | Alabama | 1063 | 87 | 4 |
160304 | 160304 | 2020-05-20 | Greene | Alabama | 1063 | 86 | 4 |
163332 | 163332 | 2020-05-21 | Greene | Alabama | 1063 | 88 | 4 |
166364 | 166364 | 2020-05-22 | Greene | Alabama | 1063 | 88 | 4 |
169400 | 169400 | 2020-05-23 | Greene | Alabama | 1063 | 90 | 4 |
172441 | 172441 | 2020-05-24 | Greene | Alabama | 1063 | 89 | 4 |
175484 | 175484 | 2020-05-25 | Greene | Alabama | 1063 | 91 | 4 |
178529 | 178529 | 2020-05-26 | Greene | Alabama | 1063 | 91 | 4 |
181573 | 181573 | 2020-05-27 | Greene | Alabama | 1063 | 91 | 4 |
184625 | 184625 | 2020-05-28 | Greene | Alabama | 1063 | 92 | 4 |
187682 | 187682 | 2020-05-29 | Greene | Alabama | 1063 | 93 | 4 |
190746 | 190746 | 2020-05-30 | Greene | Alabama | 1063 | 94 | 4 |
193812 | 193812 | 2020-05-31 | Greene | Alabama | 1063 | 94 | 4 |
196882 | 196882 | 2020-06-01 | Greene | Alabama | 1063 | 95 | 4 |
199955 | 199955 | 2020-06-02 | Greene | Alabama | 1063 | 95 | 4 |
203031 | 203031 | 2020-06-03 | Greene | Alabama | 1063 | 95 | 4 |
206110 | 206110 | 2020-06-04 | Greene | Alabama | 1063 | 95 | 4 |
209192 | 209192 | 2020-06-05 | Greene | Alabama | 1063 | 95 | 5 |
212277 | 212277 | 2020-06-06 | Greene | Alabama | 1063 | 98 | 5 |
215364 | 215364 | 2020-06-07 | Greene | Alabama | 1063 | 98 | 5 |
218454 | 218454 | 2020-06-08 | Greene | Alabama | 1063 | 99 | 5 |
221546 | 221546 | 2020-06-09 | Greene | Alabama | 1063 | 102 | 5 |
224642 | 224642 | 2020-06-10 | Greene | Alabama | 1063 | 107 | 5 |
227743 | 227743 | 2020-06-11 | Greene | Alabama | 1063 | 112 | 5 |
230847 | 230847 | 2020-06-12 | Greene | Alabama | 1063 | 117 | 5 |
233952 | 233952 | 2020-06-13 | Greene | Alabama | 1063 | 119 | 5 |
237059 | 237059 | 2020-06-14 | Greene | Alabama | 1063 | 123 | 5 |
240167 | 240167 | 2020-06-15 | Greene | Alabama | 1063 | 132 | 5 |
243278 | 243278 | 2020-06-16 | Greene | Alabama | 1063 | 135 | 5 |
246391 | 246391 | 2020-06-17 | Greene | Alabama | 1063 | 135 | 5 |
249503 | 249503 | 2020-06-18 | Greene | Alabama | 1063 | 144 | 5 |
252618 | 252618 | 2020-06-19 | Greene | Alabama | 1063 | 151 | 5 |
255737 | 255737 | 2020-06-20 | Greene | Alabama | 1063 | 151 | 5 |
258864 | 258864 | 2020-06-21 | Greene | Alabama | 1063 | 154 | 5 |
261991 | 261991 | 2020-06-22 | Greene | Alabama | 1063 | 154 | 5 |
265120 | 265120 | 2020-06-23 | Greene | Alabama | 1063 | 157 | 6 |
268249 | 268249 | 2020-06-24 | Greene | Alabama | 1063 | 157 | 6 |
271383 | 271383 | 2020-06-25 | Greene | Alabama | 1063 | 160 | 6 |
274523 | 274523 | 2020-06-26 | Greene | Alabama | 1063 | 160 | 6 |
277671 | 277671 | 2020-06-27 | Greene | Alabama | 1063 | 164 | 7 |
280819 | 280819 | 2020-06-28 | Greene | Alabama | 1063 | 164 | 7 |
283965 | 283965 | 2020-06-29 | Greene | Alabama | 1063 | 164 | 7 |
287111 | 287111 | 2020-06-30 | Greene | Alabama | 1063 | 164 | 7 |
290261 | 290261 | 2020-07-01 | Greene | Alabama | 1063 | 166 | 7 |
293414 | 293414 | 2020-07-02 | Greene | Alabama | 1063 | 178 | 8 |
296569 | 296569 | 2020-07-03 | Greene | Alabama | 1063 | 183 | 8 |
299731 | 299731 | 2020-07-04 | Greene | Alabama | 1063 | 183 | 8 |
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);