ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Marion" and fips = 13197 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635370 | 635370 | 2020-10-16 | Marion | Georgia | 13197 | 219 | 9 |
632124 | 632124 | 2020-10-15 | Marion | Georgia | 13197 | 219 | 9 |
628880 | 628880 | 2020-10-14 | Marion | Georgia | 13197 | 218 | 9 |
625637 | 625637 | 2020-10-13 | Marion | Georgia | 13197 | 219 | 9 |
622394 | 622394 | 2020-10-12 | Marion | Georgia | 13197 | 218 | 9 |
619151 | 619151 | 2020-10-11 | Marion | Georgia | 13197 | 218 | 9 |
615909 | 615909 | 2020-10-10 | Marion | Georgia | 13197 | 218 | 9 |
612668 | 612668 | 2020-10-09 | Marion | Georgia | 13197 | 218 | 9 |
609426 | 609426 | 2020-10-08 | Marion | Georgia | 13197 | 218 | 9 |
606183 | 606183 | 2020-10-07 | Marion | Georgia | 13197 | 217 | 9 |
602941 | 602941 | 2020-10-06 | Marion | Georgia | 13197 | 217 | 9 |
599698 | 599698 | 2020-10-05 | Marion | Georgia | 13197 | 217 | 9 |
596455 | 596455 | 2020-10-04 | Marion | Georgia | 13197 | 193 | 9 |
593213 | 593213 | 2020-10-03 | Marion | Georgia | 13197 | 193 | 9 |
589973 | 589973 | 2020-10-02 | Marion | Georgia | 13197 | 192 | 8 |
586732 | 586732 | 2020-10-01 | Marion | Georgia | 13197 | 192 | 8 |
583492 | 583492 | 2020-09-30 | Marion | Georgia | 13197 | 192 | 8 |
580253 | 580253 | 2020-09-29 | Marion | Georgia | 13197 | 191 | 8 |
577012 | 577012 | 2020-09-28 | Marion | Georgia | 13197 | 190 | 8 |
573769 | 573769 | 2020-09-27 | Marion | Georgia | 13197 | 190 | 8 |
570527 | 570527 | 2020-09-26 | Marion | Georgia | 13197 | 190 | 8 |
567285 | 567285 | 2020-09-25 | Marion | Georgia | 13197 | 190 | 8 |
564045 | 564045 | 2020-09-24 | Marion | Georgia | 13197 | 189 | 8 |
560805 | 560805 | 2020-09-23 | Marion | Georgia | 13197 | 189 | 8 |
557569 | 557569 | 2020-09-22 | Marion | Georgia | 13197 | 189 | 8 |
554332 | 554332 | 2020-09-21 | Marion | Georgia | 13197 | 187 | 8 |
551093 | 551093 | 2020-09-20 | Marion | Georgia | 13197 | 187 | 8 |
547854 | 547854 | 2020-09-19 | Marion | Georgia | 13197 | 185 | 8 |
544616 | 544616 | 2020-09-18 | Marion | Georgia | 13197 | 185 | 8 |
541380 | 541380 | 2020-09-17 | Marion | Georgia | 13197 | 185 | 8 |
538143 | 538143 | 2020-09-16 | Marion | Georgia | 13197 | 184 | 8 |
534907 | 534907 | 2020-09-15 | Marion | Georgia | 13197 | 181 | 8 |
531672 | 531672 | 2020-09-14 | Marion | Georgia | 13197 | 180 | 7 |
528435 | 528435 | 2020-09-13 | Marion | Georgia | 13197 | 178 | 7 |
525199 | 525199 | 2020-09-12 | Marion | Georgia | 13197 | 178 | 7 |
521963 | 521963 | 2020-09-11 | Marion | Georgia | 13197 | 178 | 7 |
518726 | 518726 | 2020-09-10 | Marion | Georgia | 13197 | 178 | 6 |
515491 | 515491 | 2020-09-09 | Marion | Georgia | 13197 | 178 | 6 |
512258 | 512258 | 2020-09-08 | Marion | Georgia | 13197 | 178 | 6 |
509025 | 509025 | 2020-09-07 | Marion | Georgia | 13197 | 178 | 6 |
505793 | 505793 | 2020-09-06 | Marion | Georgia | 13197 | 178 | 6 |
502559 | 502559 | 2020-09-05 | Marion | Georgia | 13197 | 178 | 6 |
499325 | 499325 | 2020-09-04 | Marion | Georgia | 13197 | 178 | 6 |
496092 | 496092 | 2020-09-03 | Marion | Georgia | 13197 | 176 | 6 |
492858 | 492858 | 2020-09-02 | Marion | Georgia | 13197 | 172 | 6 |
489625 | 489625 | 2020-09-01 | Marion | Georgia | 13197 | 171 | 6 |
486392 | 486392 | 2020-08-31 | Marion | Georgia | 13197 | 170 | 6 |
483157 | 483157 | 2020-08-30 | Marion | Georgia | 13197 | 169 | 6 |
479923 | 479923 | 2020-08-29 | Marion | Georgia | 13197 | 169 | 6 |
476690 | 476690 | 2020-08-28 | Marion | Georgia | 13197 | 166 | 6 |
473457 | 473457 | 2020-08-27 | Marion | Georgia | 13197 | 165 | 6 |
470225 | 470225 | 2020-08-26 | Marion | Georgia | 13197 | 165 | 5 |
466996 | 466996 | 2020-08-25 | Marion | Georgia | 13197 | 163 | 5 |
463767 | 463767 | 2020-08-24 | Marion | Georgia | 13197 | 163 | 5 |
460538 | 460538 | 2020-08-23 | Marion | Georgia | 13197 | 163 | 5 |
457311 | 457311 | 2020-08-22 | Marion | Georgia | 13197 | 164 | 5 |
454083 | 454083 | 2020-08-21 | Marion | Georgia | 13197 | 164 | 5 |
450855 | 450855 | 2020-08-20 | Marion | Georgia | 13197 | 164 | 5 |
447627 | 447627 | 2020-08-19 | Marion | Georgia | 13197 | 163 | 5 |
444400 | 444400 | 2020-08-18 | Marion | Georgia | 13197 | 162 | 5 |
441174 | 441174 | 2020-08-17 | Marion | Georgia | 13197 | 162 | 5 |
437948 | 437948 | 2020-08-16 | Marion | Georgia | 13197 | 162 | 5 |
434722 | 434722 | 2020-08-15 | Marion | Georgia | 13197 | 161 | 5 |
431497 | 431497 | 2020-08-14 | Marion | Georgia | 13197 | 161 | 5 |
428269 | 428269 | 2020-08-13 | Marion | Georgia | 13197 | 157 | 5 |
425045 | 425045 | 2020-08-12 | Marion | Georgia | 13197 | 156 | 5 |
421824 | 421824 | 2020-08-11 | Marion | Georgia | 13197 | 152 | 5 |
418603 | 418603 | 2020-08-10 | Marion | Georgia | 13197 | 150 | 5 |
415382 | 415382 | 2020-08-09 | Marion | Georgia | 13197 | 150 | 5 |
412162 | 412162 | 2020-08-08 | Marion | Georgia | 13197 | 150 | 5 |
408943 | 408943 | 2020-08-07 | Marion | Georgia | 13197 | 147 | 4 |
405723 | 405723 | 2020-08-06 | Marion | Georgia | 13197 | 147 | 4 |
402505 | 402505 | 2020-08-05 | Marion | Georgia | 13197 | 145 | 4 |
399289 | 399289 | 2020-08-04 | Marion | Georgia | 13197 | 145 | 4 |
396073 | 396073 | 2020-08-03 | Marion | Georgia | 13197 | 145 | 4 |
392857 | 392857 | 2020-08-02 | Marion | Georgia | 13197 | 143 | 4 |
389640 | 389640 | 2020-08-01 | Marion | Georgia | 13197 | 142 | 4 |
386423 | 386423 | 2020-07-31 | Marion | Georgia | 13197 | 136 | 4 |
383205 | 383205 | 2020-07-30 | Marion | Georgia | 13197 | 131 | 4 |
379988 | 379988 | 2020-07-29 | Marion | Georgia | 13197 | 128 | 4 |
376771 | 376771 | 2020-07-28 | Marion | Georgia | 13197 | 126 | 4 |
373557 | 373557 | 2020-07-27 | Marion | Georgia | 13197 | 126 | 4 |
370345 | 370345 | 2020-07-26 | Marion | Georgia | 13197 | 125 | 4 |
367135 | 367135 | 2020-07-25 | Marion | Georgia | 13197 | 122 | 4 |
363928 | 363928 | 2020-07-24 | Marion | Georgia | 13197 | 117 | 4 |
360721 | 360721 | 2020-07-23 | Marion | Georgia | 13197 | 113 | 4 |
357516 | 357516 | 2020-07-22 | Marion | Georgia | 13197 | 113 | 4 |
354313 | 354313 | 2020-07-21 | Marion | Georgia | 13197 | 114 | 3 |
351111 | 351111 | 2020-07-20 | Marion | Georgia | 13197 | 111 | 3 |
347910 | 347910 | 2020-07-19 | Marion | Georgia | 13197 | 111 | 3 |
344710 | 344710 | 2020-07-18 | Marion | Georgia | 13197 | 109 | 3 |
341511 | 341511 | 2020-07-17 | Marion | Georgia | 13197 | 108 | 3 |
338314 | 338314 | 2020-07-16 | Marion | Georgia | 13197 | 105 | 3 |
335119 | 335119 | 2020-07-15 | Marion | Georgia | 13197 | 105 | 3 |
331926 | 331926 | 2020-07-14 | Marion | Georgia | 13197 | 101 | 3 |
328739 | 328739 | 2020-07-13 | Marion | Georgia | 13197 | 100 | 3 |
325553 | 325553 | 2020-07-12 | Marion | Georgia | 13197 | 100 | 3 |
322372 | 322372 | 2020-07-11 | Marion | Georgia | 13197 | 99 | 3 |
319193 | 319193 | 2020-07-10 | Marion | Georgia | 13197 | 97 | 3 |
316020 | 316020 | 2020-07-09 | Marion | Georgia | 13197 | 88 | 2 |
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);