ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Madison" and state = "Georgia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
8498 | 8498 | 2020-03-23 | Madison | Georgia | 13195 | 1 | 0 |
9754 | 9754 | 2020-03-24 | Madison | Georgia | 13195 | 1 | 0 |
11134 | 11134 | 2020-03-25 | Madison | Georgia | 13195 | 2 | 0 |
12685 | 12685 | 2020-03-26 | Madison | Georgia | 13195 | 3 | 0 |
14359 | 14359 | 2020-03-27 | Madison | Georgia | 13195 | 3 | 0 |
16146 | 16146 | 2020-03-28 | Madison | Georgia | 13195 | 3 | 0 |
18043 | 18043 | 2020-03-29 | Madison | Georgia | 13195 | 3 | 0 |
20035 | 20035 | 2020-03-30 | Madison | Georgia | 13195 | 3 | 1 |
22116 | 22116 | 2020-03-31 | Madison | Georgia | 13195 | 3 | 1 |
24280 | 24280 | 2020-04-01 | Madison | Georgia | 13195 | 3 | 1 |
26511 | 26511 | 2020-04-02 | Madison | Georgia | 13195 | 5 | 1 |
28815 | 28815 | 2020-04-03 | Madison | Georgia | 13195 | 7 | 1 |
31175 | 31175 | 2020-04-04 | Madison | Georgia | 13195 | 7 | 1 |
33582 | 33582 | 2020-04-05 | Madison | Georgia | 13195 | 7 | 1 |
36032 | 36032 | 2020-04-06 | Madison | Georgia | 13195 | 9 | 1 |
38525 | 38525 | 2020-04-07 | Madison | Georgia | 13195 | 9 | 1 |
41069 | 41069 | 2020-04-08 | Madison | Georgia | 13195 | 10 | 1 |
43643 | 43643 | 2020-04-09 | Madison | Georgia | 13195 | 10 | 1 |
46245 | 46245 | 2020-04-10 | Madison | Georgia | 13195 | 10 | 1 |
48875 | 48875 | 2020-04-11 | Madison | Georgia | 13195 | 10 | 1 |
51537 | 51537 | 2020-04-12 | Madison | Georgia | 13195 | 10 | 1 |
54217 | 54217 | 2020-04-13 | Madison | Georgia | 13195 | 11 | 1 |
56909 | 56909 | 2020-04-14 | Madison | Georgia | 13195 | 12 | 1 |
59616 | 59616 | 2020-04-15 | Madison | Georgia | 13195 | 13 | 1 |
62336 | 62336 | 2020-04-16 | Madison | Georgia | 13195 | 14 | 1 |
65069 | 65069 | 2020-04-17 | Madison | Georgia | 13195 | 14 | 1 |
67817 | 67817 | 2020-04-18 | Madison | Georgia | 13195 | 14 | 1 |
70579 | 70579 | 2020-04-19 | Madison | Georgia | 13195 | 14 | 1 |
73348 | 73348 | 2020-04-20 | Madison | Georgia | 13195 | 15 | 1 |
76124 | 76124 | 2020-04-21 | Madison | Georgia | 13195 | 17 | 1 |
78908 | 78908 | 2020-04-22 | Madison | Georgia | 13195 | 18 | 1 |
81701 | 81701 | 2020-04-23 | Madison | Georgia | 13195 | 19 | 1 |
84501 | 84501 | 2020-04-24 | Madison | Georgia | 13195 | 21 | 1 |
87310 | 87310 | 2020-04-25 | Madison | Georgia | 13195 | 23 | 1 |
90126 | 90126 | 2020-04-26 | Madison | Georgia | 13195 | 22 | 1 |
92945 | 92945 | 2020-04-27 | Madison | Georgia | 13195 | 22 | 1 |
95777 | 95777 | 2020-04-28 | Madison | Georgia | 13195 | 23 | 1 |
98622 | 98622 | 2020-04-29 | Madison | Georgia | 13195 | 24 | 1 |
101472 | 101472 | 2020-04-30 | Madison | Georgia | 13195 | 24 | 1 |
104327 | 104327 | 2020-05-01 | Madison | Georgia | 13195 | 24 | 1 |
107192 | 107192 | 2020-05-02 | Madison | Georgia | 13195 | 24 | 1 |
110061 | 110061 | 2020-05-03 | Madison | Georgia | 13195 | 25 | 1 |
112936 | 112936 | 2020-05-04 | Madison | Georgia | 13195 | 26 | 1 |
115819 | 115819 | 2020-05-05 | Madison | Georgia | 13195 | 27 | 1 |
118779 | 118779 | 2020-05-06 | Madison | Georgia | 13195 | 27 | 1 |
121749 | 121749 | 2020-05-07 | Madison | Georgia | 13195 | 28 | 1 |
124728 | 124728 | 2020-05-08 | Madison | Georgia | 13195 | 28 | 1 |
127715 | 127715 | 2020-05-09 | Madison | Georgia | 13195 | 29 | 1 |
130706 | 130706 | 2020-05-10 | Madison | Georgia | 13195 | 29 | 1 |
133697 | 133697 | 2020-05-11 | Madison | Georgia | 13195 | 29 | 1 |
136686 | 136686 | 2020-05-12 | Madison | Georgia | 13195 | 29 | 1 |
139677 | 139677 | 2020-05-13 | Madison | Georgia | 13195 | 29 | 1 |
142673 | 142673 | 2020-05-14 | Madison | Georgia | 13195 | 29 | 1 |
145673 | 145673 | 2020-05-15 | Madison | Georgia | 13195 | 29 | 1 |
148676 | 148676 | 2020-05-16 | Madison | Georgia | 13195 | 29 | 1 |
151685 | 151685 | 2020-05-17 | Madison | Georgia | 13195 | 29 | 1 |
154697 | 154697 | 2020-05-18 | Madison | Georgia | 13195 | 29 | 1 |
157713 | 157713 | 2020-05-19 | Madison | Georgia | 13195 | 30 | 1 |
160739 | 160739 | 2020-05-20 | Madison | Georgia | 13195 | 32 | 1 |
163767 | 163767 | 2020-05-21 | Madison | Georgia | 13195 | 32 | 1 |
166800 | 166800 | 2020-05-22 | Madison | Georgia | 13195 | 32 | 1 |
169837 | 169837 | 2020-05-23 | Madison | Georgia | 13195 | 37 | 1 |
172878 | 172878 | 2020-05-24 | Madison | Georgia | 13195 | 38 | 1 |
175921 | 175921 | 2020-05-25 | Madison | Georgia | 13195 | 39 | 1 |
178965 | 178965 | 2020-05-26 | Madison | Georgia | 13195 | 41 | 1 |
182009 | 182009 | 2020-05-27 | Madison | Georgia | 13195 | 44 | 1 |
185063 | 185063 | 2020-05-28 | Madison | Georgia | 13195 | 49 | 1 |
188119 | 188119 | 2020-05-29 | Madison | Georgia | 13195 | 54 | 1 |
191184 | 191184 | 2020-05-30 | Madison | Georgia | 13195 | 54 | 1 |
194251 | 194251 | 2020-05-31 | Madison | Georgia | 13195 | 54 | 1 |
197321 | 197321 | 2020-06-01 | Madison | Georgia | 13195 | 55 | 1 |
200394 | 200394 | 2020-06-02 | Madison | Georgia | 13195 | 56 | 1 |
203470 | 203470 | 2020-06-03 | Madison | Georgia | 13195 | 59 | 1 |
206550 | 206550 | 2020-06-04 | Madison | Georgia | 13195 | 61 | 1 |
209631 | 209631 | 2020-06-05 | Madison | Georgia | 13195 | 65 | 1 |
212716 | 212716 | 2020-06-06 | Madison | Georgia | 13195 | 65 | 1 |
215803 | 215803 | 2020-06-07 | Madison | Georgia | 13195 | 65 | 1 |
218894 | 218894 | 2020-06-08 | Madison | Georgia | 13195 | 65 | 1 |
221989 | 221989 | 2020-06-09 | Madison | Georgia | 13195 | 66 | 2 |
225084 | 225084 | 2020-06-10 | Madison | Georgia | 13195 | 67 | 2 |
228186 | 228186 | 2020-06-11 | Madison | Georgia | 13195 | 68 | 2 |
231289 | 231289 | 2020-06-12 | Madison | Georgia | 13195 | 72 | 2 |
234395 | 234395 | 2020-06-13 | Madison | Georgia | 13195 | 73 | 2 |
237502 | 237502 | 2020-06-14 | Madison | Georgia | 13195 | 73 | 2 |
240610 | 240610 | 2020-06-15 | Madison | Georgia | 13195 | 73 | 2 |
243721 | 243721 | 2020-06-16 | Madison | Georgia | 13195 | 74 | 2 |
246834 | 246834 | 2020-06-17 | Madison | Georgia | 13195 | 75 | 2 |
249946 | 249946 | 2020-06-18 | Madison | Georgia | 13195 | 75 | 2 |
253061 | 253061 | 2020-06-19 | Madison | Georgia | 13195 | 77 | 4 |
256180 | 256180 | 2020-06-20 | Madison | Georgia | 13195 | 77 | 4 |
259307 | 259307 | 2020-06-21 | Madison | Georgia | 13195 | 78 | 4 |
262434 | 262434 | 2020-06-22 | Madison | Georgia | 13195 | 78 | 4 |
265562 | 265562 | 2020-06-23 | Madison | Georgia | 13195 | 78 | 4 |
268692 | 268692 | 2020-06-24 | Madison | Georgia | 13195 | 83 | 4 |
271828 | 271828 | 2020-06-25 | Madison | Georgia | 13195 | 86 | 4 |
274968 | 274968 | 2020-06-26 | Madison | Georgia | 13195 | 86 | 4 |
278116 | 278116 | 2020-06-27 | Madison | Georgia | 13195 | 87 | 4 |
281263 | 281263 | 2020-06-28 | Madison | Georgia | 13195 | 89 | 4 |
284409 | 284409 | 2020-06-29 | Madison | Georgia | 13195 | 89 | 4 |
287555 | 287555 | 2020-06-30 | Madison | Georgia | 13195 | 92 | 4 |
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);