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