ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where county = "Union" and deaths = 70 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
- Florida 72
- Tennessee 14
- Oregon 7
- Georgia 4
- Mississippi 3
- Arkansas 2
- North Carolina 2
- Louisiana 1
- Pennsylvania 1
- South Carolina 1
county 1
- Union · 107 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2310143 | 2310143 | 2022-03-15 | Union | Tennessee | 47173 | 5382 | 70 |
2306890 | 2306890 | 2022-03-14 | Union | Tennessee | 47173 | 5382 | 70 |
2303639 | 2303639 | 2022-03-13 | Union | Tennessee | 47173 | 5382 | 70 |
2300387 | 2300387 | 2022-03-12 | Union | Tennessee | 47173 | 5382 | 70 |
2297135 | 2297135 | 2022-03-11 | Union | Tennessee | 47173 | 5382 | 70 |
2293883 | 2293883 | 2022-03-10 | Union | Tennessee | 47173 | 5382 | 70 |
2290631 | 2290631 | 2022-03-09 | Union | Tennessee | 47173 | 5382 | 70 |
2241855 | 2241855 | 2022-02-22 | Union | Tennessee | 47173 | 5254 | 70 |
2238604 | 2238604 | 2022-02-21 | Union | Tennessee | 47173 | 5254 | 70 |
2235353 | 2235353 | 2022-02-20 | Union | Tennessee | 47173 | 5254 | 70 |
2232102 | 2232102 | 2022-02-19 | Union | Tennessee | 47173 | 5254 | 70 |
2228851 | 2228851 | 2022-02-18 | Union | Tennessee | 47173 | 5254 | 70 |
2225600 | 2225600 | 2022-02-17 | Union | Tennessee | 47173 | 5254 | 70 |
2222349 | 2222349 | 2022-02-16 | Union | Tennessee | 47173 | 5254 | 70 |
2202481 | 2202481 | 2022-02-10 | Union | Oregon | 41061 | 4860 | 70 |
2199227 | 2199227 | 2022-02-09 | Union | Oregon | 41061 | 4840 | 70 |
2195973 | 2195973 | 2022-02-08 | Union | Oregon | 41061 | 4825 | 70 |
2192719 | 2192719 | 2022-02-07 | Union | Oregon | 41061 | 4791 | 70 |
2189465 | 2189465 | 2022-02-06 | Union | Oregon | 41061 | 4769 | 70 |
2186212 | 2186212 | 2022-02-05 | Union | Oregon | 41061 | 4769 | 70 |
2182960 | 2182960 | 2022-02-04 | Union | Oregon | 41061 | 4769 | 70 |
1245607 | 1245607 | 2021-04-22 | Union | Georgia | 13291 | 2195 | 70 |
1242360 | 1242360 | 2021-04-21 | Union | Georgia | 13291 | 2186 | 70 |
1239113 | 1239113 | 2021-04-20 | Union | Georgia | 13291 | 2186 | 70 |
1235866 | 1235866 | 2021-04-19 | Union | Georgia | 13291 | 2174 | 70 |
1177255 | 1177255 | 2021-04-01 | Union | Florida | 12125 | 1775 | 70 |
1174008 | 1174008 | 2021-03-31 | Union | Florida | 12125 | 1774 | 70 |
1170761 | 1170761 | 2021-03-30 | Union | Florida | 12125 | 1773 | 70 |
1167513 | 1167513 | 2021-03-29 | Union | Florida | 12125 | 1772 | 70 |
1164265 | 1164265 | 2021-03-28 | Union | Florida | 12125 | 1772 | 70 |
1161017 | 1161017 | 2021-03-27 | Union | Florida | 12125 | 1771 | 70 |
1157769 | 1157769 | 2021-03-26 | Union | Florida | 12125 | 1769 | 70 |
1154522 | 1154522 | 2021-03-25 | Union | Florida | 12125 | 1769 | 70 |
1151275 | 1151275 | 2021-03-24 | Union | Florida | 12125 | 1769 | 70 |
1144781 | 1144781 | 2021-03-22 | Union | Florida | 12125 | 1766 | 70 |
1141534 | 1141534 | 2021-03-21 | Union | Florida | 12125 | 1765 | 70 |
1138288 | 1138288 | 2021-03-20 | Union | Florida | 12125 | 1765 | 70 |
1135042 | 1135042 | 2021-03-19 | Union | Florida | 12125 | 1764 | 70 |
1131795 | 1131795 | 2021-03-18 | Union | Florida | 12125 | 1762 | 70 |
1128547 | 1128547 | 2021-03-17 | Union | Florida | 12125 | 1762 | 70 |
1125301 | 1125301 | 2021-03-16 | Union | Florida | 12125 | 1762 | 70 |
1122055 | 1122055 | 2021-03-15 | Union | Florida | 12125 | 1760 | 70 |
1118808 | 1118808 | 2021-03-14 | Union | Florida | 12125 | 1760 | 70 |
1115561 | 1115561 | 2021-03-13 | Union | Florida | 12125 | 1759 | 70 |
1112315 | 1112315 | 2021-03-12 | Union | Florida | 12125 | 1755 | 70 |
1109069 | 1109069 | 2021-03-11 | Union | Florida | 12125 | 1752 | 70 |
1105823 | 1105823 | 2021-03-10 | Union | Florida | 12125 | 1751 | 70 |
1102577 | 1102577 | 2021-03-09 | Union | Florida | 12125 | 1750 | 70 |
1099331 | 1099331 | 2021-03-08 | Union | Florida | 12125 | 1750 | 70 |
1096083 | 1096083 | 2021-03-07 | Union | Florida | 12125 | 1748 | 70 |
1092837 | 1092837 | 2021-03-06 | Union | Florida | 12125 | 1748 | 70 |
1089591 | 1089591 | 2021-03-05 | Union | Florida | 12125 | 1744 | 70 |
1086346 | 1086346 | 2021-03-04 | Union | Florida | 12125 | 1742 | 70 |
1083100 | 1083100 | 2021-03-03 | Union | Florida | 12125 | 1740 | 70 |
1079854 | 1079854 | 2021-03-02 | Union | Florida | 12125 | 1740 | 70 |
1076609 | 1076609 | 2021-03-01 | Union | Florida | 12125 | 1740 | 70 |
1073363 | 1073363 | 2021-02-28 | Union | Florida | 12125 | 1740 | 70 |
1070117 | 1070117 | 2021-02-27 | Union | Florida | 12125 | 1741 | 70 |
1066872 | 1066872 | 2021-02-26 | Union | Florida | 12125 | 1740 | 70 |
1063627 | 1063627 | 2021-02-25 | Union | Florida | 12125 | 1740 | 70 |
1060382 | 1060382 | 2021-02-24 | Union | Florida | 12125 | 1732 | 70 |
1057136 | 1057136 | 2021-02-23 | Union | Florida | 12125 | 1730 | 70 |
1053890 | 1053890 | 2021-02-22 | Union | Florida | 12125 | 1728 | 70 |
1050643 | 1050643 | 2021-02-21 | Union | Florida | 12125 | 1728 | 70 |
1047396 | 1047396 | 2021-02-20 | Union | Florida | 12125 | 1727 | 70 |
1044151 | 1044151 | 2021-02-19 | Union | Florida | 12125 | 1721 | 70 |
1040906 | 1040906 | 2021-02-18 | Union | Florida | 12125 | 1721 | 70 |
1037661 | 1037661 | 2021-02-17 | Union | Florida | 12125 | 1719 | 70 |
1034416 | 1034416 | 2021-02-16 | Union | Florida | 12125 | 1715 | 70 |
1036488 | 1036488 | 2021-02-16 | Union | South Carolina | 45087 | 2461 | 70 |
1031170 | 1031170 | 2021-02-15 | Union | Florida | 12125 | 1712 | 70 |
1027923 | 1027923 | 2021-02-14 | Union | Florida | 12125 | 1711 | 70 |
1024678 | 1024678 | 2021-02-13 | Union | Florida | 12125 | 1707 | 70 |
1021433 | 1021433 | 2021-02-12 | Union | Florida | 12125 | 1704 | 70 |
1018188 | 1018188 | 2021-02-11 | Union | Florida | 12125 | 1702 | 70 |
1014943 | 1014943 | 2021-02-10 | Union | Florida | 12125 | 1700 | 70 |
1011698 | 1011698 | 2021-02-09 | Union | Florida | 12125 | 1698 | 70 |
1008452 | 1008452 | 2021-02-08 | Union | Florida | 12125 | 1695 | 70 |
1009555 | 1009555 | 2021-02-08 | Union | Mississippi | 28145 | 3791 | 70 |
1005206 | 1005206 | 2021-02-07 | Union | Florida | 12125 | 1694 | 70 |
1006308 | 1006308 | 2021-02-07 | Union | Mississippi | 28145 | 3785 | 70 |
1001960 | 1001960 | 2021-02-06 | Union | Florida | 12125 | 1687 | 70 |
1003062 | 1003062 | 2021-02-06 | Union | Mississippi | 28145 | 3780 | 70 |
998714 | 998714 | 2021-02-05 | Union | Florida | 12125 | 1680 | 70 |
995468 | 995468 | 2021-02-04 | Union | Florida | 12125 | 1672 | 70 |
992222 | 992222 | 2021-02-03 | Union | Florida | 12125 | 1670 | 70 |
988976 | 988976 | 2021-02-02 | Union | Florida | 12125 | 1670 | 70 |
985729 | 985729 | 2021-02-01 | Union | Florida | 12125 | 1665 | 70 |
982482 | 982482 | 2021-01-31 | Union | Florida | 12125 | 1664 | 70 |
979236 | 979236 | 2021-01-30 | Union | Florida | 12125 | 1660 | 70 |
975991 | 975991 | 2021-01-29 | Union | Florida | 12125 | 1657 | 70 |
972746 | 972746 | 2021-01-28 | Union | Florida | 12125 | 1648 | 70 |
969501 | 969501 | 2021-01-27 | Union | Florida | 12125 | 1642 | 70 |
971437 | 971437 | 2021-01-27 | Union | Pennsylvania | 42119 | 3946 | 70 |
966257 | 966257 | 2021-01-26 | Union | Florida | 12125 | 1638 | 70 |
963012 | 963012 | 2021-01-25 | Union | Florida | 12125 | 1637 | 70 |
959767 | 959767 | 2021-01-24 | Union | Florida | 12125 | 1635 | 70 |
956521 | 956521 | 2021-01-23 | Union | Florida | 12125 | 1631 | 70 |
953276 | 953276 | 2021-01-22 | Union | Florida | 12125 | 1622 | 70 |
950031 | 950031 | 2021-01-21 | Union | Florida | 12125 | 1620 | 70 |
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);