ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 6, fips = 13149 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 |
---|---|---|---|---|---|---|---|
716450 | 716450 | 2020-11-10 | Heard | Georgia | 13149 | 317 | 6 |
713206 | 713206 | 2020-11-09 | Heard | Georgia | 13149 | 312 | 6 |
709962 | 709962 | 2020-11-08 | Heard | Georgia | 13149 | 310 | 6 |
706718 | 706718 | 2020-11-07 | Heard | Georgia | 13149 | 309 | 6 |
703475 | 703475 | 2020-11-06 | Heard | Georgia | 13149 | 309 | 6 |
700232 | 700232 | 2020-11-05 | Heard | Georgia | 13149 | 304 | 6 |
696988 | 696988 | 2020-11-04 | Heard | Georgia | 13149 | 300 | 6 |
693746 | 693746 | 2020-11-03 | Heard | Georgia | 13149 | 291 | 6 |
690503 | 690503 | 2020-11-02 | Heard | Georgia | 13149 | 290 | 6 |
687258 | 687258 | 2020-11-01 | Heard | Georgia | 13149 | 284 | 6 |
684014 | 684014 | 2020-10-31 | Heard | Georgia | 13149 | 283 | 6 |
680771 | 680771 | 2020-10-30 | Heard | Georgia | 13149 | 280 | 6 |
677528 | 677528 | 2020-10-29 | Heard | Georgia | 13149 | 277 | 6 |
674285 | 674285 | 2020-10-28 | Heard | Georgia | 13149 | 272 | 6 |
671043 | 671043 | 2020-10-27 | Heard | Georgia | 13149 | 271 | 6 |
667800 | 667800 | 2020-10-26 | Heard | Georgia | 13149 | 270 | 6 |
664555 | 664555 | 2020-10-25 | Heard | Georgia | 13149 | 262 | 6 |
661311 | 661311 | 2020-10-24 | Heard | Georgia | 13149 | 261 | 6 |
658067 | 658067 | 2020-10-23 | Heard | Georgia | 13149 | 259 | 6 |
654822 | 654822 | 2020-10-22 | Heard | Georgia | 13149 | 254 | 6 |
651577 | 651577 | 2020-10-21 | Heard | Georgia | 13149 | 250 | 6 |
648333 | 648333 | 2020-10-20 | Heard | Georgia | 13149 | 249 | 6 |
645088 | 645088 | 2020-10-19 | Heard | Georgia | 13149 | 249 | 6 |
641840 | 641840 | 2020-10-18 | Heard | Georgia | 13149 | 245 | 6 |
638593 | 638593 | 2020-10-17 | Heard | Georgia | 13149 | 245 | 6 |
635348 | 635348 | 2020-10-16 | Heard | Georgia | 13149 | 242 | 6 |
632102 | 632102 | 2020-10-15 | Heard | Georgia | 13149 | 240 | 6 |
628858 | 628858 | 2020-10-14 | Heard | Georgia | 13149 | 239 | 6 |
625615 | 625615 | 2020-10-13 | Heard | Georgia | 13149 | 239 | 6 |
622372 | 622372 | 2020-10-12 | Heard | Georgia | 13149 | 238 | 6 |
619129 | 619129 | 2020-10-11 | Heard | Georgia | 13149 | 235 | 6 |
615887 | 615887 | 2020-10-10 | Heard | Georgia | 13149 | 235 | 6 |
612646 | 612646 | 2020-10-09 | Heard | Georgia | 13149 | 234 | 6 |
609404 | 609404 | 2020-10-08 | Heard | Georgia | 13149 | 233 | 6 |
606161 | 606161 | 2020-10-07 | Heard | Georgia | 13149 | 233 | 6 |
602919 | 602919 | 2020-10-06 | Heard | Georgia | 13149 | 233 | 6 |
599676 | 599676 | 2020-10-05 | Heard | Georgia | 13149 | 233 | 6 |
596433 | 596433 | 2020-10-04 | Heard | Georgia | 13149 | 201 | 6 |
593191 | 593191 | 2020-10-03 | Heard | Georgia | 13149 | 201 | 6 |
589951 | 589951 | 2020-10-02 | Heard | Georgia | 13149 | 200 | 6 |
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);