ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 45091 sorted by county descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3652 | 3652 | 2020-03-17 | York | South Carolina | 45091 | 1 | 0 |
4272 | 4272 | 2020-03-18 | York | South Carolina | 45091 | 1 | 0 |
5017 | 5017 | 2020-03-19 | York | South Carolina | 45091 | 1 | 0 |
5898 | 5898 | 2020-03-20 | York | South Carolina | 45091 | 1 | 0 |
6908 | 6908 | 2020-03-21 | York | South Carolina | 45091 | 2 | 0 |
8029 | 8029 | 2020-03-22 | York | South Carolina | 45091 | 4 | 0 |
9243 | 9243 | 2020-03-23 | York | South Carolina | 45091 | 7 | 0 |
10569 | 10569 | 2020-03-24 | York | South Carolina | 45091 | 11 | 0 |
12043 | 12043 | 2020-03-25 | York | South Carolina | 45091 | 18 | 0 |
13665 | 13665 | 2020-03-26 | York | South Carolina | 45091 | 19 | 0 |
15412 | 15412 | 2020-03-27 | York | South Carolina | 45091 | 19 | 0 |
17267 | 17267 | 2020-03-28 | York | South Carolina | 45091 | 31 | 0 |
19207 | 19207 | 2020-03-29 | York | South Carolina | 45091 | 36 | 0 |
21259 | 21259 | 2020-03-30 | York | South Carolina | 45091 | 43 | 0 |
23397 | 23397 | 2020-03-31 | York | South Carolina | 45091 | 56 | 1 |
25595 | 25595 | 2020-04-01 | York | South Carolina | 45091 | 66 | 1 |
27871 | 27871 | 2020-04-02 | York | South Carolina | 45091 | 66 | 1 |
30206 | 30206 | 2020-04-03 | York | South Carolina | 45091 | 73 | 1 |
32597 | 32597 | 2020-04-04 | York | South Carolina | 45091 | 81 | 2 |
35033 | 35033 | 2020-04-05 | York | South Carolina | 45091 | 85 | 2 |
37508 | 37508 | 2020-04-06 | York | South Carolina | 45091 | 95 | 2 |
40031 | 40031 | 2020-04-07 | York | South Carolina | 45091 | 108 | 2 |
42591 | 42591 | 2020-04-08 | York | South Carolina | 45091 | 115 | 2 |
45177 | 45177 | 2020-04-09 | York | South Carolina | 45091 | 120 | 2 |
47794 | 47794 | 2020-04-10 | York | South Carolina | 45091 | 125 | 2 |
50451 | 50451 | 2020-04-11 | York | South Carolina | 45091 | 127 | 3 |
53124 | 53124 | 2020-04-12 | York | South Carolina | 45091 | 134 | 3 |
55809 | 55809 | 2020-04-13 | York | South Carolina | 45091 | 136 | 3 |
58512 | 58512 | 2020-04-14 | York | South Carolina | 45091 | 138 | 3 |
61227 | 61227 | 2020-04-15 | York | South Carolina | 45091 | 138 | 3 |
63953 | 63953 | 2020-04-16 | York | South Carolina | 45091 | 149 | 3 |
66699 | 66699 | 2020-04-17 | York | South Carolina | 45091 | 151 | 3 |
69457 | 69457 | 2020-04-18 | York | South Carolina | 45091 | 156 | 3 |
72224 | 72224 | 2020-04-19 | York | South Carolina | 45091 | 156 | 3 |
74999 | 74999 | 2020-04-20 | York | South Carolina | 45091 | 159 | 3 |
77781 | 77781 | 2020-04-21 | York | South Carolina | 45091 | 162 | 3 |
80571 | 80571 | 2020-04-22 | York | South Carolina | 45091 | 166 | 3 |
83370 | 83370 | 2020-04-23 | York | South Carolina | 45091 | 171 | 3 |
86174 | 86174 | 2020-04-24 | York | South Carolina | 45091 | 172 | 3 |
88988 | 88988 | 2020-04-25 | York | South Carolina | 45091 | 177 | 3 |
91804 | 91804 | 2020-04-26 | York | South Carolina | 45091 | 181 | 3 |
94631 | 94631 | 2020-04-27 | York | South Carolina | 45091 | 186 | 3 |
97470 | 97470 | 2020-04-28 | York | South Carolina | 45091 | 188 | 3 |
100319 | 100319 | 2020-04-29 | York | South Carolina | 45091 | 197 | 3 |
103172 | 103172 | 2020-04-30 | York | South Carolina | 45091 | 210 | 3 |
106035 | 106035 | 2020-05-01 | York | South Carolina | 45091 | 215 | 3 |
108902 | 108902 | 2020-05-02 | York | South Carolina | 45091 | 219 | 3 |
111776 | 111776 | 2020-05-03 | York | South Carolina | 45091 | 221 | 3 |
114658 | 114658 | 2020-05-04 | York | South Carolina | 45091 | 222 | 3 |
117614 | 117614 | 2020-05-05 | York | South Carolina | 45091 | 219 | 4 |
120576 | 120576 | 2020-05-06 | York | South Carolina | 45091 | 222 | 5 |
123554 | 123554 | 2020-05-07 | York | South Carolina | 45091 | 225 | 5 |
126537 | 126537 | 2020-05-08 | York | South Carolina | 45091 | 233 | 5 |
129526 | 129526 | 2020-05-09 | York | South Carolina | 45091 | 237 | 5 |
132515 | 132515 | 2020-05-10 | York | South Carolina | 45091 | 238 | 5 |
135506 | 135506 | 2020-05-11 | York | South Carolina | 45091 | 242 | 5 |
138496 | 138496 | 2020-05-12 | York | South Carolina | 45091 | 258 | 5 |
141492 | 141492 | 2020-05-13 | York | South Carolina | 45091 | 265 | 5 |
144488 | 144488 | 2020-05-14 | York | South Carolina | 45091 | 272 | 5 |
147489 | 147489 | 2020-05-15 | York | South Carolina | 45091 | 280 | 5 |
150497 | 150497 | 2020-05-16 | York | South Carolina | 45091 | 290 | 5 |
153508 | 153508 | 2020-05-17 | York | South Carolina | 45091 | 293 | 5 |
156525 | 156525 | 2020-05-18 | York | South Carolina | 45091 | 304 | 5 |
159546 | 159546 | 2020-05-19 | York | South Carolina | 45091 | 308 | 5 |
162573 | 162573 | 2020-05-20 | York | South Carolina | 45091 | 317 | 5 |
165602 | 165602 | 2020-05-21 | York | South Carolina | 45091 | 324 | 5 |
168638 | 168638 | 2020-05-22 | York | South Carolina | 45091 | 329 | 5 |
171677 | 171677 | 2020-05-23 | York | South Carolina | 45091 | 339 | 6 |
174719 | 174719 | 2020-05-24 | York | South Carolina | 45091 | 340 | 6 |
177763 | 177763 | 2020-05-25 | York | South Carolina | 45091 | 346 | 6 |
180806 | 180806 | 2020-05-26 | York | South Carolina | 45091 | 352 | 6 |
183856 | 183856 | 2020-05-27 | York | South Carolina | 45091 | 363 | 6 |
186913 | 186913 | 2020-05-28 | York | South Carolina | 45091 | 371 | 7 |
189975 | 189975 | 2020-05-29 | York | South Carolina | 45091 | 385 | 7 |
193040 | 193040 | 2020-05-30 | York | South Carolina | 45091 | 398 | 7 |
196109 | 196109 | 2020-05-31 | York | South Carolina | 45091 | 407 | 8 |
199182 | 199182 | 2020-06-01 | York | South Carolina | 45091 | 417 | 8 |
202257 | 202257 | 2020-06-02 | York | South Carolina | 45091 | 421 | 8 |
205334 | 205334 | 2020-06-03 | York | South Carolina | 45091 | 426 | 10 |
208415 | 208415 | 2020-06-04 | York | South Carolina | 45091 | 433 | 10 |
211497 | 211497 | 2020-06-05 | York | South Carolina | 45091 | 446 | 10 |
214583 | 214583 | 2020-06-06 | York | South Carolina | 45091 | 458 | 10 |
217673 | 217673 | 2020-06-07 | York | South Carolina | 45091 | 465 | 10 |
220765 | 220765 | 2020-06-08 | York | South Carolina | 45091 | 486 | 10 |
223860 | 223860 | 2020-06-09 | York | South Carolina | 45091 | 510 | 10 |
226960 | 226960 | 2020-06-10 | York | South Carolina | 45091 | 536 | 10 |
230064 | 230064 | 2020-06-11 | York | South Carolina | 45091 | 557 | 10 |
233169 | 233169 | 2020-06-12 | York | South Carolina | 45091 | 580 | 10 |
236274 | 236274 | 2020-06-13 | York | South Carolina | 45091 | 613 | 10 |
239382 | 239382 | 2020-06-14 | York | South Carolina | 45091 | 636 | 10 |
242491 | 242491 | 2020-06-15 | York | South Carolina | 45091 | 652 | 10 |
245603 | 245603 | 2020-06-16 | York | South Carolina | 45091 | 686 | 10 |
248716 | 248716 | 2020-06-17 | York | South Carolina | 45091 | 700 | 11 |
251831 | 251831 | 2020-06-18 | York | South Carolina | 45091 | 729 | 11 |
254946 | 254946 | 2020-06-19 | York | South Carolina | 45091 | 741 | 11 |
258072 | 258072 | 2020-06-20 | York | South Carolina | 45091 | 783 | 11 |
261199 | 261199 | 2020-06-21 | York | South Carolina | 45091 | 814 | 11 |
264327 | 264327 | 2020-06-22 | York | South Carolina | 45091 | 860 | 11 |
267455 | 267455 | 2020-06-23 | York | South Carolina | 45091 | 886 | 11 |
270589 | 270589 | 2020-06-24 | York | South Carolina | 45091 | 914 | 11 |
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);