ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 45057 and state = "South Carolina" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1317 | 1317 | 2020-03-11 | Lancaster | South Carolina | 45057 | 1 | 0 |
1563 | 1563 | 2020-03-12 | Lancaster | South Carolina | 45057 | 2 | 0 |
1863 | 1863 | 2020-03-13 | Lancaster | South Carolina | 45057 | 2 | 0 |
2226 | 2226 | 2020-03-14 | Lancaster | South Carolina | 45057 | 2 | 0 |
2651 | 2651 | 2020-03-15 | Lancaster | South Carolina | 45057 | 2 | 0 |
3117 | 3117 | 2020-03-16 | Lancaster | South Carolina | 45057 | 2 | 0 |
3648 | 3648 | 2020-03-17 | Lancaster | South Carolina | 45057 | 2 | 0 |
4267 | 4267 | 2020-03-18 | Lancaster | South Carolina | 45057 | 2 | 0 |
5011 | 5011 | 2020-03-19 | Lancaster | South Carolina | 45057 | 3 | 0 |
5889 | 5889 | 2020-03-20 | Lancaster | South Carolina | 45057 | 3 | 0 |
6897 | 6897 | 2020-03-21 | Lancaster | South Carolina | 45057 | 3 | 0 |
8018 | 8018 | 2020-03-22 | Lancaster | South Carolina | 45057 | 5 | 0 |
9231 | 9231 | 2020-03-23 | Lancaster | South Carolina | 45057 | 7 | 0 |
10557 | 10557 | 2020-03-24 | Lancaster | South Carolina | 45057 | 7 | 0 |
12028 | 12028 | 2020-03-25 | Lancaster | South Carolina | 45057 | 7 | 0 |
13650 | 13650 | 2020-03-26 | Lancaster | South Carolina | 45057 | 7 | 0 |
15397 | 15397 | 2020-03-27 | Lancaster | South Carolina | 45057 | 8 | 0 |
17251 | 17251 | 2020-03-28 | Lancaster | South Carolina | 45057 | 9 | 0 |
19191 | 19191 | 2020-03-29 | Lancaster | South Carolina | 45057 | 13 | 0 |
21243 | 21243 | 2020-03-30 | Lancaster | South Carolina | 45057 | 14 | 0 |
23381 | 23381 | 2020-03-31 | Lancaster | South Carolina | 45057 | 15 | 0 |
25579 | 25579 | 2020-04-01 | Lancaster | South Carolina | 45057 | 17 | 0 |
27854 | 27854 | 2020-04-02 | Lancaster | South Carolina | 45057 | 26 | 0 |
30189 | 30189 | 2020-04-03 | Lancaster | South Carolina | 45057 | 31 | 0 |
32580 | 32580 | 2020-04-04 | Lancaster | South Carolina | 45057 | 39 | 0 |
35016 | 35016 | 2020-04-05 | Lancaster | South Carolina | 45057 | 41 | 0 |
37491 | 37491 | 2020-04-06 | Lancaster | South Carolina | 45057 | 43 | 0 |
40014 | 40014 | 2020-04-07 | Lancaster | South Carolina | 45057 | 46 | 0 |
42574 | 42574 | 2020-04-08 | Lancaster | South Carolina | 45057 | 48 | 0 |
45160 | 45160 | 2020-04-09 | Lancaster | South Carolina | 45057 | 51 | 0 |
47777 | 47777 | 2020-04-10 | Lancaster | South Carolina | 45057 | 61 | 0 |
50434 | 50434 | 2020-04-11 | Lancaster | South Carolina | 45057 | 62 | 0 |
53107 | 53107 | 2020-04-12 | Lancaster | South Carolina | 45057 | 65 | 0 |
55792 | 55792 | 2020-04-13 | Lancaster | South Carolina | 45057 | 66 | 0 |
58495 | 58495 | 2020-04-14 | Lancaster | South Carolina | 45057 | 67 | 1 |
61210 | 61210 | 2020-04-15 | Lancaster | South Carolina | 45057 | 68 | 2 |
63936 | 63936 | 2020-04-16 | Lancaster | South Carolina | 45057 | 71 | 2 |
66682 | 66682 | 2020-04-17 | Lancaster | South Carolina | 45057 | 73 | 2 |
69440 | 69440 | 2020-04-18 | Lancaster | South Carolina | 45057 | 73 | 2 |
72207 | 72207 | 2020-04-19 | Lancaster | South Carolina | 45057 | 79 | 2 |
74982 | 74982 | 2020-04-20 | Lancaster | South Carolina | 45057 | 79 | 3 |
77764 | 77764 | 2020-04-21 | Lancaster | South Carolina | 45057 | 79 | 3 |
80554 | 80554 | 2020-04-22 | Lancaster | South Carolina | 45057 | 80 | 3 |
83353 | 83353 | 2020-04-23 | Lancaster | South Carolina | 45057 | 79 | 3 |
86157 | 86157 | 2020-04-24 | Lancaster | South Carolina | 45057 | 80 | 3 |
88971 | 88971 | 2020-04-25 | Lancaster | South Carolina | 45057 | 85 | 3 |
91787 | 91787 | 2020-04-26 | Lancaster | South Carolina | 45057 | 87 | 3 |
94614 | 94614 | 2020-04-27 | Lancaster | South Carolina | 45057 | 88 | 3 |
97453 | 97453 | 2020-04-28 | Lancaster | South Carolina | 45057 | 90 | 4 |
100302 | 100302 | 2020-04-29 | Lancaster | South Carolina | 45057 | 93 | 4 |
103155 | 103155 | 2020-04-30 | Lancaster | South Carolina | 45057 | 96 | 4 |
106018 | 106018 | 2020-05-01 | Lancaster | South Carolina | 45057 | 99 | 4 |
108885 | 108885 | 2020-05-02 | Lancaster | South Carolina | 45057 | 100 | 4 |
111759 | 111759 | 2020-05-03 | Lancaster | South Carolina | 45057 | 101 | 4 |
114641 | 114641 | 2020-05-04 | Lancaster | South Carolina | 45057 | 99 | 4 |
117597 | 117597 | 2020-05-05 | Lancaster | South Carolina | 45057 | 96 | 4 |
120559 | 120559 | 2020-05-06 | Lancaster | South Carolina | 45057 | 99 | 4 |
123537 | 123537 | 2020-05-07 | Lancaster | South Carolina | 45057 | 101 | 4 |
126520 | 126520 | 2020-05-08 | Lancaster | South Carolina | 45057 | 103 | 4 |
129509 | 129509 | 2020-05-09 | Lancaster | South Carolina | 45057 | 104 | 4 |
132498 | 132498 | 2020-05-10 | Lancaster | South Carolina | 45057 | 110 | 4 |
135489 | 135489 | 2020-05-11 | Lancaster | South Carolina | 45057 | 111 | 5 |
138479 | 138479 | 2020-05-12 | Lancaster | South Carolina | 45057 | 115 | 5 |
141475 | 141475 | 2020-05-13 | Lancaster | South Carolina | 45057 | 110 | 5 |
144471 | 144471 | 2020-05-14 | Lancaster | South Carolina | 45057 | 108 | 5 |
147472 | 147472 | 2020-05-15 | Lancaster | South Carolina | 45057 | 110 | 5 |
150480 | 150480 | 2020-05-16 | Lancaster | South Carolina | 45057 | 109 | 5 |
153491 | 153491 | 2020-05-17 | Lancaster | South Carolina | 45057 | 111 | 5 |
156508 | 156508 | 2020-05-18 | Lancaster | South Carolina | 45057 | 111 | 5 |
159529 | 159529 | 2020-05-19 | Lancaster | South Carolina | 45057 | 108 | 5 |
162556 | 162556 | 2020-05-20 | Lancaster | South Carolina | 45057 | 108 | 5 |
165585 | 165585 | 2020-05-21 | Lancaster | South Carolina | 45057 | 116 | 5 |
168621 | 168621 | 2020-05-22 | Lancaster | South Carolina | 45057 | 120 | 5 |
171660 | 171660 | 2020-05-23 | Lancaster | South Carolina | 45057 | 121 | 5 |
174702 | 174702 | 2020-05-24 | Lancaster | South Carolina | 45057 | 121 | 5 |
177746 | 177746 | 2020-05-25 | Lancaster | South Carolina | 45057 | 121 | 5 |
180789 | 180789 | 2020-05-26 | Lancaster | South Carolina | 45057 | 122 | 5 |
183839 | 183839 | 2020-05-27 | Lancaster | South Carolina | 45057 | 124 | 5 |
186896 | 186896 | 2020-05-28 | Lancaster | South Carolina | 45057 | 126 | 5 |
189958 | 189958 | 2020-05-29 | Lancaster | South Carolina | 45057 | 129 | 5 |
193023 | 193023 | 2020-05-30 | Lancaster | South Carolina | 45057 | 130 | 5 |
196092 | 196092 | 2020-05-31 | Lancaster | South Carolina | 45057 | 135 | 5 |
199165 | 199165 | 2020-06-01 | Lancaster | South Carolina | 45057 | 140 | 5 |
202240 | 202240 | 2020-06-02 | Lancaster | South Carolina | 45057 | 166 | 5 |
205317 | 205317 | 2020-06-03 | Lancaster | South Carolina | 45057 | 180 | 6 |
208398 | 208398 | 2020-06-04 | Lancaster | South Carolina | 45057 | 182 | 6 |
211480 | 211480 | 2020-06-05 | Lancaster | South Carolina | 45057 | 189 | 6 |
214566 | 214566 | 2020-06-06 | Lancaster | South Carolina | 45057 | 199 | 6 |
217656 | 217656 | 2020-06-07 | Lancaster | South Carolina | 45057 | 201 | 6 |
220748 | 220748 | 2020-06-08 | Lancaster | South Carolina | 45057 | 203 | 6 |
223843 | 223843 | 2020-06-09 | Lancaster | South Carolina | 45057 | 214 | 6 |
226943 | 226943 | 2020-06-10 | Lancaster | South Carolina | 45057 | 220 | 6 |
230047 | 230047 | 2020-06-11 | Lancaster | South Carolina | 45057 | 232 | 6 |
233152 | 233152 | 2020-06-12 | Lancaster | South Carolina | 45057 | 230 | 6 |
236257 | 236257 | 2020-06-13 | Lancaster | South Carolina | 45057 | 239 | 6 |
239365 | 239365 | 2020-06-14 | Lancaster | South Carolina | 45057 | 246 | 6 |
242474 | 242474 | 2020-06-15 | Lancaster | South Carolina | 45057 | 248 | 6 |
245586 | 245586 | 2020-06-16 | Lancaster | South Carolina | 45057 | 259 | 6 |
248699 | 248699 | 2020-06-17 | Lancaster | South Carolina | 45057 | 270 | 7 |
251814 | 251814 | 2020-06-18 | Lancaster | South Carolina | 45057 | 277 | 9 |
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);