ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where county = "Greene" and deaths = 27 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 11
- North Carolina 18
- Virginia 9
- Georgia 7
- Alabama 6
- Indiana 6
- Mississippi 6
- Arkansas 2
- Ohio 2
- Illinois 1
- New York 1
- Pennsylvania 1
county 1
- Greene · 59 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1790351 | 1790351 | 2021-10-06 | Greene | Virginia | 51079 | 2064 | 27 |
1787103 | 1787103 | 2021-10-05 | Greene | Virginia | 51079 | 2052 | 27 |
1783854 | 1783854 | 2021-10-04 | Greene | Virginia | 51079 | 2052 | 27 |
1780605 | 1780605 | 2021-10-03 | Greene | Virginia | 51079 | 2017 | 27 |
1777355 | 1777355 | 2021-10-02 | Greene | Virginia | 51079 | 2017 | 27 |
1774105 | 1774105 | 2021-10-01 | Greene | Virginia | 51079 | 2017 | 27 |
1770855 | 1770855 | 2021-09-30 | Greene | Virginia | 51079 | 2002 | 27 |
1767606 | 1767606 | 2021-09-29 | Greene | Virginia | 51079 | 1987 | 27 |
1764357 | 1764357 | 2021-09-28 | Greene | Virginia | 51079 | 1976 | 27 |
988623 | 988623 | 2021-02-02 | Greene | Alabama | 1063 | 810 | 27 |
985376 | 985376 | 2021-02-01 | Greene | Alabama | 1063 | 806 | 27 |
982129 | 982129 | 2021-01-31 | Greene | Alabama | 1063 | 801 | 27 |
978883 | 978883 | 2021-01-30 | Greene | Alabama | 1063 | 795 | 27 |
975638 | 975638 | 2021-01-29 | Greene | Alabama | 1063 | 795 | 27 |
972393 | 972393 | 2021-01-28 | Greene | Alabama | 1063 | 790 | 27 |
951937 | 951937 | 2021-01-21 | Greene | Pennsylvania | 42059 | 2267 | 27 |
915382 | 915382 | 2021-01-10 | Greene | Mississippi | 28041 | 1051 | 27 |
912137 | 912137 | 2021-01-09 | Greene | Mississippi | 28041 | 1045 | 27 |
908892 | 908892 | 2021-01-08 | Greene | Mississippi | 28041 | 1031 | 27 |
905646 | 905646 | 2021-01-07 | Greene | Mississippi | 28041 | 1023 | 27 |
902401 | 902401 | 2021-01-06 | Greene | Mississippi | 28041 | 1019 | 27 |
899156 | 899156 | 2021-01-05 | Greene | Mississippi | 28041 | 1009 | 27 |
893094 | 893094 | 2021-01-03 | Greene | New York | 36039 | 1462 | 27 |
886680 | 886680 | 2021-01-01 | Greene | North Carolina | 37079 | 1534 | 27 |
883435 | 883435 | 2020-12-31 | Greene | North Carolina | 37079 | 1534 | 27 |
880190 | 880190 | 2020-12-30 | Greene | North Carolina | 37079 | 1520 | 27 |
876945 | 876945 | 2020-12-29 | Greene | North Carolina | 37079 | 1500 | 27 |
873700 | 873700 | 2020-12-28 | Greene | North Carolina | 37079 | 1499 | 27 |
870455 | 870455 | 2020-12-27 | Greene | North Carolina | 37079 | 1495 | 27 |
867210 | 867210 | 2020-12-26 | Greene | North Carolina | 37079 | 1493 | 27 |
863965 | 863965 | 2020-12-25 | Greene | North Carolina | 37079 | 1469 | 27 |
860720 | 860720 | 2020-12-24 | Greene | North Carolina | 37079 | 1469 | 27 |
857475 | 857475 | 2020-12-23 | Greene | North Carolina | 37079 | 1469 | 27 |
854230 | 854230 | 2020-12-22 | Greene | North Carolina | 37079 | 1454 | 27 |
850985 | 850985 | 2020-12-21 | Greene | North Carolina | 37079 | 1442 | 27 |
847740 | 847740 | 2020-12-20 | Greene | North Carolina | 37079 | 1437 | 27 |
844495 | 844495 | 2020-12-19 | Greene | North Carolina | 37079 | 1425 | 27 |
831512 | 831512 | 2020-12-15 | Greene | North Carolina | 37079 | 1357 | 27 |
795810 | 795810 | 2020-12-04 | Greene | North Carolina | 37079 | 1244 | 27 |
792565 | 792565 | 2020-12-03 | Greene | North Carolina | 37079 | 1230 | 27 |
789320 | 789320 | 2020-12-02 | Greene | North Carolina | 37079 | 1212 | 27 |
784272 | 784272 | 2020-12-01 | Greene | Arkansas | 5055 | 3044 | 27 |
781027 | 781027 | 2020-11-30 | Greene | Arkansas | 5055 | 2953 | 27 |
765292 | 765292 | 2020-11-25 | Greene | Illinois | 17061 | 787 | 27 |
716442 | 716442 | 2020-11-10 | Greene | Georgia | 13133 | 665 | 27 |
713198 | 713198 | 2020-11-09 | Greene | Georgia | 13133 | 664 | 27 |
709954 | 709954 | 2020-11-08 | Greene | Georgia | 13133 | 661 | 27 |
706710 | 706710 | 2020-11-07 | Greene | Georgia | 13133 | 660 | 27 |
703467 | 703467 | 2020-11-06 | Greene | Georgia | 13133 | 657 | 27 |
700224 | 700224 | 2020-11-05 | Greene | Georgia | 13133 | 652 | 27 |
696980 | 696980 | 2020-11-04 | Greene | Georgia | 13133 | 652 | 27 |
549453 | 549453 | 2020-09-19 | Greene | Ohio | 39057 | 1338 | 27 |
539741 | 539741 | 2020-09-16 | Greene | Ohio | 39057 | 1278 | 27 |
194485 | 194485 | 2020-05-31 | Greene | Indiana | 18055 | 173 | 27 |
191418 | 191418 | 2020-05-30 | Greene | Indiana | 18055 | 173 | 27 |
188353 | 188353 | 2020-05-29 | Greene | Indiana | 18055 | 172 | 27 |
185295 | 185295 | 2020-05-28 | Greene | Indiana | 18055 | 172 | 27 |
182241 | 182241 | 2020-05-27 | Greene | Indiana | 18055 | 172 | 27 |
179197 | 179197 | 2020-05-26 | Greene | Indiana | 18055 | 171 | 27 |
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);