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 300
- New York 297
- Arkansas 292
- Tennessee 292
- Ohio 290
- Georgia 287
- Pennsylvania 287
- Virginia 286
- North Carolina 285
- Alabama 284
- Indiana 283
- Mississippi 275
- Iowa 274
- Illinois 270
fips 14
county 1
- Greene · 4,002 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
898451 | 898451 | 2021-01-05 | Greene | Indiana | 18055 | 2031 | 61 |
898552 | 898552 | 2021-01-05 | Greene | Iowa | 19073 | 660 | 7 |
899156 | 899156 | 2021-01-05 | Greene | Mississippi | 28041 | 1009 | 27 |
899256 | 899256 | 2021-01-05 | Greene | Missouri | 29077 | 22404 | 297 |
899585 | 899585 | 2021-01-05 | Greene | New York | 36039 | 1535 | 30 |
899664 | 899664 | 2021-01-05 | Greene | North Carolina | 37079 | 1587 | 33 |
899809 | 899809 | 2021-01-05 | Greene | Ohio | 39057 | 10241 | 125 |
900012 | 900012 | 2021-01-05 | Greene | Pennsylvania | 42059 | 1820 | 17 |
900276 | 900276 | 2021-01-05 | Greene | Tennessee | 47059 | 5916 | 102 |
900697 | 900697 | 2021-01-05 | Greene | Virginia | 51079 | 590 | 4 |
894507 | 894507 | 2021-01-04 | Greene | Alabama | 1063 | 696 | 20 |
894614 | 894614 | 2021-01-04 | Greene | Arkansas | 5055 | 4543 | 53 |
894932 | 894932 | 2021-01-04 | Greene | Georgia | 13133 | 1178 | 28 |
895107 | 895107 | 2021-01-04 | Greene | Illinois | 17061 | 1151 | 41 |
895206 | 895206 | 2021-01-04 | Greene | Indiana | 18055 | 2013 | 60 |
895307 | 895307 | 2021-01-04 | Greene | Iowa | 19073 | 655 | 7 |
895911 | 895911 | 2021-01-04 | Greene | Mississippi | 28041 | 1005 | 26 |
896011 | 896011 | 2021-01-04 | Greene | Missouri | 29077 | 21959 | 297 |
896340 | 896340 | 2021-01-04 | Greene | New York | 36039 | 1491 | 29 |
896419 | 896419 | 2021-01-04 | Greene | North Carolina | 37079 | 1581 | 31 |
896564 | 896564 | 2021-01-04 | Greene | Ohio | 39057 | 10104 | 125 |
896767 | 896767 | 2021-01-04 | Greene | Pennsylvania | 42059 | 1800 | 16 |
897031 | 897031 | 2021-01-04 | Greene | Tennessee | 47059 | 5861 | 98 |
897452 | 897452 | 2021-01-04 | Greene | Virginia | 51079 | 582 | 4 |
891261 | 891261 | 2021-01-03 | Greene | Alabama | 1063 | 688 | 20 |
891367 | 891367 | 2021-01-03 | Greene | Arkansas | 5055 | 4523 | 52 |
891685 | 891685 | 2021-01-03 | Greene | Georgia | 13133 | 1167 | 28 |
891860 | 891860 | 2021-01-03 | Greene | Illinois | 17061 | 1138 | 41 |
891959 | 891959 | 2021-01-03 | Greene | Indiana | 18055 | 1999 | 60 |
892060 | 892060 | 2021-01-03 | Greene | Iowa | 19073 | 649 | 7 |
892664 | 892664 | 2021-01-03 | Greene | Mississippi | 28041 | 1001 | 25 |
892764 | 892764 | 2021-01-03 | Greene | Missouri | 29077 | 21496 | 297 |
893094 | 893094 | 2021-01-03 | Greene | New York | 36039 | 1462 | 27 |
893173 | 893173 | 2021-01-03 | Greene | North Carolina | 37079 | 1576 | 31 |
893318 | 893318 | 2021-01-03 | Greene | Ohio | 39057 | 10020 | 121 |
893521 | 893521 | 2021-01-03 | Greene | Pennsylvania | 42059 | 1774 | 15 |
893785 | 893785 | 2021-01-03 | Greene | Tennessee | 47059 | 5811 | 93 |
894206 | 894206 | 2021-01-03 | Greene | Virginia | 51079 | 576 | 4 |
888014 | 888014 | 2021-01-02 | Greene | Alabama | 1063 | 682 | 20 |
888120 | 888120 | 2021-01-02 | Greene | Arkansas | 5055 | 4479 | 52 |
888438 | 888438 | 2021-01-02 | Greene | Georgia | 13133 | 1158 | 28 |
888613 | 888613 | 2021-01-02 | Greene | Illinois | 17061 | 1130 | 41 |
888713 | 888713 | 2021-01-02 | Greene | Indiana | 18055 | 1982 | 59 |
888814 | 888814 | 2021-01-02 | Greene | Iowa | 19073 | 648 | 7 |
889418 | 889418 | 2021-01-02 | Greene | Mississippi | 28041 | 997 | 25 |
889518 | 889518 | 2021-01-02 | Greene | Missouri | 29077 | 21496 | 297 |
889848 | 889848 | 2021-01-02 | Greene | New York | 36039 | 1431 | 25 |
889927 | 889927 | 2021-01-02 | Greene | North Carolina | 37079 | 1561 | 31 |
890072 | 890072 | 2021-01-02 | Greene | Ohio | 39057 | 9916 | 121 |
890275 | 890275 | 2021-01-02 | Greene | Pennsylvania | 42059 | 1748 | 15 |
890539 | 890539 | 2021-01-02 | Greene | Tennessee | 47059 | 5713 | 93 |
890960 | 890960 | 2021-01-02 | Greene | Virginia | 51079 | 567 | 4 |
884769 | 884769 | 2021-01-01 | Greene | Alabama | 1063 | 679 | 20 |
884875 | 884875 | 2021-01-01 | Greene | Arkansas | 5055 | 4463 | 52 |
885193 | 885193 | 2021-01-01 | Greene | Georgia | 13133 | 1146 | 28 |
885368 | 885368 | 2021-01-01 | Greene | Illinois | 17061 | 1115 | 41 |
885467 | 885467 | 2021-01-01 | Greene | Indiana | 18055 | 1974 | 59 |
885568 | 885568 | 2021-01-01 | Greene | Iowa | 19073 | 648 | 7 |
886172 | 886172 | 2021-01-01 | Greene | Mississippi | 28041 | 996 | 25 |
886272 | 886272 | 2021-01-01 | Greene | Missouri | 29077 | 21496 | 297 |
886601 | 886601 | 2021-01-01 | Greene | New York | 36039 | 1383 | 23 |
886680 | 886680 | 2021-01-01 | Greene | North Carolina | 37079 | 1534 | 27 |
886825 | 886825 | 2021-01-01 | Greene | Ohio | 39057 | 9685 | 121 |
887028 | 887028 | 2021-01-01 | Greene | Pennsylvania | 42059 | 1717 | 15 |
887292 | 887292 | 2021-01-01 | Greene | Tennessee | 47059 | 5517 | 92 |
887713 | 887713 | 2021-01-01 | Greene | Virginia | 51079 | 552 | 4 |
881524 | 881524 | 2020-12-31 | Greene | Alabama | 1063 | 672 | 20 |
881630 | 881630 | 2020-12-31 | Greene | Arkansas | 5055 | 4431 | 51 |
881948 | 881948 | 2020-12-31 | Greene | Georgia | 13133 | 1128 | 28 |
882123 | 882123 | 2020-12-31 | Greene | Illinois | 17061 | 1115 | 41 |
882222 | 882222 | 2020-12-31 | Greene | Indiana | 18055 | 1937 | 59 |
882323 | 882323 | 2020-12-31 | Greene | Iowa | 19073 | 648 | 7 |
882927 | 882927 | 2020-12-31 | Greene | Mississippi | 28041 | 988 | 25 |
883027 | 883027 | 2020-12-31 | Greene | Missouri | 29077 | 21496 | 297 |
883356 | 883356 | 2020-12-31 | Greene | New York | 36039 | 1322 | 21 |
883435 | 883435 | 2020-12-31 | Greene | North Carolina | 37079 | 1534 | 27 |
883580 | 883580 | 2020-12-31 | Greene | Ohio | 39057 | 9685 | 121 |
883783 | 883783 | 2020-12-31 | Greene | Pennsylvania | 42059 | 1690 | 15 |
884047 | 884047 | 2020-12-31 | Greene | Tennessee | 47059 | 5517 | 92 |
884468 | 884468 | 2020-12-31 | Greene | Virginia | 51079 | 543 | 4 |
878279 | 878279 | 2020-12-30 | Greene | Alabama | 1063 | 662 | 20 |
878385 | 878385 | 2020-12-30 | Greene | Arkansas | 5055 | 4398 | 51 |
878703 | 878703 | 2020-12-30 | Greene | Georgia | 13133 | 1108 | 28 |
878878 | 878878 | 2020-12-30 | Greene | Illinois | 17061 | 1109 | 41 |
878977 | 878977 | 2020-12-30 | Greene | Indiana | 18055 | 1915 | 59 |
879078 | 879078 | 2020-12-30 | Greene | Iowa | 19073 | 645 | 7 |
879682 | 879682 | 2020-12-30 | Greene | Mississippi | 28041 | 980 | 25 |
879782 | 879782 | 2020-12-30 | Greene | Missouri | 29077 | 20941 | 297 |
880111 | 880111 | 2020-12-30 | Greene | New York | 36039 | 1260 | 19 |
880190 | 880190 | 2020-12-30 | Greene | North Carolina | 37079 | 1520 | 27 |
880335 | 880335 | 2020-12-30 | Greene | Ohio | 39057 | 9576 | 115 |
880538 | 880538 | 2020-12-30 | Greene | Pennsylvania | 42059 | 1659 | 14 |
880802 | 880802 | 2020-12-30 | Greene | Tennessee | 47059 | 5482 | 92 |
881223 | 881223 | 2020-12-30 | Greene | Virginia | 51079 | 530 | 4 |
875034 | 875034 | 2020-12-29 | Greene | Alabama | 1063 | 650 | 20 |
875140 | 875140 | 2020-12-29 | Greene | Arkansas | 5055 | 4350 | 51 |
875458 | 875458 | 2020-12-29 | Greene | Georgia | 13133 | 1080 | 28 |
875633 | 875633 | 2020-12-29 | Greene | Illinois | 17061 | 1104 | 41 |
875732 | 875732 | 2020-12-29 | Greene | Indiana | 18055 | 1902 | 59 |
875833 | 875833 | 2020-12-29 | Greene | Iowa | 19073 | 644 | 7 |
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);