ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Early" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4566 | 4566 | 2020-03-19 | Early | Georgia | 13099 | 2 | 1 |
5350 | 5350 | 2020-03-20 | Early | Georgia | 13099 | 2 | 1 |
6283 | 6283 | 2020-03-21 | Early | Georgia | 13099 | 2 | 1 |
7329 | 7329 | 2020-03-22 | Early | Georgia | 13099 | 2 | 1 |
8477 | 8477 | 2020-03-23 | Early | Georgia | 13099 | 2 | 1 |
9728 | 9728 | 2020-03-24 | Early | Georgia | 13099 | 5 | 1 |
11105 | 11105 | 2020-03-25 | Early | Georgia | 13099 | 6 | 1 |
12654 | 12654 | 2020-03-26 | Early | Georgia | 13099 | 7 | 1 |
14326 | 14326 | 2020-03-27 | Early | Georgia | 13099 | 13 | 1 |
16112 | 16112 | 2020-03-28 | Early | Georgia | 13099 | 16 | 1 |
18009 | 18009 | 2020-03-29 | Early | Georgia | 13099 | 16 | 1 |
19998 | 19998 | 2020-03-30 | Early | Georgia | 13099 | 20 | 2 |
22077 | 22077 | 2020-03-31 | Early | Georgia | 13099 | 32 | 1 |
24240 | 24240 | 2020-04-01 | Early | Georgia | 13099 | 34 | 1 |
26471 | 26471 | 2020-04-02 | Early | Georgia | 13099 | 42 | 1 |
28774 | 28774 | 2020-04-03 | Early | Georgia | 13099 | 61 | 1 |
31134 | 31134 | 2020-04-04 | Early | Georgia | 13099 | 64 | 1 |
33541 | 33541 | 2020-04-05 | Early | Georgia | 13099 | 70 | 1 |
35989 | 35989 | 2020-04-06 | Early | Georgia | 13099 | 81 | 5 |
38481 | 38481 | 2020-04-07 | Early | Georgia | 13099 | 96 | 5 |
41025 | 41025 | 2020-04-08 | Early | Georgia | 13099 | 97 | 5 |
43599 | 43599 | 2020-04-09 | Early | Georgia | 13099 | 105 | 5 |
46201 | 46201 | 2020-04-10 | Early | Georgia | 13099 | 107 | 6 |
48831 | 48831 | 2020-04-11 | Early | Georgia | 13099 | 120 | 6 |
51492 | 51492 | 2020-04-12 | Early | Georgia | 13099 | 125 | 6 |
54172 | 54172 | 2020-04-13 | Early | Georgia | 13099 | 128 | 6 |
56864 | 56864 | 2020-04-14 | Early | Georgia | 13099 | 137 | 6 |
59571 | 59571 | 2020-04-15 | Early | Georgia | 13099 | 145 | 6 |
62291 | 62291 | 2020-04-16 | Early | Georgia | 13099 | 148 | 8 |
65024 | 65024 | 2020-04-17 | Early | Georgia | 13099 | 163 | 8 |
67772 | 67772 | 2020-04-18 | Early | Georgia | 13099 | 165 | 8 |
70534 | 70534 | 2020-04-19 | Early | Georgia | 13099 | 170 | 8 |
73303 | 73303 | 2020-04-20 | Early | Georgia | 13099 | 173 | 10 |
76079 | 76079 | 2020-04-21 | Early | Georgia | 13099 | 174 | 10 |
78863 | 78863 | 2020-04-22 | Early | Georgia | 13099 | 184 | 12 |
81656 | 81656 | 2020-04-23 | Early | Georgia | 13099 | 185 | 15 |
84456 | 84456 | 2020-04-24 | Early | Georgia | 13099 | 188 | 15 |
87265 | 87265 | 2020-04-25 | Early | Georgia | 13099 | 194 | 15 |
90081 | 90081 | 2020-04-26 | Early | Georgia | 13099 | 198 | 15 |
92900 | 92900 | 2020-04-27 | Early | Georgia | 13099 | 202 | 15 |
95732 | 95732 | 2020-04-28 | Early | Georgia | 13099 | 208 | 15 |
98577 | 98577 | 2020-04-29 | Early | Georgia | 13099 | 214 | 21 |
101427 | 101427 | 2020-04-30 | Early | Georgia | 13099 | 213 | 20 |
104282 | 104282 | 2020-05-01 | Early | Georgia | 13099 | 214 | 20 |
107147 | 107147 | 2020-05-02 | Early | Georgia | 13099 | 214 | 20 |
110016 | 110016 | 2020-05-03 | Early | Georgia | 13099 | 219 | 20 |
112891 | 112891 | 2020-05-04 | Early | Georgia | 13099 | 221 | 24 |
115774 | 115774 | 2020-05-05 | Early | Georgia | 13099 | 222 | 27 |
118734 | 118734 | 2020-05-06 | Early | Georgia | 13099 | 221 | 25 |
121703 | 121703 | 2020-05-07 | Early | Georgia | 13099 | 224 | 26 |
124682 | 124682 | 2020-05-08 | Early | Georgia | 13099 | 224 | 26 |
127669 | 127669 | 2020-05-09 | Early | Georgia | 13099 | 226 | 26 |
130660 | 130660 | 2020-05-10 | Early | Georgia | 13099 | 226 | 26 |
133651 | 133651 | 2020-05-11 | Early | Georgia | 13099 | 226 | 26 |
136640 | 136640 | 2020-05-12 | Early | Georgia | 13099 | 228 | 27 |
139631 | 139631 | 2020-05-13 | Early | Georgia | 13099 | 229 | 29 |
142627 | 142627 | 2020-05-14 | Early | Georgia | 13099 | 238 | 28 |
145627 | 145627 | 2020-05-15 | Early | Georgia | 13099 | 233 | 28 |
148630 | 148630 | 2020-05-16 | Early | Georgia | 13099 | 233 | 28 |
151639 | 151639 | 2020-05-17 | Early | Georgia | 13099 | 233 | 28 |
154651 | 154651 | 2020-05-18 | Early | Georgia | 13099 | 231 | 28 |
157667 | 157667 | 2020-05-19 | Early | Georgia | 13099 | 234 | 28 |
160693 | 160693 | 2020-05-20 | Early | Georgia | 13099 | 236 | 29 |
163721 | 163721 | 2020-05-21 | Early | Georgia | 13099 | 235 | 29 |
166754 | 166754 | 2020-05-22 | Early | Georgia | 13099 | 234 | 29 |
169791 | 169791 | 2020-05-23 | Early | Georgia | 13099 | 236 | 29 |
172832 | 172832 | 2020-05-24 | Early | Georgia | 13099 | 234 | 29 |
175875 | 175875 | 2020-05-25 | Early | Georgia | 13099 | 235 | 29 |
178919 | 178919 | 2020-05-26 | Early | Georgia | 13099 | 236 | 30 |
181963 | 181963 | 2020-05-27 | Early | Georgia | 13099 | 239 | 30 |
185017 | 185017 | 2020-05-28 | Early | Georgia | 13099 | 238 | 30 |
188073 | 188073 | 2020-05-29 | Early | Georgia | 13099 | 238 | 31 |
191138 | 191138 | 2020-05-30 | Early | Georgia | 13099 | 238 | 31 |
194205 | 194205 | 2020-05-31 | Early | Georgia | 13099 | 238 | 31 |
197275 | 197275 | 2020-06-01 | Early | Georgia | 13099 | 241 | 31 |
200348 | 200348 | 2020-06-02 | Early | Georgia | 13099 | 244 | 31 |
203424 | 203424 | 2020-06-03 | Early | Georgia | 13099 | 247 | 32 |
206504 | 206504 | 2020-06-04 | Early | Georgia | 13099 | 247 | 32 |
209585 | 209585 | 2020-06-05 | Early | Georgia | 13099 | 247 | 32 |
212670 | 212670 | 2020-06-06 | Early | Georgia | 13099 | 250 | 32 |
215757 | 215757 | 2020-06-07 | Early | Georgia | 13099 | 249 | 31 |
218848 | 218848 | 2020-06-08 | Early | Georgia | 13099 | 249 | 31 |
221943 | 221943 | 2020-06-09 | Early | Georgia | 13099 | 252 | 31 |
225038 | 225038 | 2020-06-10 | Early | Georgia | 13099 | 253 | 31 |
228140 | 228140 | 2020-06-11 | Early | Georgia | 13099 | 254 | 31 |
231243 | 231243 | 2020-06-12 | Early | Georgia | 13099 | 254 | 31 |
234349 | 234349 | 2020-06-13 | Early | Georgia | 13099 | 255 | 31 |
237456 | 237456 | 2020-06-14 | Early | Georgia | 13099 | 255 | 31 |
240564 | 240564 | 2020-06-15 | Early | Georgia | 13099 | 255 | 31 |
243675 | 243675 | 2020-06-16 | Early | Georgia | 13099 | 255 | 31 |
246788 | 246788 | 2020-06-17 | Early | Georgia | 13099 | 256 | 31 |
249900 | 249900 | 2020-06-18 | Early | Georgia | 13099 | 252 | 31 |
253015 | 253015 | 2020-06-19 | Early | Georgia | 13099 | 256 | 31 |
256134 | 256134 | 2020-06-20 | Early | Georgia | 13099 | 256 | 31 |
259261 | 259261 | 2020-06-21 | Early | Georgia | 13099 | 256 | 31 |
262388 | 262388 | 2020-06-22 | Early | Georgia | 13099 | 255 | 31 |
265516 | 265516 | 2020-06-23 | Early | Georgia | 13099 | 255 | 31 |
268646 | 268646 | 2020-06-24 | Early | Georgia | 13099 | 257 | 31 |
271782 | 271782 | 2020-06-25 | Early | Georgia | 13099 | 258 | 31 |
274922 | 274922 | 2020-06-26 | Early | Georgia | 13099 | 259 | 31 |
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);