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 142
- New York 139
- Arkansas 134
- Tennessee 134
- Ohio 132
- Georgia 130
- Pennsylvania 129
- Virginia 128
- North Carolina 127
- Alabama 126
- Indiana 125
- Mississippi 117
- Iowa 116
- Illinois 113
fips 14
county 1
- Greene · 1,792 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386393 | 386393 | 2020-07-31 | Greene | Georgia | 13133 | 236 | 11 |
386565 | 386565 | 2020-07-31 | Greene | Illinois | 17061 | 17 | 0 |
386665 | 386665 | 2020-07-31 | Greene | Indiana | 18055 | 238 | 37 |
386766 | 386766 | 2020-07-31 | Greene | Iowa | 19073 | 38 | 0 |
387367 | 387367 | 2020-07-31 | Greene | Mississippi | 28041 | 223 | 11 |
387467 | 387467 | 2020-07-31 | Greene | Missouri | 29077 | 1229 | 11 |
387781 | 387781 | 2020-07-31 | Greene | New York | 36039 | 289 | 5 |
387860 | 387860 | 2020-07-31 | Greene | North Carolina | 37079 | 297 | 3 |
388005 | 388005 | 2020-07-31 | Greene | Ohio | 39057 | 610 | 11 |
388206 | 388206 | 2020-07-31 | Greene | Pennsylvania | 42059 | 107 | 0 |
388469 | 388469 | 2020-07-31 | Greene | Tennessee | 47059 | 344 | 5 |
388885 | 388885 | 2020-07-31 | Greene | Virginia | 51079 | 134 | 2 |
382753 | 382753 | 2020-07-30 | Greene | Alabama | 1063 | 241 | 11 |
382858 | 382858 | 2020-07-30 | Greene | Arkansas | 5055 | 280 | 1 |
383175 | 383175 | 2020-07-30 | Greene | Georgia | 13133 | 225 | 11 |
383347 | 383347 | 2020-07-30 | Greene | Illinois | 17061 | 17 | 0 |
383447 | 383447 | 2020-07-30 | Greene | Indiana | 18055 | 236 | 37 |
383548 | 383548 | 2020-07-30 | Greene | Iowa | 19073 | 37 | 0 |
384149 | 384149 | 2020-07-30 | Greene | Mississippi | 28041 | 219 | 10 |
384249 | 384249 | 2020-07-30 | Greene | Missouri | 29077 | 1192 | 11 |
384564 | 384564 | 2020-07-30 | Greene | New York | 36039 | 287 | 5 |
384643 | 384643 | 2020-07-30 | Greene | North Carolina | 37079 | 287 | 3 |
384788 | 384788 | 2020-07-30 | Greene | Ohio | 39057 | 599 | 11 |
384989 | 384989 | 2020-07-30 | Greene | Pennsylvania | 42059 | 105 | 0 |
385252 | 385252 | 2020-07-30 | Greene | Tennessee | 47059 | 324 | 5 |
385668 | 385668 | 2020-07-30 | Greene | Virginia | 51079 | 134 | 2 |
379536 | 379536 | 2020-07-29 | Greene | Alabama | 1063 | 239 | 11 |
379641 | 379641 | 2020-07-29 | Greene | Arkansas | 5055 | 269 | 1 |
379958 | 379958 | 2020-07-29 | Greene | Georgia | 13133 | 222 | 11 |
380130 | 380130 | 2020-07-29 | Greene | Illinois | 17061 | 17 | 0 |
380230 | 380230 | 2020-07-29 | Greene | Indiana | 18055 | 234 | 37 |
380331 | 380331 | 2020-07-29 | Greene | Iowa | 19073 | 37 | 0 |
380932 | 380932 | 2020-07-29 | Greene | Mississippi | 28041 | 211 | 10 |
381033 | 381033 | 2020-07-29 | Greene | Missouri | 29077 | 1159 | 10 |
381346 | 381346 | 2020-07-29 | Greene | New York | 36039 | 285 | 5 |
381425 | 381425 | 2020-07-29 | Greene | North Carolina | 37079 | 284 | 3 |
381570 | 381570 | 2020-07-29 | Greene | Ohio | 39057 | 587 | 11 |
381771 | 381771 | 2020-07-29 | Greene | Pennsylvania | 42059 | 103 | 0 |
382034 | 382034 | 2020-07-29 | Greene | Tennessee | 47059 | 316 | 5 |
382450 | 382450 | 2020-07-29 | Greene | Virginia | 51079 | 134 | 2 |
376320 | 376320 | 2020-07-28 | Greene | Alabama | 1063 | 239 | 11 |
376425 | 376425 | 2020-07-28 | Greene | Arkansas | 5055 | 247 | 1 |
376741 | 376741 | 2020-07-28 | Greene | Georgia | 13133 | 217 | 11 |
376913 | 376913 | 2020-07-28 | Greene | Illinois | 17061 | 17 | 0 |
377013 | 377013 | 2020-07-28 | Greene | Indiana | 18055 | 230 | 37 |
377114 | 377114 | 2020-07-28 | Greene | Iowa | 19073 | 37 | 0 |
377715 | 377715 | 2020-07-28 | Greene | Mississippi | 28041 | 205 | 10 |
377816 | 377816 | 2020-07-28 | Greene | Missouri | 29077 | 1118 | 10 |
378129 | 378129 | 2020-07-28 | Greene | New York | 36039 | 283 | 5 |
378208 | 378208 | 2020-07-28 | Greene | North Carolina | 37079 | 283 | 3 |
378353 | 378353 | 2020-07-28 | Greene | Ohio | 39057 | 568 | 11 |
378554 | 378554 | 2020-07-28 | Greene | Pennsylvania | 42059 | 100 | 0 |
378817 | 378817 | 2020-07-28 | Greene | Tennessee | 47059 | 300 | 5 |
379233 | 379233 | 2020-07-28 | Greene | Virginia | 51079 | 134 | 2 |
373106 | 373106 | 2020-07-27 | Greene | Alabama | 1063 | 237 | 11 |
373211 | 373211 | 2020-07-27 | Greene | Arkansas | 5055 | 230 | 1 |
373527 | 373527 | 2020-07-27 | Greene | Georgia | 13133 | 215 | 11 |
373698 | 373698 | 2020-07-27 | Greene | Illinois | 17061 | 17 | 0 |
373798 | 373798 | 2020-07-27 | Greene | Indiana | 18055 | 227 | 37 |
373899 | 373899 | 2020-07-27 | Greene | Iowa | 19073 | 37 | 0 |
374500 | 374500 | 2020-07-27 | Greene | Mississippi | 28041 | 200 | 10 |
374601 | 374601 | 2020-07-27 | Greene | Missouri | 29077 | 1076 | 10 |
374913 | 374913 | 2020-07-27 | Greene | New York | 36039 | 282 | 5 |
374992 | 374992 | 2020-07-27 | Greene | North Carolina | 37079 | 277 | 3 |
375136 | 375136 | 2020-07-27 | Greene | Ohio | 39057 | 554 | 11 |
375338 | 375338 | 2020-07-27 | Greene | Pennsylvania | 42059 | 99 | 0 |
375601 | 375601 | 2020-07-27 | Greene | Tennessee | 47059 | 295 | 5 |
376017 | 376017 | 2020-07-27 | Greene | Virginia | 51079 | 134 | 2 |
369894 | 369894 | 2020-07-26 | Greene | Alabama | 1063 | 233 | 10 |
369999 | 369999 | 2020-07-26 | Greene | Arkansas | 5055 | 228 | 1 |
370315 | 370315 | 2020-07-26 | Greene | Georgia | 13133 | 203 | 11 |
370486 | 370486 | 2020-07-26 | Greene | Illinois | 17061 | 16 | 0 |
370586 | 370586 | 2020-07-26 | Greene | Indiana | 18055 | 227 | 37 |
370687 | 370687 | 2020-07-26 | Greene | Iowa | 19073 | 37 | 0 |
371288 | 371288 | 2020-07-26 | Greene | Mississippi | 28041 | 192 | 10 |
371389 | 371389 | 2020-07-26 | Greene | Missouri | 29077 | 1019 | 10 |
371701 | 371701 | 2020-07-26 | Greene | New York | 36039 | 281 | 5 |
371780 | 371780 | 2020-07-26 | Greene | North Carolina | 37079 | 274 | 3 |
371924 | 371924 | 2020-07-26 | Greene | Ohio | 39057 | 545 | 11 |
372125 | 372125 | 2020-07-26 | Greene | Pennsylvania | 42059 | 98 | 0 |
372388 | 372388 | 2020-07-26 | Greene | Tennessee | 47059 | 284 | 5 |
372803 | 372803 | 2020-07-26 | Greene | Virginia | 51079 | 123 | 2 |
366684 | 366684 | 2020-07-25 | Greene | Alabama | 1063 | 232 | 10 |
366789 | 366789 | 2020-07-25 | Greene | Arkansas | 5055 | 216 | 1 |
367105 | 367105 | 2020-07-25 | Greene | Georgia | 13133 | 203 | 11 |
367276 | 367276 | 2020-07-25 | Greene | Illinois | 17061 | 14 | 0 |
367376 | 367376 | 2020-07-25 | Greene | Indiana | 18055 | 226 | 37 |
367477 | 367477 | 2020-07-25 | Greene | Iowa | 19073 | 37 | 0 |
368078 | 368078 | 2020-07-25 | Greene | Mississippi | 28041 | 187 | 10 |
368178 | 368178 | 2020-07-25 | Greene | Missouri | 29077 | 1016 | 10 |
368489 | 368489 | 2020-07-25 | Greene | New York | 36039 | 279 | 5 |
368568 | 368568 | 2020-07-25 | Greene | North Carolina | 37079 | 270 | 3 |
368712 | 368712 | 2020-07-25 | Greene | Ohio | 39057 | 538 | 11 |
368913 | 368913 | 2020-07-25 | Greene | Pennsylvania | 42059 | 97 | 0 |
369176 | 369176 | 2020-07-25 | Greene | Tennessee | 47059 | 261 | 5 |
369591 | 369591 | 2020-07-25 | Greene | Virginia | 51079 | 119 | 2 |
363477 | 363477 | 2020-07-24 | Greene | Alabama | 1063 | 231 | 10 |
363582 | 363582 | 2020-07-24 | Greene | Arkansas | 5055 | 211 | 1 |
363898 | 363898 | 2020-07-24 | Greene | Georgia | 13133 | 200 | 11 |
364069 | 364069 | 2020-07-24 | Greene | Illinois | 17061 | 14 | 0 |
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);