ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Clarke" and state = "Georgia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
265496 | 265496 | 2020-06-23 | Clarke | Georgia | 13059 | 408 | 15 |
268626 | 268626 | 2020-06-24 | Clarke | Georgia | 13059 | 419 | 15 |
271762 | 271762 | 2020-06-25 | Clarke | Georgia | 13059 | 441 | 15 |
274902 | 274902 | 2020-06-26 | Clarke | Georgia | 13059 | 463 | 15 |
278050 | 278050 | 2020-06-27 | Clarke | Georgia | 13059 | 481 | 15 |
281197 | 281197 | 2020-06-28 | Clarke | Georgia | 13059 | 485 | 15 |
284343 | 284343 | 2020-06-29 | Clarke | Georgia | 13059 | 490 | 15 |
287489 | 287489 | 2020-06-30 | Clarke | Georgia | 13059 | 531 | 15 |
290640 | 290640 | 2020-07-01 | Clarke | Georgia | 13059 | 574 | 15 |
293794 | 293794 | 2020-07-02 | Clarke | Georgia | 13059 | 607 | 15 |
296950 | 296950 | 2020-07-03 | Clarke | Georgia | 13059 | 661 | 15 |
300112 | 300112 | 2020-07-04 | Clarke | Georgia | 13059 | 690 | 15 |
303276 | 303276 | 2020-07-05 | Clarke | Georgia | 13059 | 714 | 15 |
306440 | 306440 | 2020-07-06 | Clarke | Georgia | 13059 | 738 | 15 |
309608 | 309608 | 2020-07-07 | Clarke | Georgia | 13059 | 775 | 15 |
312778 | 312778 | 2020-07-08 | Clarke | Georgia | 13059 | 804 | 15 |
315953 | 315953 | 2020-07-09 | Clarke | Georgia | 13059 | 841 | 15 |
319126 | 319126 | 2020-07-10 | Clarke | Georgia | 13059 | 897 | 15 |
322305 | 322305 | 2020-07-11 | Clarke | Georgia | 13059 | 925 | 15 |
325486 | 325486 | 2020-07-12 | Clarke | Georgia | 13059 | 939 | 15 |
328672 | 328672 | 2020-07-13 | Clarke | Georgia | 13059 | 977 | 15 |
331859 | 331859 | 2020-07-14 | Clarke | Georgia | 13059 | 1007 | 15 |
335052 | 335052 | 2020-07-15 | Clarke | Georgia | 13059 | 1045 | 15 |
338247 | 338247 | 2020-07-16 | Clarke | Georgia | 13059 | 1087 | 15 |
341444 | 341444 | 2020-07-17 | Clarke | Georgia | 13059 | 1140 | 15 |
344643 | 344643 | 2020-07-18 | Clarke | Georgia | 13059 | 1205 | 15 |
347843 | 347843 | 2020-07-19 | Clarke | Georgia | 13059 | 1238 | 15 |
351044 | 351044 | 2020-07-20 | Clarke | Georgia | 13059 | 1255 | 15 |
354246 | 354246 | 2020-07-21 | Clarke | Georgia | 13059 | 1286 | 15 |
357449 | 357449 | 2020-07-22 | Clarke | Georgia | 13059 | 1306 | 15 |
360654 | 360654 | 2020-07-23 | Clarke | Georgia | 13059 | 1356 | 15 |
363861 | 363861 | 2020-07-24 | Clarke | Georgia | 13059 | 1396 | 15 |
367068 | 367068 | 2020-07-25 | Clarke | Georgia | 13059 | 1439 | 15 |
370278 | 370278 | 2020-07-26 | Clarke | Georgia | 13059 | 1449 | 15 |
373490 | 373490 | 2020-07-27 | Clarke | Georgia | 13059 | 1475 | 15 |
376704 | 376704 | 2020-07-28 | Clarke | Georgia | 13059 | 1507 | 15 |
379921 | 379921 | 2020-07-29 | Clarke | Georgia | 13059 | 1557 | 16 |
383138 | 383138 | 2020-07-30 | Clarke | Georgia | 13059 | 1591 | 16 |
386356 | 386356 | 2020-07-31 | Clarke | Georgia | 13059 | 1665 | 17 |
389573 | 389573 | 2020-08-01 | Clarke | Georgia | 13059 | 1694 | 17 |
392790 | 392790 | 2020-08-02 | Clarke | Georgia | 13059 | 1717 | 17 |
396006 | 396006 | 2020-08-03 | Clarke | Georgia | 13059 | 1741 | 17 |
399222 | 399222 | 2020-08-04 | Clarke | Georgia | 13059 | 1794 | 17 |
402438 | 402438 | 2020-08-05 | Clarke | Georgia | 13059 | 1863 | 17 |
405656 | 405656 | 2020-08-06 | Clarke | Georgia | 13059 | 1894 | 18 |
408876 | 408876 | 2020-08-07 | Clarke | Georgia | 13059 | 1968 | 18 |
412095 | 412095 | 2020-08-08 | Clarke | Georgia | 13059 | 2027 | 18 |
415315 | 415315 | 2020-08-09 | Clarke | Georgia | 13059 | 2047 | 18 |
418536 | 418536 | 2020-08-10 | Clarke | Georgia | 13059 | 2081 | 18 |
421757 | 421757 | 2020-08-11 | Clarke | Georgia | 13059 | 2117 | 19 |
424978 | 424978 | 2020-08-12 | Clarke | Georgia | 13059 | 2150 | 19 |
428202 | 428202 | 2020-08-13 | Clarke | Georgia | 13059 | 2166 | 19 |
431430 | 431430 | 2020-08-14 | Clarke | Georgia | 13059 | 2209 | 21 |
434655 | 434655 | 2020-08-15 | Clarke | Georgia | 13059 | 2238 | 21 |
437881 | 437881 | 2020-08-16 | Clarke | Georgia | 13059 | 2250 | 21 |
441107 | 441107 | 2020-08-17 | Clarke | Georgia | 13059 | 2264 | 21 |
444333 | 444333 | 2020-08-18 | Clarke | Georgia | 13059 | 2305 | 21 |
447560 | 447560 | 2020-08-19 | Clarke | Georgia | 13059 | 2341 | 21 |
450788 | 450788 | 2020-08-20 | Clarke | Georgia | 13059 | 2372 | 22 |
454016 | 454016 | 2020-08-21 | Clarke | Georgia | 13059 | 2416 | 23 |
457244 | 457244 | 2020-08-22 | Clarke | Georgia | 13059 | 2473 | 24 |
460471 | 460471 | 2020-08-23 | Clarke | Georgia | 13059 | 2491 | 25 |
463700 | 463700 | 2020-08-24 | Clarke | Georgia | 13059 | 2511 | 25 |
466929 | 466929 | 2020-08-25 | Clarke | Georgia | 13059 | 2564 | 27 |
470158 | 470158 | 2020-08-26 | Clarke | Georgia | 13059 | 2628 | 26 |
473390 | 473390 | 2020-08-27 | Clarke | Georgia | 13059 | 2691 | 26 |
476623 | 476623 | 2020-08-28 | Clarke | Georgia | 13059 | 2737 | 26 |
479856 | 479856 | 2020-08-29 | Clarke | Georgia | 13059 | 2789 | 26 |
483090 | 483090 | 2020-08-30 | Clarke | Georgia | 13059 | 2842 | 26 |
486325 | 486325 | 2020-08-31 | Clarke | Georgia | 13059 | 2916 | 26 |
489558 | 489558 | 2020-09-01 | Clarke | Georgia | 13059 | 3070 | 30 |
492791 | 492791 | 2020-09-02 | Clarke | Georgia | 13059 | 3149 | 30 |
496025 | 496025 | 2020-09-03 | Clarke | Georgia | 13059 | 3322 | 31 |
499258 | 499258 | 2020-09-04 | Clarke | Georgia | 13059 | 3410 | 32 |
502492 | 502492 | 2020-09-05 | Clarke | Georgia | 13059 | 3687 | 34 |
505726 | 505726 | 2020-09-06 | Clarke | Georgia | 13059 | 3750 | 34 |
508958 | 508958 | 2020-09-07 | Clarke | Georgia | 13059 | 3788 | 34 |
512191 | 512191 | 2020-09-08 | Clarke | Georgia | 13059 | 3994 | 35 |
515424 | 515424 | 2020-09-09 | Clarke | Georgia | 13059 | 4109 | 35 |
518659 | 518659 | 2020-09-10 | Clarke | Georgia | 13059 | 4205 | 36 |
521896 | 521896 | 2020-09-11 | Clarke | Georgia | 13059 | 4314 | 36 |
525132 | 525132 | 2020-09-12 | Clarke | Georgia | 13059 | 4430 | 36 |
528368 | 528368 | 2020-09-13 | Clarke | Georgia | 13059 | 4503 | 36 |
531605 | 531605 | 2020-09-14 | Clarke | Georgia | 13059 | 4540 | 36 |
534840 | 534840 | 2020-09-15 | Clarke | Georgia | 13059 | 4639 | 37 |
538076 | 538076 | 2020-09-16 | Clarke | Georgia | 13059 | 4719 | 37 |
541313 | 541313 | 2020-09-17 | Clarke | Georgia | 13059 | 4775 | 38 |
544549 | 544549 | 2020-09-18 | Clarke | Georgia | 13059 | 4821 | 41 |
547787 | 547787 | 2020-09-19 | Clarke | Georgia | 13059 | 4855 | 41 |
551026 | 551026 | 2020-09-20 | Clarke | Georgia | 13059 | 4874 | 41 |
554265 | 554265 | 2020-09-21 | Clarke | Georgia | 13059 | 4890 | 41 |
557502 | 557502 | 2020-09-22 | Clarke | Georgia | 13059 | 4916 | 42 |
560738 | 560738 | 2020-09-23 | Clarke | Georgia | 13059 | 4939 | 42 |
563978 | 563978 | 2020-09-24 | Clarke | Georgia | 13059 | 4975 | 42 |
567218 | 567218 | 2020-09-25 | Clarke | Georgia | 13059 | 4997 | 43 |
570460 | 570460 | 2020-09-26 | Clarke | Georgia | 13059 | 5020 | 44 |
573702 | 573702 | 2020-09-27 | Clarke | Georgia | 13059 | 5024 | 44 |
576945 | 576945 | 2020-09-28 | Clarke | Georgia | 13059 | 5035 | 44 |
580186 | 580186 | 2020-09-29 | Clarke | Georgia | 13059 | 5064 | 44 |
583425 | 583425 | 2020-09-30 | Clarke | Georgia | 13059 | 5084 | 44 |
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);