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 188
- New York 185
- Arkansas 180
- Tennessee 180
- Ohio 178
- Georgia 176
- Pennsylvania 175
- Virginia 174
- North Carolina 173
- Alabama 172
- Indiana 171
- Mississippi 163
- Iowa 162
- Illinois 159
fips 14
county 1
- Greene · 2,436 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534877 | 534877 | 2020-09-15 | Greene | Georgia | 13133 | 484 | 21 |
535051 | 535051 | 2020-09-15 | Greene | Illinois | 17061 | 187 | 2 |
535151 | 535151 | 2020-09-15 | Greene | Indiana | 18055 | 407 | 38 |
535252 | 535252 | 2020-09-15 | Greene | Iowa | 19073 | 72 | 0 |
535854 | 535854 | 2020-09-15 | Greene | Mississippi | 28041 | 328 | 16 |
535954 | 535954 | 2020-09-15 | Greene | Missouri | 29077 | 5034 | 46 |
536279 | 536279 | 2020-09-15 | Greene | New York | 36039 | 318 | 14 |
536358 | 536358 | 2020-09-15 | Greene | North Carolina | 37079 | 485 | 5 |
536504 | 536504 | 2020-09-15 | Greene | Ohio | 39057 | 1244 | 26 |
536706 | 536706 | 2020-09-15 | Greene | Pennsylvania | 42059 | 160 | 1 |
536970 | 536970 | 2020-09-15 | Greene | Tennessee | 47059 | 1018 | 32 |
537388 | 537388 | 2020-09-15 | Greene | Virginia | 51079 | 207 | 3 |
531220 | 531220 | 2020-09-14 | Greene | Alabama | 1063 | 295 | 15 |
531325 | 531325 | 2020-09-14 | Greene | Arkansas | 5055 | 718 | 7 |
531642 | 531642 | 2020-09-14 | Greene | Georgia | 13133 | 483 | 21 |
531816 | 531816 | 2020-09-14 | Greene | Illinois | 17061 | 183 | 2 |
531916 | 531916 | 2020-09-14 | Greene | Indiana | 18055 | 405 | 38 |
532017 | 532017 | 2020-09-14 | Greene | Iowa | 19073 | 72 | 0 |
532619 | 532619 | 2020-09-14 | Greene | Mississippi | 28041 | 326 | 16 |
532719 | 532719 | 2020-09-14 | Greene | Missouri | 29077 | 4904 | 44 |
533043 | 533043 | 2020-09-14 | Greene | New York | 36039 | 318 | 14 |
533122 | 533122 | 2020-09-14 | Greene | North Carolina | 37079 | 486 | 5 |
533268 | 533268 | 2020-09-14 | Greene | Ohio | 39057 | 1224 | 25 |
533470 | 533470 | 2020-09-14 | Greene | Pennsylvania | 42059 | 159 | 1 |
533734 | 533734 | 2020-09-14 | Greene | Tennessee | 47059 | 1010 | 30 |
534152 | 534152 | 2020-09-14 | Greene | Virginia | 51079 | 207 | 3 |
527983 | 527983 | 2020-09-13 | Greene | Alabama | 1063 | 293 | 15 |
528088 | 528088 | 2020-09-13 | Greene | Arkansas | 5055 | 715 | 7 |
528405 | 528405 | 2020-09-13 | Greene | Georgia | 13133 | 482 | 21 |
528579 | 528579 | 2020-09-13 | Greene | Illinois | 17061 | 183 | 2 |
528679 | 528679 | 2020-09-13 | Greene | Indiana | 18055 | 398 | 38 |
528780 | 528780 | 2020-09-13 | Greene | Iowa | 19073 | 71 | 0 |
529383 | 529383 | 2020-09-13 | Greene | Mississippi | 28041 | 326 | 16 |
529483 | 529483 | 2020-09-13 | Greene | Missouri | 29077 | 4833 | 44 |
529808 | 529808 | 2020-09-13 | Greene | New York | 36039 | 318 | 14 |
529887 | 529887 | 2020-09-13 | Greene | North Carolina | 37079 | 478 | 5 |
530033 | 530033 | 2020-09-13 | Greene | Ohio | 39057 | 1218 | 25 |
530235 | 530235 | 2020-09-13 | Greene | Pennsylvania | 42059 | 159 | 1 |
530499 | 530499 | 2020-09-13 | Greene | Tennessee | 47059 | 979 | 28 |
530917 | 530917 | 2020-09-13 | Greene | Virginia | 51079 | 206 | 3 |
524747 | 524747 | 2020-09-12 | Greene | Alabama | 1063 | 293 | 15 |
524852 | 524852 | 2020-09-12 | Greene | Arkansas | 5055 | 713 | 7 |
525169 | 525169 | 2020-09-12 | Greene | Georgia | 13133 | 482 | 21 |
525343 | 525343 | 2020-09-12 | Greene | Illinois | 17061 | 182 | 2 |
525443 | 525443 | 2020-09-12 | Greene | Indiana | 18055 | 392 | 38 |
525544 | 525544 | 2020-09-12 | Greene | Iowa | 19073 | 70 | 0 |
526147 | 526147 | 2020-09-12 | Greene | Mississippi | 28041 | 325 | 16 |
526247 | 526247 | 2020-09-12 | Greene | Missouri | 29077 | 4748 | 44 |
526571 | 526571 | 2020-09-12 | Greene | New York | 36039 | 317 | 14 |
526650 | 526650 | 2020-09-12 | Greene | North Carolina | 37079 | 471 | 5 |
526796 | 526796 | 2020-09-12 | Greene | Ohio | 39057 | 1201 | 25 |
526998 | 526998 | 2020-09-12 | Greene | Pennsylvania | 42059 | 159 | 1 |
527262 | 527262 | 2020-09-12 | Greene | Tennessee | 47059 | 976 | 28 |
527680 | 527680 | 2020-09-12 | Greene | Virginia | 51079 | 207 | 3 |
521511 | 521511 | 2020-09-11 | Greene | Alabama | 1063 | 292 | 15 |
521616 | 521616 | 2020-09-11 | Greene | Arkansas | 5055 | 700 | 7 |
521933 | 521933 | 2020-09-11 | Greene | Georgia | 13133 | 480 | 21 |
522107 | 522107 | 2020-09-11 | Greene | Illinois | 17061 | 182 | 2 |
522207 | 522207 | 2020-09-11 | Greene | Indiana | 18055 | 392 | 38 |
522308 | 522308 | 2020-09-11 | Greene | Iowa | 19073 | 69 | 0 |
522911 | 522911 | 2020-09-11 | Greene | Mississippi | 28041 | 322 | 16 |
523011 | 523011 | 2020-09-11 | Greene | Missouri | 29077 | 4575 | 43 |
523335 | 523335 | 2020-09-11 | Greene | New York | 36039 | 317 | 14 |
523414 | 523414 | 2020-09-11 | Greene | North Carolina | 37079 | 467 | 5 |
523560 | 523560 | 2020-09-11 | Greene | Ohio | 39057 | 1182 | 25 |
523762 | 523762 | 2020-09-11 | Greene | Pennsylvania | 42059 | 156 | 1 |
524026 | 524026 | 2020-09-11 | Greene | Tennessee | 47059 | 974 | 28 |
524444 | 524444 | 2020-09-11 | Greene | Virginia | 51079 | 207 | 3 |
518274 | 518274 | 2020-09-10 | Greene | Alabama | 1063 | 292 | 15 |
518379 | 518379 | 2020-09-10 | Greene | Arkansas | 5055 | 682 | 7 |
518696 | 518696 | 2020-09-10 | Greene | Georgia | 13133 | 479 | 21 |
518870 | 518870 | 2020-09-10 | Greene | Illinois | 17061 | 172 | 1 |
518970 | 518970 | 2020-09-10 | Greene | Indiana | 18055 | 388 | 38 |
519071 | 519071 | 2020-09-10 | Greene | Iowa | 19073 | 69 | 0 |
519674 | 519674 | 2020-09-10 | Greene | Mississippi | 28041 | 318 | 16 |
519774 | 519774 | 2020-09-10 | Greene | Missouri | 29077 | 4466 | 43 |
520099 | 520099 | 2020-09-10 | Greene | New York | 36039 | 317 | 14 |
520178 | 520178 | 2020-09-10 | Greene | North Carolina | 37079 | 464 | 5 |
520324 | 520324 | 2020-09-10 | Greene | Ohio | 39057 | 1149 | 25 |
520526 | 520526 | 2020-09-10 | Greene | Pennsylvania | 42059 | 153 | 1 |
520790 | 520790 | 2020-09-10 | Greene | Tennessee | 47059 | 962 | 23 |
521208 | 521208 | 2020-09-10 | Greene | Virginia | 51079 | 204 | 3 |
515039 | 515039 | 2020-09-09 | Greene | Alabama | 1063 | 292 | 15 |
515144 | 515144 | 2020-09-09 | Greene | Arkansas | 5055 | 677 | 7 |
515461 | 515461 | 2020-09-09 | Greene | Georgia | 13133 | 476 | 21 |
515635 | 515635 | 2020-09-09 | Greene | Illinois | 17061 | 161 | 1 |
515735 | 515735 | 2020-09-09 | Greene | Indiana | 18055 | 388 | 38 |
515836 | 515836 | 2020-09-09 | Greene | Iowa | 19073 | 67 | 0 |
516439 | 516439 | 2020-09-09 | Greene | Mississippi | 28041 | 316 | 14 |
516539 | 516539 | 2020-09-09 | Greene | Missouri | 29077 | 4369 | 39 |
516863 | 516863 | 2020-09-09 | Greene | New York | 36039 | 316 | 14 |
516942 | 516942 | 2020-09-09 | Greene | North Carolina | 37079 | 458 | 5 |
517088 | 517088 | 2020-09-09 | Greene | Ohio | 39057 | 1136 | 21 |
517290 | 517290 | 2020-09-09 | Greene | Pennsylvania | 42059 | 152 | 1 |
517554 | 517554 | 2020-09-09 | Greene | Tennessee | 47059 | 948 | 22 |
517971 | 517971 | 2020-09-09 | Greene | Virginia | 51079 | 203 | 3 |
511806 | 511806 | 2020-09-08 | Greene | Alabama | 1063 | 292 | 15 |
511911 | 511911 | 2020-09-08 | Greene | Arkansas | 5055 | 674 | 6 |
512228 | 512228 | 2020-09-08 | Greene | Georgia | 13133 | 476 | 21 |
512402 | 512402 | 2020-09-08 | Greene | Illinois | 17061 | 160 | 1 |
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);