ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,357 rows where county = "Chester" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 3
- Pennsylvania 758
- Tennessee 750
- South Carolina 749
county 1
- Chester · 2,257 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2394550 | 2394550 | 2022-04-10 | Chester | South Carolina | 45023 | 10090 | 151 |
2394662 | 2394662 | 2022-04-10 | Chester | Tennessee | 47023 | 5840 | 96 |
2391145 | 2391145 | 2022-04-09 | Chester | Pennsylvania | 42029 | 91895 | 1143 |
2391294 | 2391294 | 2022-04-09 | Chester | South Carolina | 45023 | 10090 | 151 |
2391406 | 2391406 | 2022-04-09 | Chester | Tennessee | 47023 | 5840 | 96 |
2387889 | 2387889 | 2022-04-08 | Chester | Pennsylvania | 42029 | 91820 | 1142 |
2388038 | 2388038 | 2022-04-08 | Chester | South Carolina | 45023 | 10090 | 151 |
2388150 | 2388150 | 2022-04-08 | Chester | Tennessee | 47023 | 5840 | 96 |
2384634 | 2384634 | 2022-04-07 | Chester | Pennsylvania | 42029 | 91756 | 1141 |
2384783 | 2384783 | 2022-04-07 | Chester | South Carolina | 45023 | 10090 | 151 |
2384895 | 2384895 | 2022-04-07 | Chester | Tennessee | 47023 | 5840 | 96 |
2381379 | 2381379 | 2022-04-06 | Chester | Pennsylvania | 42029 | 91701 | 1140 |
2381528 | 2381528 | 2022-04-06 | Chester | South Carolina | 45023 | 10090 | 151 |
2381640 | 2381640 | 2022-04-06 | Chester | Tennessee | 47023 | 5840 | 96 |
2378124 | 2378124 | 2022-04-05 | Chester | Pennsylvania | 42029 | 91659 | 1140 |
2378273 | 2378273 | 2022-04-05 | Chester | South Carolina | 45023 | 10090 | 151 |
2378385 | 2378385 | 2022-04-05 | Chester | Tennessee | 47023 | 5835 | 96 |
2374870 | 2374870 | 2022-04-04 | Chester | Pennsylvania | 42029 | 91619 | 1140 |
2375019 | 2375019 | 2022-04-04 | Chester | South Carolina | 45023 | 10088 | 150 |
2375131 | 2375131 | 2022-04-04 | Chester | Tennessee | 47023 | 5835 | 96 |
2371618 | 2371618 | 2022-04-03 | Chester | Pennsylvania | 42029 | 91562 | 1140 |
2371767 | 2371767 | 2022-04-03 | Chester | South Carolina | 45023 | 10088 | 150 |
2371879 | 2371879 | 2022-04-03 | Chester | Tennessee | 47023 | 5835 | 96 |
2368365 | 2368365 | 2022-04-02 | Chester | Pennsylvania | 42029 | 91562 | 1140 |
2368514 | 2368514 | 2022-04-02 | Chester | South Carolina | 45023 | 10088 | 150 |
2368626 | 2368626 | 2022-04-02 | Chester | Tennessee | 47023 | 5835 | 96 |
2365112 | 2365112 | 2022-04-01 | Chester | Pennsylvania | 42029 | 91520 | 1140 |
2365261 | 2365261 | 2022-04-01 | Chester | South Carolina | 45023 | 10088 | 150 |
2365373 | 2365373 | 2022-04-01 | Chester | Tennessee | 47023 | 5835 | 96 |
2361859 | 2361859 | 2022-03-31 | Chester | Pennsylvania | 42029 | 91485 | 1139 |
2362008 | 2362008 | 2022-03-31 | Chester | South Carolina | 45023 | 10088 | 150 |
2362120 | 2362120 | 2022-03-31 | Chester | Tennessee | 47023 | 5835 | 96 |
2358605 | 2358605 | 2022-03-30 | Chester | Pennsylvania | 42029 | 91460 | 1139 |
2358754 | 2358754 | 2022-03-30 | Chester | South Carolina | 45023 | 10088 | 150 |
2358866 | 2358866 | 2022-03-30 | Chester | Tennessee | 47023 | 5835 | 96 |
2355351 | 2355351 | 2022-03-29 | Chester | Pennsylvania | 42029 | 91414 | 1139 |
2355500 | 2355500 | 2022-03-29 | Chester | South Carolina | 45023 | 10088 | 150 |
2355612 | 2355612 | 2022-03-29 | Chester | Tennessee | 47023 | 5823 | 96 |
2352098 | 2352098 | 2022-03-28 | Chester | Pennsylvania | 42029 | 91382 | 1135 |
2352247 | 2352247 | 2022-03-28 | Chester | South Carolina | 45023 | 10087 | 148 |
2352359 | 2352359 | 2022-03-28 | Chester | Tennessee | 47023 | 5823 | 96 |
2348846 | 2348846 | 2022-03-27 | Chester | Pennsylvania | 42029 | 91357 | 1135 |
2348995 | 2348995 | 2022-03-27 | Chester | South Carolina | 45023 | 10087 | 148 |
2349107 | 2349107 | 2022-03-27 | Chester | Tennessee | 47023 | 5823 | 96 |
2345593 | 2345593 | 2022-03-26 | Chester | Pennsylvania | 42029 | 91338 | 1135 |
2345742 | 2345742 | 2022-03-26 | Chester | South Carolina | 45023 | 10087 | 148 |
2345854 | 2345854 | 2022-03-26 | Chester | Tennessee | 47023 | 5823 | 96 |
2342340 | 2342340 | 2022-03-25 | Chester | Pennsylvania | 42029 | 91305 | 1135 |
2342489 | 2342489 | 2022-03-25 | Chester | South Carolina | 45023 | 10087 | 148 |
2342601 | 2342601 | 2022-03-25 | Chester | Tennessee | 47023 | 5823 | 96 |
2339087 | 2339087 | 2022-03-24 | Chester | Pennsylvania | 42029 | 91263 | 1134 |
2339236 | 2339236 | 2022-03-24 | Chester | South Carolina | 45023 | 10087 | 148 |
2339348 | 2339348 | 2022-03-24 | Chester | Tennessee | 47023 | 5823 | 96 |
2335833 | 2335833 | 2022-03-23 | Chester | Pennsylvania | 42029 | 91216 | 1133 |
2335982 | 2335982 | 2022-03-23 | Chester | South Carolina | 45023 | 10087 | 148 |
2336094 | 2336094 | 2022-03-23 | Chester | Tennessee | 47023 | 5823 | 96 |
2332579 | 2332579 | 2022-03-22 | Chester | Pennsylvania | 42029 | 91193 | 1132 |
2332728 | 2332728 | 2022-03-22 | Chester | South Carolina | 45023 | 10087 | 148 |
2332840 | 2332840 | 2022-03-22 | Chester | Tennessee | 47023 | 5798 | 96 |
2329326 | 2329326 | 2022-03-21 | Chester | Pennsylvania | 42029 | 91172 | 1132 |
2329475 | 2329475 | 2022-03-21 | Chester | South Carolina | 45023 | 10085 | 145 |
2329587 | 2329587 | 2022-03-21 | Chester | Tennessee | 47023 | 5798 | 96 |
2326074 | 2326074 | 2022-03-20 | Chester | Pennsylvania | 42029 | 91149 | 1132 |
2326223 | 2326223 | 2022-03-20 | Chester | South Carolina | 45023 | 10085 | 145 |
2326335 | 2326335 | 2022-03-20 | Chester | Tennessee | 47023 | 5798 | 96 |
2322821 | 2322821 | 2022-03-19 | Chester | Pennsylvania | 42029 | 91136 | 1132 |
2322970 | 2322970 | 2022-03-19 | Chester | South Carolina | 45023 | 10085 | 145 |
2323082 | 2323082 | 2022-03-19 | Chester | Tennessee | 47023 | 5798 | 96 |
2319567 | 2319567 | 2022-03-18 | Chester | Pennsylvania | 42029 | 91100 | 1132 |
2319716 | 2319716 | 2022-03-18 | Chester | South Carolina | 45023 | 10085 | 145 |
2319828 | 2319828 | 2022-03-18 | Chester | Tennessee | 47023 | 5798 | 96 |
2316313 | 2316313 | 2022-03-17 | Chester | Pennsylvania | 42029 | 91078 | 1132 |
2316462 | 2316462 | 2022-03-17 | Chester | South Carolina | 45023 | 10085 | 145 |
2316574 | 2316574 | 2022-03-17 | Chester | Tennessee | 47023 | 5798 | 96 |
2313060 | 2313060 | 2022-03-16 | Chester | Pennsylvania | 42029 | 91061 | 1132 |
2313209 | 2313209 | 2022-03-16 | Chester | South Carolina | 45023 | 10085 | 145 |
2313321 | 2313321 | 2022-03-16 | Chester | Tennessee | 47023 | 5798 | 96 |
2309807 | 2309807 | 2022-03-15 | Chester | Pennsylvania | 42029 | 91034 | 1130 |
2309956 | 2309956 | 2022-03-15 | Chester | South Carolina | 45023 | 10085 | 145 |
2310068 | 2310068 | 2022-03-15 | Chester | Tennessee | 47023 | 5768 | 94 |
2306554 | 2306554 | 2022-03-14 | Chester | Pennsylvania | 42029 | 91002 | 1129 |
2306703 | 2306703 | 2022-03-14 | Chester | South Carolina | 45023 | 10085 | 145 |
2306815 | 2306815 | 2022-03-14 | Chester | Tennessee | 47023 | 5768 | 94 |
2303303 | 2303303 | 2022-03-13 | Chester | Pennsylvania | 42029 | 90992 | 1129 |
2303452 | 2303452 | 2022-03-13 | Chester | South Carolina | 45023 | 10085 | 145 |
2303564 | 2303564 | 2022-03-13 | Chester | Tennessee | 47023 | 5768 | 94 |
2300051 | 2300051 | 2022-03-12 | Chester | Pennsylvania | 42029 | 90979 | 1129 |
2300200 | 2300200 | 2022-03-12 | Chester | South Carolina | 45023 | 10085 | 145 |
2300312 | 2300312 | 2022-03-12 | Chester | Tennessee | 47023 | 5768 | 94 |
2296799 | 2296799 | 2022-03-11 | Chester | Pennsylvania | 42029 | 90946 | 1129 |
2296948 | 2296948 | 2022-03-11 | Chester | South Carolina | 45023 | 10085 | 145 |
2297060 | 2297060 | 2022-03-11 | Chester | Tennessee | 47023 | 5768 | 94 |
2293547 | 2293547 | 2022-03-10 | Chester | Pennsylvania | 42029 | 90913 | 1126 |
2293696 | 2293696 | 2022-03-10 | Chester | South Carolina | 45023 | 10082 | 142 |
2293808 | 2293808 | 2022-03-10 | Chester | Tennessee | 47023 | 5768 | 94 |
2290295 | 2290295 | 2022-03-09 | Chester | Pennsylvania | 42029 | 90881 | 1125 |
2290444 | 2290444 | 2022-03-09 | Chester | South Carolina | 45023 | 10083 | 141 |
2290556 | 2290556 | 2022-03-09 | Chester | Tennessee | 47023 | 5768 | 94 |
2287043 | 2287043 | 2022-03-08 | Chester | Pennsylvania | 42029 | 90850 | 1124 |
2287192 | 2287192 | 2022-03-08 | Chester | South Carolina | 45023 | 10083 | 141 |
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);