ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,572 rows where county = "Chesterfield" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
10542 | 10542 | 2020-03-24 | Chesterfield | South Carolina | 45025 | 1 | 0 |
12013 | 12013 | 2020-03-25 | Chesterfield | South Carolina | 45025 | 3 | 0 |
13635 | 13635 | 2020-03-26 | Chesterfield | South Carolina | 45025 | 3 | 0 |
15382 | 15382 | 2020-03-27 | Chesterfield | South Carolina | 45025 | 4 | 0 |
17236 | 17236 | 2020-03-28 | Chesterfield | South Carolina | 45025 | 4 | 0 |
19176 | 19176 | 2020-03-29 | Chesterfield | South Carolina | 45025 | 4 | 0 |
21228 | 21228 | 2020-03-30 | Chesterfield | South Carolina | 45025 | 6 | 0 |
23366 | 23366 | 2020-03-31 | Chesterfield | South Carolina | 45025 | 6 | 0 |
25564 | 25564 | 2020-04-01 | Chesterfield | South Carolina | 45025 | 9 | 0 |
27838 | 27838 | 2020-04-02 | Chesterfield | South Carolina | 45025 | 10 | 0 |
30173 | 30173 | 2020-04-03 | Chesterfield | South Carolina | 45025 | 10 | 0 |
32564 | 32564 | 2020-04-04 | Chesterfield | South Carolina | 45025 | 13 | 0 |
35000 | 35000 | 2020-04-05 | Chesterfield | South Carolina | 45025 | 13 | 0 |
37475 | 37475 | 2020-04-06 | Chesterfield | South Carolina | 45025 | 15 | 0 |
39998 | 39998 | 2020-04-07 | Chesterfield | South Carolina | 45025 | 16 | 0 |
42558 | 42558 | 2020-04-08 | Chesterfield | South Carolina | 45025 | 20 | 0 |
45144 | 45144 | 2020-04-09 | Chesterfield | South Carolina | 45025 | 21 | 0 |
47761 | 47761 | 2020-04-10 | Chesterfield | South Carolina | 45025 | 22 | 0 |
50418 | 50418 | 2020-04-11 | Chesterfield | South Carolina | 45025 | 22 | 0 |
53091 | 53091 | 2020-04-12 | Chesterfield | South Carolina | 45025 | 22 | 0 |
55776 | 55776 | 2020-04-13 | Chesterfield | South Carolina | 45025 | 23 | 0 |
58479 | 58479 | 2020-04-14 | Chesterfield | South Carolina | 45025 | 27 | 0 |
61194 | 61194 | 2020-04-15 | Chesterfield | South Carolina | 45025 | 28 | 0 |
63920 | 63920 | 2020-04-16 | Chesterfield | South Carolina | 45025 | 29 | 0 |
66666 | 66666 | 2020-04-17 | Chesterfield | South Carolina | 45025 | 31 | 0 |
69424 | 69424 | 2020-04-18 | Chesterfield | South Carolina | 45025 | 35 | 0 |
72191 | 72191 | 2020-04-19 | Chesterfield | South Carolina | 45025 | 36 | 0 |
74966 | 74966 | 2020-04-20 | Chesterfield | South Carolina | 45025 | 36 | 0 |
77748 | 77748 | 2020-04-21 | Chesterfield | South Carolina | 45025 | 37 | 0 |
80538 | 80538 | 2020-04-22 | Chesterfield | South Carolina | 45025 | 37 | 0 |
83337 | 83337 | 2020-04-23 | Chesterfield | South Carolina | 45025 | 39 | 0 |
86141 | 86141 | 2020-04-24 | Chesterfield | South Carolina | 45025 | 40 | 0 |
88955 | 88955 | 2020-04-25 | Chesterfield | South Carolina | 45025 | 44 | 0 |
91771 | 91771 | 2020-04-26 | Chesterfield | South Carolina | 45025 | 44 | 0 |
94598 | 94598 | 2020-04-27 | Chesterfield | South Carolina | 45025 | 46 | 0 |
97437 | 97437 | 2020-04-28 | Chesterfield | South Carolina | 45025 | 47 | 0 |
100286 | 100286 | 2020-04-29 | Chesterfield | South Carolina | 45025 | 48 | 0 |
103139 | 103139 | 2020-04-30 | Chesterfield | South Carolina | 45025 | 51 | 1 |
106002 | 106002 | 2020-05-01 | Chesterfield | South Carolina | 45025 | 58 | 1 |
108869 | 108869 | 2020-05-02 | Chesterfield | South Carolina | 45025 | 59 | 1 |
111743 | 111743 | 2020-05-03 | Chesterfield | South Carolina | 45025 | 59 | 1 |
114625 | 114625 | 2020-05-04 | Chesterfield | South Carolina | 45025 | 60 | 1 |
117581 | 117581 | 2020-05-05 | Chesterfield | South Carolina | 45025 | 61 | 1 |
120543 | 120543 | 2020-05-06 | Chesterfield | South Carolina | 45025 | 65 | 1 |
123521 | 123521 | 2020-05-07 | Chesterfield | South Carolina | 45025 | 69 | 1 |
126504 | 126504 | 2020-05-08 | Chesterfield | South Carolina | 45025 | 72 | 1 |
129493 | 129493 | 2020-05-09 | Chesterfield | South Carolina | 45025 | 75 | 1 |
132482 | 132482 | 2020-05-10 | Chesterfield | South Carolina | 45025 | 79 | 1 |
135473 | 135473 | 2020-05-11 | Chesterfield | South Carolina | 45025 | 80 | 1 |
138463 | 138463 | 2020-05-12 | Chesterfield | South Carolina | 45025 | 80 | 1 |
141459 | 141459 | 2020-05-13 | Chesterfield | South Carolina | 45025 | 85 | 1 |
144455 | 144455 | 2020-05-14 | Chesterfield | South Carolina | 45025 | 90 | 1 |
147456 | 147456 | 2020-05-15 | Chesterfield | South Carolina | 45025 | 93 | 1 |
150464 | 150464 | 2020-05-16 | Chesterfield | South Carolina | 45025 | 94 | 1 |
153475 | 153475 | 2020-05-17 | Chesterfield | South Carolina | 45025 | 96 | 1 |
156492 | 156492 | 2020-05-18 | Chesterfield | South Carolina | 45025 | 98 | 1 |
159513 | 159513 | 2020-05-19 | Chesterfield | South Carolina | 45025 | 101 | 1 |
162540 | 162540 | 2020-05-20 | Chesterfield | South Carolina | 45025 | 105 | 1 |
165569 | 165569 | 2020-05-21 | Chesterfield | South Carolina | 45025 | 108 | 1 |
168605 | 168605 | 2020-05-22 | Chesterfield | South Carolina | 45025 | 118 | 1 |
171644 | 171644 | 2020-05-23 | Chesterfield | South Carolina | 45025 | 129 | 2 |
174686 | 174686 | 2020-05-24 | Chesterfield | South Carolina | 45025 | 131 | 2 |
177730 | 177730 | 2020-05-25 | Chesterfield | South Carolina | 45025 | 132 | 3 |
180773 | 180773 | 2020-05-26 | Chesterfield | South Carolina | 45025 | 141 | 3 |
183823 | 183823 | 2020-05-27 | Chesterfield | South Carolina | 45025 | 149 | 3 |
186880 | 186880 | 2020-05-28 | Chesterfield | South Carolina | 45025 | 151 | 4 |
189942 | 189942 | 2020-05-29 | Chesterfield | South Carolina | 45025 | 165 | 4 |
193007 | 193007 | 2020-05-30 | Chesterfield | South Carolina | 45025 | 180 | 4 |
196076 | 196076 | 2020-05-31 | Chesterfield | South Carolina | 45025 | 196 | 4 |
199149 | 199149 | 2020-06-01 | Chesterfield | South Carolina | 45025 | 200 | 4 |
202224 | 202224 | 2020-06-02 | Chesterfield | South Carolina | 45025 | 203 | 4 |
205301 | 205301 | 2020-06-03 | Chesterfield | South Carolina | 45025 | 207 | 4 |
208382 | 208382 | 2020-06-04 | Chesterfield | South Carolina | 45025 | 221 | 4 |
211464 | 211464 | 2020-06-05 | Chesterfield | South Carolina | 45025 | 236 | 4 |
214550 | 214550 | 2020-06-06 | Chesterfield | South Carolina | 45025 | 242 | 5 |
217640 | 217640 | 2020-06-07 | Chesterfield | South Carolina | 45025 | 247 | 5 |
220732 | 220732 | 2020-06-08 | Chesterfield | South Carolina | 45025 | 250 | 6 |
223827 | 223827 | 2020-06-09 | Chesterfield | South Carolina | 45025 | 256 | 6 |
226927 | 226927 | 2020-06-10 | Chesterfield | South Carolina | 45025 | 265 | 7 |
230031 | 230031 | 2020-06-11 | Chesterfield | South Carolina | 45025 | 272 | 7 |
233136 | 233136 | 2020-06-12 | Chesterfield | South Carolina | 45025 | 281 | 7 |
236241 | 236241 | 2020-06-13 | Chesterfield | South Carolina | 45025 | 284 | 7 |
239349 | 239349 | 2020-06-14 | Chesterfield | South Carolina | 45025 | 291 | 7 |
242458 | 242458 | 2020-06-15 | Chesterfield | South Carolina | 45025 | 292 | 7 |
245570 | 245570 | 2020-06-16 | Chesterfield | South Carolina | 45025 | 293 | 8 |
248683 | 248683 | 2020-06-17 | Chesterfield | South Carolina | 45025 | 295 | 8 |
251798 | 251798 | 2020-06-18 | Chesterfield | South Carolina | 45025 | 300 | 8 |
254913 | 254913 | 2020-06-19 | Chesterfield | South Carolina | 45025 | 306 | 9 |
258039 | 258039 | 2020-06-20 | Chesterfield | South Carolina | 45025 | 309 | 9 |
261166 | 261166 | 2020-06-21 | Chesterfield | South Carolina | 45025 | 311 | 10 |
264294 | 264294 | 2020-06-22 | Chesterfield | South Carolina | 45025 | 322 | 10 |
267422 | 267422 | 2020-06-23 | Chesterfield | South Carolina | 45025 | 328 | 12 |
270556 | 270556 | 2020-06-24 | Chesterfield | South Carolina | 45025 | 335 | 12 |
273695 | 273695 | 2020-06-25 | Chesterfield | South Carolina | 45025 | 338 | 13 |
276842 | 276842 | 2020-06-26 | Chesterfield | South Carolina | 45025 | 344 | 13 |
279990 | 279990 | 2020-06-27 | Chesterfield | South Carolina | 45025 | 354 | 13 |
283136 | 283136 | 2020-06-28 | Chesterfield | South Carolina | 45025 | 359 | 13 |
286281 | 286281 | 2020-06-29 | Chesterfield | South Carolina | 45025 | 363 | 14 |
289432 | 289432 | 2020-06-30 | Chesterfield | South Carolina | 45025 | 366 | 14 |
292584 | 292584 | 2020-07-01 | Chesterfield | South Carolina | 45025 | 373 | 14 |
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);