ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Charleston" and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
292581 | 292581 | 2020-07-01 | Charleston | South Carolina | 45019 | 4289 | 33 |
289429 | 289429 | 2020-06-30 | Charleston | South Carolina | 45019 | 4027 | 26 |
286278 | 286278 | 2020-06-29 | Charleston | South Carolina | 45019 | 3654 | 23 |
283133 | 283133 | 2020-06-28 | Charleston | South Carolina | 45019 | 3381 | 23 |
279987 | 279987 | 2020-06-27 | Charleston | South Carolina | 45019 | 3142 | 22 |
276839 | 276839 | 2020-06-26 | Charleston | South Carolina | 45019 | 2861 | 22 |
273692 | 273692 | 2020-06-25 | Charleston | South Carolina | 45019 | 2629 | 22 |
270553 | 270553 | 2020-06-24 | Charleston | South Carolina | 45019 | 2417 | 21 |
267419 | 267419 | 2020-06-23 | Charleston | South Carolina | 45019 | 2252 | 20 |
264291 | 264291 | 2020-06-22 | Charleston | South Carolina | 45019 | 2044 | 19 |
261163 | 261163 | 2020-06-21 | Charleston | South Carolina | 45019 | 1836 | 19 |
258036 | 258036 | 2020-06-20 | Charleston | South Carolina | 45019 | 1728 | 19 |
254910 | 254910 | 2020-06-19 | Charleston | South Carolina | 45019 | 1554 | 19 |
251795 | 251795 | 2020-06-18 | Charleston | South Carolina | 45019 | 1403 | 17 |
248680 | 248680 | 2020-06-17 | Charleston | South Carolina | 45019 | 1264 | 17 |
245567 | 245567 | 2020-06-16 | Charleston | South Carolina | 45019 | 1230 | 16 |
242455 | 242455 | 2020-06-15 | Charleston | South Carolina | 45019 | 1165 | 16 |
239346 | 239346 | 2020-06-14 | Charleston | South Carolina | 45019 | 1092 | 15 |
236238 | 236238 | 2020-06-13 | Charleston | South Carolina | 45019 | 1015 | 15 |
233133 | 233133 | 2020-06-12 | Charleston | South Carolina | 45019 | 959 | 15 |
230028 | 230028 | 2020-06-11 | Charleston | South Carolina | 45019 | 910 | 14 |
226924 | 226924 | 2020-06-10 | Charleston | South Carolina | 45019 | 869 | 14 |
223824 | 223824 | 2020-06-09 | Charleston | South Carolina | 45019 | 835 | 14 |
220729 | 220729 | 2020-06-08 | Charleston | South Carolina | 45019 | 811 | 14 |
217637 | 217637 | 2020-06-07 | Charleston | South Carolina | 45019 | 776 | 14 |
214547 | 214547 | 2020-06-06 | Charleston | South Carolina | 45019 | 745 | 14 |
211461 | 211461 | 2020-06-05 | Charleston | South Carolina | 45019 | 709 | 14 |
208379 | 208379 | 2020-06-04 | Charleston | South Carolina | 45019 | 683 | 13 |
205298 | 205298 | 2020-06-03 | Charleston | South Carolina | 45019 | 657 | 13 |
202221 | 202221 | 2020-06-02 | Charleston | South Carolina | 45019 | 646 | 12 |
199146 | 199146 | 2020-06-01 | Charleston | South Carolina | 45019 | 634 | 12 |
196073 | 196073 | 2020-05-31 | Charleston | South Carolina | 45019 | 617 | 12 |
193004 | 193004 | 2020-05-30 | Charleston | South Carolina | 45019 | 609 | 12 |
189939 | 189939 | 2020-05-29 | Charleston | South Carolina | 45019 | 586 | 12 |
186877 | 186877 | 2020-05-28 | Charleston | South Carolina | 45019 | 578 | 12 |
183820 | 183820 | 2020-05-27 | Charleston | South Carolina | 45019 | 576 | 12 |
180770 | 180770 | 2020-05-26 | Charleston | South Carolina | 45019 | 568 | 11 |
177727 | 177727 | 2020-05-25 | Charleston | South Carolina | 45019 | 561 | 11 |
174683 | 174683 | 2020-05-24 | Charleston | South Carolina | 45019 | 558 | 11 |
171641 | 171641 | 2020-05-23 | Charleston | South Carolina | 45019 | 550 | 11 |
168602 | 168602 | 2020-05-22 | Charleston | South Carolina | 45019 | 540 | 11 |
165566 | 165566 | 2020-05-21 | Charleston | South Carolina | 45019 | 523 | 11 |
162537 | 162537 | 2020-05-20 | Charleston | South Carolina | 45019 | 515 | 11 |
159510 | 159510 | 2020-05-19 | Charleston | South Carolina | 45019 | 515 | 11 |
156489 | 156489 | 2020-05-18 | Charleston | South Carolina | 45019 | 509 | 11 |
153472 | 153472 | 2020-05-17 | Charleston | South Carolina | 45019 | 507 | 10 |
150461 | 150461 | 2020-05-16 | Charleston | South Carolina | 45019 | 506 | 10 |
147453 | 147453 | 2020-05-15 | Charleston | South Carolina | 45019 | 501 | 10 |
144452 | 144452 | 2020-05-14 | Charleston | South Carolina | 45019 | 491 | 10 |
141456 | 141456 | 2020-05-13 | Charleston | South Carolina | 45019 | 491 | 10 |
138460 | 138460 | 2020-05-12 | Charleston | South Carolina | 45019 | 497 | 11 |
135470 | 135470 | 2020-05-11 | Charleston | South Carolina | 45019 | 491 | 11 |
132479 | 132479 | 2020-05-10 | Charleston | South Carolina | 45019 | 481 | 10 |
129490 | 129490 | 2020-05-09 | Charleston | South Carolina | 45019 | 482 | 10 |
126501 | 126501 | 2020-05-08 | Charleston | South Carolina | 45019 | 481 | 9 |
123518 | 123518 | 2020-05-07 | Charleston | South Carolina | 45019 | 467 | 9 |
120540 | 120540 | 2020-05-06 | Charleston | South Carolina | 45019 | 464 | 9 |
117578 | 117578 | 2020-05-05 | Charleston | South Carolina | 45019 | 463 | 8 |
114622 | 114622 | 2020-05-04 | Charleston | South Carolina | 45019 | 464 | 7 |
111740 | 111740 | 2020-05-03 | Charleston | South Carolina | 45019 | 457 | 7 |
108866 | 108866 | 2020-05-02 | Charleston | South Carolina | 45019 | 456 | 7 |
105999 | 105999 | 2020-05-01 | Charleston | South Carolina | 45019 | 452 | 7 |
103136 | 103136 | 2020-04-30 | Charleston | South Carolina | 45019 | 444 | 7 |
100283 | 100283 | 2020-04-29 | Charleston | South Carolina | 45019 | 441 | 7 |
97434 | 97434 | 2020-04-28 | Charleston | South Carolina | 45019 | 438 | 7 |
94595 | 94595 | 2020-04-27 | Charleston | South Carolina | 45019 | 435 | 6 |
91768 | 91768 | 2020-04-26 | Charleston | South Carolina | 45019 | 436 | 6 |
88952 | 88952 | 2020-04-25 | Charleston | South Carolina | 45019 | 424 | 6 |
86138 | 86138 | 2020-04-24 | Charleston | South Carolina | 45019 | 416 | 6 |
83334 | 83334 | 2020-04-23 | Charleston | South Carolina | 45019 | 412 | 5 |
80535 | 80535 | 2020-04-22 | Charleston | South Carolina | 45019 | 406 | 5 |
77745 | 77745 | 2020-04-21 | Charleston | South Carolina | 45019 | 403 | 5 |
74963 | 74963 | 2020-04-20 | Charleston | South Carolina | 45019 | 391 | 3 |
72188 | 72188 | 2020-04-19 | Charleston | South Carolina | 45019 | 390 | 3 |
69421 | 69421 | 2020-04-18 | Charleston | South Carolina | 45019 | 385 | 3 |
66663 | 66663 | 2020-04-17 | Charleston | South Carolina | 45019 | 385 | 3 |
63917 | 63917 | 2020-04-16 | Charleston | South Carolina | 45019 | 383 | 3 |
61191 | 61191 | 2020-04-15 | Charleston | South Carolina | 45019 | 360 | 2 |
58476 | 58476 | 2020-04-14 | Charleston | South Carolina | 45019 | 353 | 2 |
55773 | 55773 | 2020-04-13 | Charleston | South Carolina | 45019 | 351 | 2 |
53088 | 53088 | 2020-04-12 | Charleston | South Carolina | 45019 | 339 | 2 |
50415 | 50415 | 2020-04-11 | Charleston | South Carolina | 45019 | 331 | 1 |
47758 | 47758 | 2020-04-10 | Charleston | South Carolina | 45019 | 328 | 1 |
45141 | 45141 | 2020-04-09 | Charleston | South Carolina | 45019 | 313 | 1 |
42555 | 42555 | 2020-04-08 | Charleston | South Carolina | 45019 | 308 | 1 |
39995 | 39995 | 2020-04-07 | Charleston | South Carolina | 45019 | 305 | 1 |
37472 | 37472 | 2020-04-06 | Charleston | South Carolina | 45019 | 300 | 1 |
34997 | 34997 | 2020-04-05 | Charleston | South Carolina | 45019 | 274 | 1 |
32561 | 32561 | 2020-04-04 | Charleston | South Carolina | 45019 | 274 | 1 |
30170 | 30170 | 2020-04-03 | Charleston | South Carolina | 45019 | 247 | 1 |
27835 | 27835 | 2020-04-02 | Charleston | South Carolina | 45019 | 231 | 1 |
25562 | 25562 | 2020-04-01 | Charleston | South Carolina | 45019 | 190 | 1 |
23364 | 23364 | 2020-03-31 | Charleston | South Carolina | 45019 | 142 | 1 |
21226 | 21226 | 2020-03-30 | Charleston | South Carolina | 45019 | 123 | 1 |
19174 | 19174 | 2020-03-29 | Charleston | South Carolina | 45019 | 116 | 1 |
17234 | 17234 | 2020-03-28 | Charleston | South Carolina | 45019 | 108 | 1 |
15380 | 15380 | 2020-03-27 | Charleston | South Carolina | 45019 | 92 | 1 |
13633 | 13633 | 2020-03-26 | Charleston | South Carolina | 45019 | 60 | 1 |
12011 | 12011 | 2020-03-25 | Charleston | South Carolina | 45019 | 52 | 1 |
10540 | 10540 | 2020-03-24 | Charleston | South Carolina | 45019 | 36 | 1 |
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);