ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
10,908 rows where county = "Greene" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 14
- Missouri 219
- New York 216
- Arkansas 211
- Tennessee 211
- Ohio 209
- Georgia 207
- Pennsylvania 206
- Virginia 205
- North Carolina 204
- Alabama 203
- Indiana 202
- Mississippi 194
- Iowa 193
- Illinois 190
fips 14
county 1
- Greene · 2,870 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635340 | 635340 | 2020-10-16 | Greene | Georgia | 13133 | 598 | 25 |
635514 | 635514 | 2020-10-16 | Greene | Illinois | 17061 | 260 | 15 |
635614 | 635614 | 2020-10-16 | Greene | Indiana | 18055 | 498 | 39 |
635715 | 635715 | 2020-10-16 | Greene | Iowa | 19073 | 168 | 0 |
636319 | 636319 | 2020-10-16 | Greene | Mississippi | 28041 | 444 | 17 |
636419 | 636419 | 2020-10-16 | Greene | Missouri | 29077 | 8788 | 121 |
636748 | 636748 | 2020-10-16 | Greene | New York | 36039 | 464 | 15 |
636827 | 636827 | 2020-10-16 | Greene | North Carolina | 37079 | 820 | 15 |
636972 | 636972 | 2020-10-16 | Greene | Ohio | 39057 | 2037 | 40 |
637175 | 637175 | 2020-10-16 | Greene | Pennsylvania | 42059 | 209 | 1 |
637439 | 637439 | 2020-10-16 | Greene | Tennessee | 47059 | 1444 | 48 |
637858 | 637858 | 2020-10-16 | Greene | Virginia | 51079 | 261 | 3 |
631671 | 631671 | 2020-10-15 | Greene | Alabama | 1063 | 328 | 15 |
631776 | 631776 | 2020-10-15 | Greene | Arkansas | 5055 | 1195 | 15 |
632094 | 632094 | 2020-10-15 | Greene | Georgia | 13133 | 595 | 24 |
632268 | 632268 | 2020-10-15 | Greene | Illinois | 17061 | 253 | 15 |
632368 | 632368 | 2020-10-15 | Greene | Indiana | 18055 | 487 | 39 |
632469 | 632469 | 2020-10-15 | Greene | Iowa | 19073 | 158 | 0 |
633073 | 633073 | 2020-10-15 | Greene | Mississippi | 28041 | 443 | 17 |
633173 | 633173 | 2020-10-15 | Greene | Missouri | 29077 | 8657 | 121 |
633502 | 633502 | 2020-10-15 | Greene | New York | 36039 | 454 | 15 |
633581 | 633581 | 2020-10-15 | Greene | North Carolina | 37079 | 801 | 7 |
633726 | 633726 | 2020-10-15 | Greene | Ohio | 39057 | 1976 | 39 |
633929 | 633929 | 2020-10-15 | Greene | Pennsylvania | 42059 | 208 | 1 |
634193 | 634193 | 2020-10-15 | Greene | Tennessee | 47059 | 1435 | 48 |
634613 | 634613 | 2020-10-15 | Greene | Virginia | 51079 | 258 | 3 |
628427 | 628427 | 2020-10-14 | Greene | Alabama | 1063 | 329 | 15 |
628532 | 628532 | 2020-10-14 | Greene | Arkansas | 5055 | 1149 | 15 |
628850 | 628850 | 2020-10-14 | Greene | Georgia | 13133 | 595 | 24 |
629024 | 629024 | 2020-10-14 | Greene | Illinois | 17061 | 250 | 15 |
629124 | 629124 | 2020-10-14 | Greene | Indiana | 18055 | 479 | 39 |
629225 | 629225 | 2020-10-14 | Greene | Iowa | 19073 | 157 | 0 |
629828 | 629828 | 2020-10-14 | Greene | Mississippi | 28041 | 439 | 17 |
629928 | 629928 | 2020-10-14 | Greene | Missouri | 29077 | 8551 | 116 |
630257 | 630257 | 2020-10-14 | Greene | New York | 36039 | 446 | 15 |
630336 | 630336 | 2020-10-14 | Greene | North Carolina | 37079 | 782 | 7 |
630481 | 630481 | 2020-10-14 | Greene | Ohio | 39057 | 1951 | 39 |
630684 | 630684 | 2020-10-14 | Greene | Pennsylvania | 42059 | 205 | 1 |
630948 | 630948 | 2020-10-14 | Greene | Tennessee | 47059 | 1383 | 48 |
631368 | 631368 | 2020-10-14 | Greene | Virginia | 51079 | 255 | 3 |
625184 | 625184 | 2020-10-13 | Greene | Alabama | 1063 | 326 | 15 |
625289 | 625289 | 2020-10-13 | Greene | Arkansas | 5055 | 1122 | 15 |
625607 | 625607 | 2020-10-13 | Greene | Georgia | 13133 | 593 | 24 |
625781 | 625781 | 2020-10-13 | Greene | Illinois | 17061 | 248 | 15 |
625881 | 625881 | 2020-10-13 | Greene | Indiana | 18055 | 477 | 39 |
625982 | 625982 | 2020-10-13 | Greene | Iowa | 19073 | 155 | 0 |
626584 | 626584 | 2020-10-13 | Greene | Mississippi | 28041 | 428 | 17 |
626684 | 626684 | 2020-10-13 | Greene | Missouri | 29077 | 8460 | 115 |
627013 | 627013 | 2020-10-13 | Greene | New York | 36039 | 429 | 15 |
627092 | 627092 | 2020-10-13 | Greene | North Carolina | 37079 | 777 | 7 |
627237 | 627237 | 2020-10-13 | Greene | Ohio | 39057 | 1914 | 38 |
627440 | 627440 | 2020-10-13 | Greene | Pennsylvania | 42059 | 204 | 1 |
627704 | 627704 | 2020-10-13 | Greene | Tennessee | 47059 | 1374 | 48 |
628124 | 628124 | 2020-10-13 | Greene | Virginia | 51079 | 255 | 3 |
621941 | 621941 | 2020-10-12 | Greene | Alabama | 1063 | 326 | 15 |
622046 | 622046 | 2020-10-12 | Greene | Arkansas | 5055 | 1100 | 15 |
622364 | 622364 | 2020-10-12 | Greene | Georgia | 13133 | 591 | 24 |
622539 | 622539 | 2020-10-12 | Greene | Illinois | 17061 | 248 | 15 |
622639 | 622639 | 2020-10-12 | Greene | Indiana | 18055 | 472 | 39 |
622740 | 622740 | 2020-10-12 | Greene | Iowa | 19073 | 152 | 0 |
623342 | 623342 | 2020-10-12 | Greene | Mississippi | 28041 | 426 | 17 |
623442 | 623442 | 2020-10-12 | Greene | Missouri | 29077 | 8380 | 113 |
623771 | 623771 | 2020-10-12 | Greene | New York | 36039 | 388 | 15 |
623850 | 623850 | 2020-10-12 | Greene | North Carolina | 37079 | 768 | 7 |
623995 | 623995 | 2020-10-12 | Greene | Ohio | 39057 | 1890 | 38 |
624198 | 624198 | 2020-10-12 | Greene | Pennsylvania | 42059 | 203 | 1 |
624462 | 624462 | 2020-10-12 | Greene | Tennessee | 47059 | 1365 | 48 |
624881 | 624881 | 2020-10-12 | Greene | Virginia | 51079 | 252 | 3 |
618698 | 618698 | 2020-10-11 | Greene | Alabama | 1063 | 326 | 15 |
618803 | 618803 | 2020-10-11 | Greene | Arkansas | 5055 | 1095 | 15 |
619121 | 619121 | 2020-10-11 | Greene | Georgia | 13133 | 586 | 24 |
619295 | 619295 | 2020-10-11 | Greene | Illinois | 17061 | 247 | 15 |
619395 | 619395 | 2020-10-11 | Greene | Indiana | 18055 | 471 | 39 |
619496 | 619496 | 2020-10-11 | Greene | Iowa | 19073 | 151 | 0 |
620099 | 620099 | 2020-10-11 | Greene | Mississippi | 28041 | 426 | 17 |
620199 | 620199 | 2020-10-11 | Greene | Missouri | 29077 | 8129 | 112 |
620528 | 620528 | 2020-10-11 | Greene | New York | 36039 | 383 | 15 |
620607 | 620607 | 2020-10-11 | Greene | North Carolina | 37079 | 758 | 7 |
620752 | 620752 | 2020-10-11 | Greene | Ohio | 39057 | 1870 | 38 |
620955 | 620955 | 2020-10-11 | Greene | Pennsylvania | 42059 | 201 | 1 |
621219 | 621219 | 2020-10-11 | Greene | Tennessee | 47059 | 1336 | 48 |
621638 | 621638 | 2020-10-11 | Greene | Virginia | 51079 | 251 | 3 |
615456 | 615456 | 2020-10-10 | Greene | Alabama | 1063 | 326 | 15 |
615561 | 615561 | 2020-10-10 | Greene | Arkansas | 5055 | 1077 | 15 |
615879 | 615879 | 2020-10-10 | Greene | Georgia | 13133 | 584 | 24 |
616053 | 616053 | 2020-10-10 | Greene | Illinois | 17061 | 245 | 15 |
616153 | 616153 | 2020-10-10 | Greene | Indiana | 18055 | 469 | 39 |
616254 | 616254 | 2020-10-10 | Greene | Iowa | 19073 | 151 | 0 |
616857 | 616857 | 2020-10-10 | Greene | Mississippi | 28041 | 426 | 17 |
616957 | 616957 | 2020-10-10 | Greene | Missouri | 29077 | 8129 | 112 |
617286 | 617286 | 2020-10-10 | Greene | New York | 36039 | 379 | 15 |
617365 | 617365 | 2020-10-10 | Greene | North Carolina | 37079 | 748 | 7 |
617510 | 617510 | 2020-10-10 | Greene | Ohio | 39057 | 1839 | 38 |
617712 | 617712 | 2020-10-10 | Greene | Pennsylvania | 42059 | 200 | 1 |
617976 | 617976 | 2020-10-10 | Greene | Tennessee | 47059 | 1308 | 48 |
618395 | 618395 | 2020-10-10 | Greene | Virginia | 51079 | 250 | 3 |
612215 | 612215 | 2020-10-09 | Greene | Alabama | 1063 | 325 | 15 |
612320 | 612320 | 2020-10-09 | Greene | Arkansas | 5055 | 1053 | 15 |
612638 | 612638 | 2020-10-09 | Greene | Georgia | 13133 | 581 | 25 |
612812 | 612812 | 2020-10-09 | Greene | Illinois | 17061 | 242 | 15 |
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);