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
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 3
- Tennessee 753
- Pennsylvania 752
- South Carolina 752
county 1
- Chester · 2,257 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
77833 | 77833 | 2020-04-21 | Chester | Tennessee | 47023 | 9 | 0 |
80466 | 80466 | 2020-04-22 | Chester | Pennsylvania | 42029 | 977 | 67 |
80537 | 80537 | 2020-04-22 | Chester | South Carolina | 45023 | 25 | 0 |
80623 | 80623 | 2020-04-22 | Chester | Tennessee | 47023 | 9 | 0 |
83265 | 83265 | 2020-04-23 | Chester | Pennsylvania | 42029 | 1017 | 64 |
83336 | 83336 | 2020-04-23 | Chester | South Carolina | 45023 | 26 | 0 |
83422 | 83422 | 2020-04-23 | Chester | Tennessee | 47023 | 10 | 0 |
86069 | 86069 | 2020-04-24 | Chester | Pennsylvania | 42029 | 1102 | 77 |
86140 | 86140 | 2020-04-24 | Chester | South Carolina | 45023 | 26 | 0 |
86227 | 86227 | 2020-04-24 | Chester | Tennessee | 47023 | 10 | 0 |
88883 | 88883 | 2020-04-25 | Chester | Pennsylvania | 42029 | 1174 | 82 |
88954 | 88954 | 2020-04-25 | Chester | South Carolina | 45023 | 27 | 0 |
89042 | 89042 | 2020-04-25 | Chester | Tennessee | 47023 | 10 | 0 |
91699 | 91699 | 2020-04-26 | Chester | Pennsylvania | 42029 | 1217 | 82 |
91770 | 91770 | 2020-04-26 | Chester | South Carolina | 45023 | 27 | 0 |
91859 | 91859 | 2020-04-26 | Chester | Tennessee | 47023 | 10 | 0 |
94526 | 94526 | 2020-04-27 | Chester | Pennsylvania | 42029 | 1251 | 81 |
94597 | 94597 | 2020-04-27 | Chester | South Carolina | 45023 | 27 | 0 |
94687 | 94687 | 2020-04-27 | Chester | Tennessee | 47023 | 10 | 0 |
97365 | 97365 | 2020-04-28 | Chester | Pennsylvania | 42029 | 1289 | 85 |
97436 | 97436 | 2020-04-28 | Chester | South Carolina | 45023 | 27 | 0 |
97527 | 97527 | 2020-04-28 | Chester | Tennessee | 47023 | 10 | 0 |
100214 | 100214 | 2020-04-29 | Chester | Pennsylvania | 42029 | 1339 | 102 |
100285 | 100285 | 2020-04-29 | Chester | South Carolina | 45023 | 27 | 0 |
100377 | 100377 | 2020-04-29 | Chester | Tennessee | 47023 | 10 | 0 |
103067 | 103067 | 2020-04-30 | Chester | Pennsylvania | 42029 | 1412 | 111 |
103138 | 103138 | 2020-04-30 | Chester | South Carolina | 45023 | 30 | 0 |
103230 | 103230 | 2020-04-30 | Chester | Tennessee | 47023 | 10 | 0 |
105930 | 105930 | 2020-05-01 | Chester | Pennsylvania | 42029 | 1470 | 112 |
106001 | 106001 | 2020-05-01 | Chester | South Carolina | 45023 | 30 | 0 |
106093 | 106093 | 2020-05-01 | Chester | Tennessee | 47023 | 10 | 0 |
108797 | 108797 | 2020-05-02 | Chester | Pennsylvania | 42029 | 1514 | 117 |
108868 | 108868 | 2020-05-02 | Chester | South Carolina | 45023 | 32 | 0 |
108960 | 108960 | 2020-05-02 | Chester | Tennessee | 47023 | 10 | 0 |
111671 | 111671 | 2020-05-03 | Chester | Pennsylvania | 42029 | 1546 | 117 |
111742 | 111742 | 2020-05-03 | Chester | South Carolina | 45023 | 34 | 0 |
111834 | 111834 | 2020-05-03 | Chester | Tennessee | 47023 | 10 | 0 |
114553 | 114553 | 2020-05-04 | Chester | Pennsylvania | 42029 | 1605 | 118 |
114624 | 114624 | 2020-05-04 | Chester | South Carolina | 45023 | 34 | 0 |
114716 | 114716 | 2020-05-04 | Chester | Tennessee | 47023 | 10 | 0 |
117434 | 117434 | 2020-05-05 | Chester | Pennsylvania | 42029 | 1647 | 149 |
117580 | 117580 | 2020-05-05 | Chester | South Carolina | 45023 | 35 | 0 |
117672 | 117672 | 2020-05-05 | Chester | Tennessee | 47023 | 10 | 0 |
120396 | 120396 | 2020-05-06 | Chester | Pennsylvania | 42029 | 1677 | 156 |
120542 | 120542 | 2020-05-06 | Chester | South Carolina | 45023 | 34 | 0 |
120636 | 120636 | 2020-05-06 | Chester | Tennessee | 47023 | 10 | 0 |
123373 | 123373 | 2020-05-07 | Chester | Pennsylvania | 42029 | 1716 | 167 |
123520 | 123520 | 2020-05-07 | Chester | South Carolina | 45023 | 35 | 0 |
123614 | 123614 | 2020-05-07 | Chester | Tennessee | 47023 | 10 | 0 |
126356 | 126356 | 2020-05-08 | Chester | Pennsylvania | 42029 | 1770 | 176 |
126503 | 126503 | 2020-05-08 | Chester | South Carolina | 45023 | 39 | 0 |
126597 | 126597 | 2020-05-08 | Chester | Tennessee | 47023 | 12 | 0 |
129345 | 129345 | 2020-05-09 | Chester | Pennsylvania | 42029 | 1816 | 183 |
129492 | 129492 | 2020-05-09 | Chester | South Carolina | 45023 | 39 | 0 |
129586 | 129586 | 2020-05-09 | Chester | Tennessee | 47023 | 12 | 0 |
132334 | 132334 | 2020-05-10 | Chester | Pennsylvania | 42029 | 1906 | 184 |
132481 | 132481 | 2020-05-10 | Chester | South Carolina | 45023 | 38 | 0 |
132575 | 132575 | 2020-05-10 | Chester | Tennessee | 47023 | 12 | 0 |
135325 | 135325 | 2020-05-11 | Chester | Pennsylvania | 42029 | 1926 | 187 |
135472 | 135472 | 2020-05-11 | Chester | South Carolina | 45023 | 40 | 0 |
135566 | 135566 | 2020-05-11 | Chester | Tennessee | 47023 | 12 | 0 |
138315 | 138315 | 2020-05-12 | Chester | Pennsylvania | 42029 | 1973 | 189 |
138462 | 138462 | 2020-05-12 | Chester | South Carolina | 45023 | 39 | 0 |
138556 | 138556 | 2020-05-12 | Chester | Tennessee | 47023 | 12 | 0 |
141311 | 141311 | 2020-05-13 | Chester | Pennsylvania | 42029 | 1996 | 197 |
141458 | 141458 | 2020-05-13 | Chester | South Carolina | 45023 | 39 | 0 |
141552 | 141552 | 2020-05-13 | Chester | Tennessee | 47023 | 12 | 0 |
144307 | 144307 | 2020-05-14 | Chester | Pennsylvania | 42029 | 2008 | 213 |
144454 | 144454 | 2020-05-14 | Chester | South Carolina | 45023 | 39 | 0 |
144549 | 144549 | 2020-05-14 | Chester | Tennessee | 47023 | 12 | 0 |
147308 | 147308 | 2020-05-15 | Chester | Pennsylvania | 42029 | 2102 | 218 |
147455 | 147455 | 2020-05-15 | Chester | South Carolina | 45023 | 40 | 0 |
147550 | 147550 | 2020-05-15 | Chester | Tennessee | 47023 | 12 | 0 |
150315 | 150315 | 2020-05-16 | Chester | Pennsylvania | 42029 | 2143 | 222 |
150463 | 150463 | 2020-05-16 | Chester | South Carolina | 45023 | 41 | 0 |
150558 | 150558 | 2020-05-16 | Chester | Tennessee | 47023 | 12 | 0 |
153326 | 153326 | 2020-05-17 | Chester | Pennsylvania | 42029 | 2163 | 220 |
153474 | 153474 | 2020-05-17 | Chester | South Carolina | 45023 | 42 | 0 |
153569 | 153569 | 2020-05-17 | Chester | Tennessee | 47023 | 12 | 0 |
156343 | 156343 | 2020-05-18 | Chester | Pennsylvania | 42029 | 2163 | 227 |
156491 | 156491 | 2020-05-18 | Chester | South Carolina | 45023 | 42 | 0 |
156586 | 156586 | 2020-05-18 | Chester | Tennessee | 47023 | 12 | 0 |
159364 | 159364 | 2020-05-19 | Chester | Pennsylvania | 42029 | 2242 | 230 |
159512 | 159512 | 2020-05-19 | Chester | South Carolina | 45023 | 41 | 0 |
159607 | 159607 | 2020-05-19 | Chester | Tennessee | 47023 | 12 | 0 |
162391 | 162391 | 2020-05-20 | Chester | Pennsylvania | 42029 | 2242 | 235 |
162539 | 162539 | 2020-05-20 | Chester | South Carolina | 45023 | 41 | 0 |
162634 | 162634 | 2020-05-20 | Chester | Tennessee | 47023 | 12 | 0 |
165420 | 165420 | 2020-05-21 | Chester | Pennsylvania | 42029 | 2267 | 238 |
165568 | 165568 | 2020-05-21 | Chester | South Carolina | 45023 | 41 | 0 |
165663 | 165663 | 2020-05-21 | Chester | Tennessee | 47023 | 12 | 0 |
168456 | 168456 | 2020-05-22 | Chester | Pennsylvania | 42029 | 2363 | 242 |
168604 | 168604 | 2020-05-22 | Chester | South Carolina | 45023 | 44 | 0 |
168699 | 168699 | 2020-05-22 | Chester | Tennessee | 47023 | 12 | 0 |
171495 | 171495 | 2020-05-23 | Chester | Pennsylvania | 42029 | 2403 | 245 |
171643 | 171643 | 2020-05-23 | Chester | South Carolina | 45023 | 46 | 0 |
171738 | 171738 | 2020-05-23 | Chester | Tennessee | 47023 | 12 | 0 |
174537 | 174537 | 2020-05-24 | Chester | Pennsylvania | 42029 | 2428 | 248 |
174685 | 174685 | 2020-05-24 | Chester | South Carolina | 45023 | 51 | 0 |
174781 | 174781 | 2020-05-24 | Chester | Tennessee | 47023 | 12 | 0 |
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);