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 307
- New York 304
- Arkansas 299
- Tennessee 299
- Ohio 297
- Georgia 295
- Pennsylvania 294
- Virginia 293
- North Carolina 292
- Alabama 291
- Indiana 290
- Mississippi 282
- Iowa 281
- Illinois 278
fips 14
county 1
- Greene · 4,102 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920893 | 920893 | 2021-01-12 | Greene | Georgia | 13133 | 1340 | 29 |
921068 | 921068 | 2021-01-12 | Greene | Illinois | 17061 | 1221 | 42 |
921167 | 921167 | 2021-01-12 | Greene | Indiana | 18055 | 2263 | 61 |
921268 | 921268 | 2021-01-12 | Greene | Iowa | 19073 | 674 | 7 |
921872 | 921872 | 2021-01-12 | Greene | Mississippi | 28041 | 1071 | 29 |
921972 | 921972 | 2021-01-12 | Greene | Missouri | 29077 | 23960 | 313 |
922301 | 922301 | 2021-01-12 | Greene | New York | 36039 | 1835 | 44 |
922380 | 922380 | 2021-01-12 | Greene | North Carolina | 37079 | 1692 | 34 |
922525 | 922525 | 2021-01-12 | Greene | Ohio | 39057 | 11118 | 130 |
922728 | 922728 | 2021-01-12 | Greene | Pennsylvania | 42059 | 2050 | 23 |
922992 | 922992 | 2021-01-12 | Greene | Tennessee | 47059 | 6391 | 105 |
923413 | 923413 | 2021-01-12 | Greene | Virginia | 51079 | 682 | 4 |
917224 | 917224 | 2021-01-11 | Greene | Alabama | 1063 | 734 | 20 |
917330 | 917330 | 2021-01-11 | Greene | Arkansas | 5055 | 4883 | 59 |
917648 | 917648 | 2021-01-11 | Greene | Georgia | 13133 | 1322 | 29 |
917823 | 917823 | 2021-01-11 | Greene | Illinois | 17061 | 1218 | 41 |
917922 | 917922 | 2021-01-11 | Greene | Indiana | 18055 | 2252 | 61 |
918023 | 918023 | 2021-01-11 | Greene | Iowa | 19073 | 669 | 7 |
918627 | 918627 | 2021-01-11 | Greene | Mississippi | 28041 | 1059 | 28 |
918727 | 918727 | 2021-01-11 | Greene | Missouri | 29077 | 23734 | 309 |
919056 | 919056 | 2021-01-11 | Greene | New York | 36039 | 1782 | 38 |
919135 | 919135 | 2021-01-11 | Greene | North Carolina | 37079 | 1683 | 34 |
919280 | 919280 | 2021-01-11 | Greene | Ohio | 39057 | 10930 | 127 |
919483 | 919483 | 2021-01-11 | Greene | Pennsylvania | 42059 | 2022 | 22 |
919747 | 919747 | 2021-01-11 | Greene | Tennessee | 47059 | 6322 | 103 |
920168 | 920168 | 2021-01-11 | Greene | Virginia | 51079 | 676 | 4 |
913979 | 913979 | 2021-01-10 | Greene | Alabama | 1063 | 731 | 20 |
914085 | 914085 | 2021-01-10 | Greene | Arkansas | 5055 | 4870 | 59 |
914403 | 914403 | 2021-01-10 | Greene | Georgia | 13133 | 1309 | 29 |
914578 | 914578 | 2021-01-10 | Greene | Illinois | 17061 | 1205 | 41 |
914677 | 914677 | 2021-01-10 | Greene | Indiana | 18055 | 2239 | 61 |
914778 | 914778 | 2021-01-10 | Greene | Iowa | 19073 | 668 | 7 |
915382 | 915382 | 2021-01-10 | Greene | Mississippi | 28041 | 1051 | 27 |
915482 | 915482 | 2021-01-10 | Greene | Missouri | 29077 | 23285 | 309 |
915811 | 915811 | 2021-01-10 | Greene | New York | 36039 | 1741 | 37 |
915890 | 915890 | 2021-01-10 | Greene | North Carolina | 37079 | 1676 | 34 |
916035 | 916035 | 2021-01-10 | Greene | Ohio | 39057 | 10822 | 127 |
916238 | 916238 | 2021-01-10 | Greene | Pennsylvania | 42059 | 2004 | 22 |
916502 | 916502 | 2021-01-10 | Greene | Tennessee | 47059 | 6294 | 103 |
916923 | 916923 | 2021-01-10 | Greene | Virginia | 51079 | 661 | 4 |
910734 | 910734 | 2021-01-09 | Greene | Alabama | 1063 | 726 | 20 |
910840 | 910840 | 2021-01-09 | Greene | Arkansas | 5055 | 4836 | 58 |
911158 | 911158 | 2021-01-09 | Greene | Georgia | 13133 | 1293 | 29 |
911333 | 911333 | 2021-01-09 | Greene | Illinois | 17061 | 1201 | 41 |
911432 | 911432 | 2021-01-09 | Greene | Indiana | 18055 | 2206 | 61 |
911533 | 911533 | 2021-01-09 | Greene | Iowa | 19073 | 668 | 7 |
912137 | 912137 | 2021-01-09 | Greene | Mississippi | 28041 | 1045 | 27 |
912237 | 912237 | 2021-01-09 | Greene | Missouri | 29077 | 23285 | 309 |
912566 | 912566 | 2021-01-09 | Greene | New York | 36039 | 1719 | 36 |
912645 | 912645 | 2021-01-09 | Greene | North Carolina | 37079 | 1659 | 34 |
912790 | 912790 | 2021-01-09 | Greene | Ohio | 39057 | 10718 | 127 |
912993 | 912993 | 2021-01-09 | Greene | Pennsylvania | 42059 | 1965 | 21 |
913257 | 913257 | 2021-01-09 | Greene | Tennessee | 47059 | 6222 | 103 |
913678 | 913678 | 2021-01-09 | Greene | Virginia | 51079 | 648 | 4 |
907489 | 907489 | 2021-01-08 | Greene | Alabama | 1063 | 723 | 20 |
907595 | 907595 | 2021-01-08 | Greene | Arkansas | 5055 | 4766 | 55 |
907913 | 907913 | 2021-01-08 | Greene | Georgia | 13133 | 1274 | 29 |
908088 | 908088 | 2021-01-08 | Greene | Illinois | 17061 | 1195 | 41 |
908187 | 908187 | 2021-01-08 | Greene | Indiana | 18055 | 2152 | 61 |
908288 | 908288 | 2021-01-08 | Greene | Iowa | 19073 | 666 | 7 |
908892 | 908892 | 2021-01-08 | Greene | Mississippi | 28041 | 1031 | 27 |
908992 | 908992 | 2021-01-08 | Greene | Missouri | 29077 | 23285 | 309 |
909321 | 909321 | 2021-01-08 | Greene | New York | 36039 | 1674 | 35 |
909400 | 909400 | 2021-01-08 | Greene | North Carolina | 37079 | 1640 | 34 |
909545 | 909545 | 2021-01-08 | Greene | Ohio | 39057 | 10629 | 126 |
909748 | 909748 | 2021-01-08 | Greene | Pennsylvania | 42059 | 1933 | 20 |
910012 | 910012 | 2021-01-08 | Greene | Tennessee | 47059 | 6161 | 102 |
910433 | 910433 | 2021-01-08 | Greene | Virginia | 51079 | 635 | 4 |
904243 | 904243 | 2021-01-07 | Greene | Alabama | 1063 | 716 | 20 |
904349 | 904349 | 2021-01-07 | Greene | Arkansas | 5055 | 4734 | 55 |
904667 | 904667 | 2021-01-07 | Greene | Georgia | 13133 | 1256 | 29 |
904842 | 904842 | 2021-01-07 | Greene | Illinois | 17061 | 1181 | 41 |
904941 | 904941 | 2021-01-07 | Greene | Indiana | 18055 | 2123 | 61 |
905042 | 905042 | 2021-01-07 | Greene | Iowa | 19073 | 665 | 7 |
905646 | 905646 | 2021-01-07 | Greene | Mississippi | 28041 | 1023 | 27 |
905746 | 905746 | 2021-01-07 | Greene | Missouri | 29077 | 22962 | 309 |
906076 | 906076 | 2021-01-07 | Greene | New York | 36039 | 1624 | 32 |
906155 | 906155 | 2021-01-07 | Greene | North Carolina | 37079 | 1612 | 34 |
906300 | 906300 | 2021-01-07 | Greene | Ohio | 39057 | 10475 | 126 |
906503 | 906503 | 2021-01-07 | Greene | Pennsylvania | 42059 | 1889 | 19 |
906767 | 906767 | 2021-01-07 | Greene | Tennessee | 47059 | 6086 | 102 |
907188 | 907188 | 2021-01-07 | Greene | Virginia | 51079 | 616 | 4 |
900998 | 900998 | 2021-01-06 | Greene | Alabama | 1063 | 709 | 20 |
901104 | 901104 | 2021-01-06 | Greene | Arkansas | 5055 | 4681 | 55 |
901422 | 901422 | 2021-01-06 | Greene | Georgia | 13133 | 1236 | 28 |
901597 | 901597 | 2021-01-06 | Greene | Illinois | 17061 | 1178 | 41 |
901696 | 901696 | 2021-01-06 | Greene | Indiana | 18055 | 2076 | 61 |
901797 | 901797 | 2021-01-06 | Greene | Iowa | 19073 | 662 | 7 |
902401 | 902401 | 2021-01-06 | Greene | Mississippi | 28041 | 1019 | 27 |
902501 | 902501 | 2021-01-06 | Greene | Missouri | 29077 | 22652 | 309 |
902830 | 902830 | 2021-01-06 | Greene | New York | 36039 | 1584 | 31 |
902909 | 902909 | 2021-01-06 | Greene | North Carolina | 37079 | 1597 | 33 |
903054 | 903054 | 2021-01-06 | Greene | Ohio | 39057 | 10336 | 126 |
903257 | 903257 | 2021-01-06 | Greene | Pennsylvania | 42059 | 1858 | 19 |
903521 | 903521 | 2021-01-06 | Greene | Tennessee | 47059 | 6013 | 102 |
903942 | 903942 | 2021-01-06 | Greene | Virginia | 51079 | 606 | 4 |
897753 | 897753 | 2021-01-05 | Greene | Alabama | 1063 | 700 | 20 |
897859 | 897859 | 2021-01-05 | Greene | Arkansas | 5055 | 4626 | 54 |
898177 | 898177 | 2021-01-05 | Greene | Georgia | 13133 | 1218 | 28 |
898352 | 898352 | 2021-01-05 | Greene | Illinois | 17061 | 1167 | 41 |
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);