ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where county = "Union" and deaths = 116 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 7
- Arkansas 30
- Florida 24
- Louisiana 3
- North Carolina 3
- Pennsylvania 3
- Mississippi 2
- Georgia 1
county 1
- Union · 66 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499960 | 2499960 | 2022-05-13 | Union | Florida | 12125 | 4321 | 116 |
2496702 | 2496702 | 2022-05-12 | Union | Florida | 12125 | 4321 | 116 |
2493444 | 2493444 | 2022-05-11 | Union | Florida | 12125 | 4321 | 116 |
2467384 | 2467384 | 2022-05-03 | Union | Florida | 12125 | 4313 | 116 |
2464129 | 2464129 | 2022-05-02 | Union | Florida | 12125 | 4313 | 116 |
2460873 | 2460873 | 2022-05-01 | Union | Florida | 12125 | 4313 | 116 |
2457617 | 2457617 | 2022-04-30 | Union | Florida | 12125 | 4313 | 116 |
2454361 | 2454361 | 2022-04-29 | Union | Florida | 12125 | 4313 | 116 |
2451105 | 2451105 | 2022-04-28 | Union | Florida | 12125 | 4313 | 116 |
2447849 | 2447849 | 2022-04-27 | Union | Florida | 12125 | 4313 | 116 |
2421801 | 2421801 | 2022-04-19 | Union | Florida | 12125 | 4310 | 116 |
2418545 | 2418545 | 2022-04-18 | Union | Florida | 12125 | 4310 | 116 |
2415289 | 2415289 | 2022-04-17 | Union | Florida | 12125 | 4310 | 116 |
2412033 | 2412033 | 2022-04-16 | Union | Florida | 12125 | 4310 | 116 |
2408777 | 2408777 | 2022-04-15 | Union | Florida | 12125 | 4310 | 116 |
2405521 | 2405521 | 2022-04-14 | Union | Florida | 12125 | 4310 | 116 |
2402266 | 2402266 | 2022-04-13 | Union | Florida | 12125 | 4310 | 116 |
2376225 | 2376225 | 2022-04-05 | Union | Florida | 12125 | 4310 | 116 |
2372973 | 2372973 | 2022-04-04 | Union | Florida | 12125 | 4310 | 116 |
2369720 | 2369720 | 2022-04-03 | Union | Florida | 12125 | 4310 | 116 |
2366467 | 2366467 | 2022-04-02 | Union | Florida | 12125 | 4310 | 116 |
2363214 | 2363214 | 2022-04-01 | Union | Florida | 12125 | 4310 | 116 |
2359960 | 2359960 | 2022-03-31 | Union | Florida | 12125 | 4310 | 116 |
2356706 | 2356706 | 2022-03-30 | Union | Florida | 12125 | 4310 | 116 |
2266734 | 2266734 | 2022-03-02 | Union | Mississippi | 28145 | 9441 | 116 |
2263483 | 2263483 | 2022-03-01 | Union | Mississippi | 28145 | 9438 | 116 |
2155847 | 2155847 | 2022-01-27 | Union | Louisiana | 22111 | 6345 | 116 |
2152594 | 2152594 | 2022-01-26 | Union | Louisiana | 22111 | 6303 | 116 |
2149342 | 2149342 | 2022-01-25 | Union | Louisiana | 22111 | 5829 | 116 |
1987927 | 1987927 | 2021-12-06 | Union | Pennsylvania | 42119 | 8295 | 116 |
1984677 | 1984677 | 2021-12-05 | Union | Pennsylvania | 42119 | 8287 | 116 |
1981427 | 1981427 | 2021-12-04 | Union | Pennsylvania | 42119 | 8264 | 116 |
1813900 | 1813900 | 2021-10-14 | Union | Georgia | 13291 | 3505 | 116 |
1615377 | 1615377 | 2021-08-14 | Union | Arkansas | 5139 | 4581 | 116 |
1612128 | 1612128 | 2021-08-13 | Union | Arkansas | 5139 | 4566 | 116 |
1608880 | 1608880 | 2021-08-12 | Union | Arkansas | 5139 | 4531 | 116 |
1605631 | 1605631 | 2021-08-11 | Union | Arkansas | 5139 | 4516 | 116 |
1602382 | 1602382 | 2021-08-10 | Union | Arkansas | 5139 | 4508 | 116 |
1599133 | 1599133 | 2021-08-09 | Union | Arkansas | 5139 | 4490 | 116 |
1595884 | 1595884 | 2021-08-08 | Union | Arkansas | 5139 | 4486 | 116 |
1592635 | 1592635 | 2021-08-07 | Union | Arkansas | 5139 | 4475 | 116 |
1589386 | 1589386 | 2021-08-06 | Union | Arkansas | 5139 | 4450 | 116 |
1586137 | 1586137 | 2021-08-05 | Union | Arkansas | 5139 | 4437 | 116 |
1553655 | 1553655 | 2021-07-26 | Union | Arkansas | 5139 | 4268 | 116 |
1550408 | 1550408 | 2021-07-25 | Union | Arkansas | 5139 | 4263 | 116 |
1547161 | 1547161 | 2021-07-24 | Union | Arkansas | 5139 | 4261 | 116 |
1543914 | 1543914 | 2021-07-23 | Union | Arkansas | 5139 | 4249 | 116 |
1540666 | 1540666 | 2021-07-22 | Union | Arkansas | 5139 | 4237 | 116 |
1537419 | 1537419 | 2021-07-21 | Union | Arkansas | 5139 | 4224 | 116 |
1534171 | 1534171 | 2021-07-20 | Union | Arkansas | 5139 | 4215 | 116 |
1530924 | 1530924 | 2021-07-19 | Union | Arkansas | 5139 | 4196 | 116 |
1527677 | 1527677 | 2021-07-18 | Union | Arkansas | 5139 | 4179 | 116 |
1524430 | 1524430 | 2021-07-17 | Union | Arkansas | 5139 | 4179 | 116 |
1521182 | 1521182 | 2021-07-16 | Union | Arkansas | 5139 | 4179 | 116 |
1517934 | 1517934 | 2021-07-15 | Union | Arkansas | 5139 | 4173 | 116 |
1514687 | 1514687 | 2021-07-14 | Union | Arkansas | 5139 | 4170 | 116 |
1511441 | 1511441 | 2021-07-13 | Union | Arkansas | 5139 | 4163 | 116 |
1508194 | 1508194 | 2021-07-12 | Union | Arkansas | 5139 | 4156 | 116 |
1504948 | 1504948 | 2021-07-11 | Union | Arkansas | 5139 | 4147 | 116 |
1501702 | 1501702 | 2021-07-10 | Union | Arkansas | 5139 | 4147 | 116 |
1498456 | 1498456 | 2021-07-09 | Union | Arkansas | 5139 | 4147 | 116 |
1495209 | 1495209 | 2021-07-08 | Union | Arkansas | 5139 | 4139 | 116 |
1491962 | 1491962 | 2021-07-07 | Union | Arkansas | 5139 | 4138 | 116 |
919185 | 919185 | 2021-01-11 | Union | North Carolina | 37179 | 15016 | 116 |
915940 | 915940 | 2021-01-10 | Union | North Carolina | 37179 | 14875 | 116 |
912695 | 912695 | 2021-01-09 | Union | North Carolina | 37179 | 14564 | 116 |
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);