ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where county = "Long", deaths = 3 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
606178 | 606178 | 2020-10-07 | Long | Georgia | 13183 | 272 | 3 |
602936 | 602936 | 2020-10-06 | Long | Georgia | 13183 | 272 | 3 |
599693 | 599693 | 2020-10-05 | Long | Georgia | 13183 | 271 | 3 |
596450 | 596450 | 2020-10-04 | Long | Georgia | 13183 | 256 | 3 |
593208 | 593208 | 2020-10-03 | Long | Georgia | 13183 | 255 | 3 |
589968 | 589968 | 2020-10-02 | Long | Georgia | 13183 | 252 | 3 |
586727 | 586727 | 2020-10-01 | Long | Georgia | 13183 | 253 | 3 |
583487 | 583487 | 2020-09-30 | Long | Georgia | 13183 | 252 | 3 |
580248 | 580248 | 2020-09-29 | Long | Georgia | 13183 | 251 | 3 |
577007 | 577007 | 2020-09-28 | Long | Georgia | 13183 | 251 | 3 |
573764 | 573764 | 2020-09-27 | Long | Georgia | 13183 | 251 | 3 |
570522 | 570522 | 2020-09-26 | Long | Georgia | 13183 | 251 | 3 |
567280 | 567280 | 2020-09-25 | Long | Georgia | 13183 | 246 | 3 |
564040 | 564040 | 2020-09-24 | Long | Georgia | 13183 | 245 | 3 |
560800 | 560800 | 2020-09-23 | Long | Georgia | 13183 | 235 | 3 |
557564 | 557564 | 2020-09-22 | Long | Georgia | 13183 | 231 | 3 |
554327 | 554327 | 2020-09-21 | Long | Georgia | 13183 | 231 | 3 |
551088 | 551088 | 2020-09-20 | Long | Georgia | 13183 | 230 | 3 |
547849 | 547849 | 2020-09-19 | Long | Georgia | 13183 | 230 | 3 |
544611 | 544611 | 2020-09-18 | Long | Georgia | 13183 | 226 | 3 |
541375 | 541375 | 2020-09-17 | Long | Georgia | 13183 | 221 | 3 |
538138 | 538138 | 2020-09-16 | Long | Georgia | 13183 | 218 | 3 |
534902 | 534902 | 2020-09-15 | Long | Georgia | 13183 | 216 | 3 |
531667 | 531667 | 2020-09-14 | Long | Georgia | 13183 | 212 | 3 |
528430 | 528430 | 2020-09-13 | Long | Georgia | 13183 | 212 | 3 |
525194 | 525194 | 2020-09-12 | Long | Georgia | 13183 | 209 | 3 |
521958 | 521958 | 2020-09-11 | Long | Georgia | 13183 | 204 | 3 |
518721 | 518721 | 2020-09-10 | Long | Georgia | 13183 | 198 | 3 |
515486 | 515486 | 2020-09-09 | Long | Georgia | 13183 | 197 | 3 |
512253 | 512253 | 2020-09-08 | Long | Georgia | 13183 | 195 | 3 |
509020 | 509020 | 2020-09-07 | Long | Georgia | 13183 | 194 | 3 |
505788 | 505788 | 2020-09-06 | Long | Georgia | 13183 | 194 | 3 |
502554 | 502554 | 2020-09-05 | Long | Georgia | 13183 | 192 | 3 |
499320 | 499320 | 2020-09-04 | Long | Georgia | 13183 | 191 | 3 |
496087 | 496087 | 2020-09-03 | Long | Georgia | 13183 | 190 | 3 |
492853 | 492853 | 2020-09-02 | Long | Georgia | 13183 | 186 | 3 |
489620 | 489620 | 2020-09-01 | Long | Georgia | 13183 | 184 | 3 |
486387 | 486387 | 2020-08-31 | Long | Georgia | 13183 | 183 | 3 |
483152 | 483152 | 2020-08-30 | Long | Georgia | 13183 | 184 | 3 |
479918 | 479918 | 2020-08-29 | Long | Georgia | 13183 | 182 | 3 |
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);