ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 45055 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 |
---|---|---|---|---|---|---|---|
639 | 639 | 2020-03-06 | Kershaw | South Carolina | 45055 | 1 | 0 |
731 | 731 | 2020-03-07 | Kershaw | South Carolina | 45055 | 1 | 0 |
840 | 840 | 2020-03-08 | Kershaw | South Carolina | 45055 | 4 | 0 |
969 | 969 | 2020-03-09 | Kershaw | South Carolina | 45055 | 5 | 0 |
1122 | 1122 | 2020-03-10 | Kershaw | South Carolina | 45055 | 7 | 0 |
1316 | 1316 | 2020-03-11 | Kershaw | South Carolina | 45055 | 7 | 0 |
1562 | 1562 | 2020-03-12 | Kershaw | South Carolina | 45055 | 8 | 0 |
1862 | 1862 | 2020-03-13 | Kershaw | South Carolina | 45055 | 9 | 0 |
2225 | 2225 | 2020-03-14 | Kershaw | South Carolina | 45055 | 11 | 0 |
2650 | 2650 | 2020-03-15 | Kershaw | South Carolina | 45055 | 14 | 0 |
3116 | 3116 | 2020-03-16 | Kershaw | South Carolina | 45055 | 17 | 0 |
3647 | 3647 | 2020-03-17 | Kershaw | South Carolina | 45055 | 22 | 0 |
4266 | 4266 | 2020-03-18 | Kershaw | South Carolina | 45055 | 25 | 0 |
5010 | 5010 | 2020-03-19 | Kershaw | South Carolina | 45055 | 29 | 0 |
5888 | 5888 | 2020-03-20 | Kershaw | South Carolina | 45055 | 36 | 0 |
6896 | 6896 | 2020-03-21 | Kershaw | South Carolina | 45055 | 42 | 0 |
8017 | 8017 | 2020-03-22 | Kershaw | South Carolina | 45055 | 44 | 0 |
9230 | 9230 | 2020-03-23 | Kershaw | South Carolina | 45055 | 54 | 1 |
10556 | 10556 | 2020-03-24 | Kershaw | South Carolina | 45055 | 58 | 1 |
12027 | 12027 | 2020-03-25 | Kershaw | South Carolina | 45055 | 63 | 1 |
13649 | 13649 | 2020-03-26 | Kershaw | South Carolina | 45055 | 64 | 1 |
15396 | 15396 | 2020-03-27 | Kershaw | South Carolina | 45055 | 70 | 2 |
17250 | 17250 | 2020-03-28 | Kershaw | South Carolina | 45055 | 77 | 2 |
19190 | 19190 | 2020-03-29 | Kershaw | South Carolina | 45055 | 83 | 2 |
21242 | 21242 | 2020-03-30 | Kershaw | South Carolina | 45055 | 99 | 2 |
23380 | 23380 | 2020-03-31 | Kershaw | South Carolina | 45055 | 105 | 2 |
25578 | 25578 | 2020-04-01 | Kershaw | South Carolina | 45055 | 116 | 2 |
27853 | 27853 | 2020-04-02 | Kershaw | South Carolina | 45055 | 129 | 2 |
30188 | 30188 | 2020-04-03 | Kershaw | South Carolina | 45055 | 136 | 2 |
32579 | 32579 | 2020-04-04 | Kershaw | South Carolina | 45055 | 141 | 2 |
35015 | 35015 | 2020-04-05 | Kershaw | South Carolina | 45055 | 148 | 2 |
37490 | 37490 | 2020-04-06 | Kershaw | South Carolina | 45055 | 152 | 2 |
40013 | 40013 | 2020-04-07 | Kershaw | South Carolina | 45055 | 159 | 2 |
42573 | 42573 | 2020-04-08 | Kershaw | South Carolina | 45055 | 165 | 3 |
45159 | 45159 | 2020-04-09 | Kershaw | South Carolina | 45055 | 170 | 3 |
47776 | 47776 | 2020-04-10 | Kershaw | South Carolina | 45055 | 177 | 3 |
50433 | 50433 | 2020-04-11 | Kershaw | South Carolina | 45055 | 178 | 4 |
53106 | 53106 | 2020-04-12 | Kershaw | South Carolina | 45055 | 179 | 4 |
55791 | 55791 | 2020-04-13 | Kershaw | South Carolina | 45055 | 181 | 5 |
58494 | 58494 | 2020-04-14 | Kershaw | South Carolina | 45055 | 187 | 5 |
61209 | 61209 | 2020-04-15 | Kershaw | South Carolina | 45055 | 187 | 7 |
63935 | 63935 | 2020-04-16 | Kershaw | South Carolina | 45055 | 189 | 8 |
66681 | 66681 | 2020-04-17 | Kershaw | South Carolina | 45055 | 190 | 8 |
69439 | 69439 | 2020-04-18 | Kershaw | South Carolina | 45055 | 195 | 8 |
72206 | 72206 | 2020-04-19 | Kershaw | South Carolina | 45055 | 197 | 8 |
74981 | 74981 | 2020-04-20 | Kershaw | South Carolina | 45055 | 201 | 9 |
77763 | 77763 | 2020-04-21 | Kershaw | South Carolina | 45055 | 203 | 9 |
80553 | 80553 | 2020-04-22 | Kershaw | South Carolina | 45055 | 205 | 9 |
83352 | 83352 | 2020-04-23 | Kershaw | South Carolina | 45055 | 208 | 9 |
86156 | 86156 | 2020-04-24 | Kershaw | South Carolina | 45055 | 211 | 10 |
88970 | 88970 | 2020-04-25 | Kershaw | South Carolina | 45055 | 215 | 10 |
91786 | 91786 | 2020-04-26 | Kershaw | South Carolina | 45055 | 218 | 10 |
94613 | 94613 | 2020-04-27 | Kershaw | South Carolina | 45055 | 223 | 10 |
97452 | 97452 | 2020-04-28 | Kershaw | South Carolina | 45055 | 229 | 10 |
100301 | 100301 | 2020-04-29 | Kershaw | South Carolina | 45055 | 234 | 10 |
103154 | 103154 | 2020-04-30 | Kershaw | South Carolina | 45055 | 237 | 10 |
106017 | 106017 | 2020-05-01 | Kershaw | South Carolina | 45055 | 237 | 10 |
108884 | 108884 | 2020-05-02 | Kershaw | South Carolina | 45055 | 243 | 10 |
111758 | 111758 | 2020-05-03 | Kershaw | South Carolina | 45055 | 245 | 10 |
114640 | 114640 | 2020-05-04 | Kershaw | South Carolina | 45055 | 245 | 10 |
117596 | 117596 | 2020-05-05 | Kershaw | South Carolina | 45055 | 247 | 10 |
120558 | 120558 | 2020-05-06 | Kershaw | South Carolina | 45055 | 245 | 10 |
123536 | 123536 | 2020-05-07 | Kershaw | South Carolina | 45055 | 250 | 12 |
126519 | 126519 | 2020-05-08 | Kershaw | South Carolina | 45055 | 250 | 12 |
129508 | 129508 | 2020-05-09 | Kershaw | South Carolina | 45055 | 253 | 12 |
132497 | 132497 | 2020-05-10 | Kershaw | South Carolina | 45055 | 253 | 12 |
135488 | 135488 | 2020-05-11 | Kershaw | South Carolina | 45055 | 257 | 12 |
138478 | 138478 | 2020-05-12 | Kershaw | South Carolina | 45055 | 259 | 12 |
141474 | 141474 | 2020-05-13 | Kershaw | South Carolina | 45055 | 257 | 12 |
144470 | 144470 | 2020-05-14 | Kershaw | South Carolina | 45055 | 257 | 12 |
147471 | 147471 | 2020-05-15 | Kershaw | South Carolina | 45055 | 261 | 12 |
150479 | 150479 | 2020-05-16 | Kershaw | South Carolina | 45055 | 265 | 12 |
153490 | 153490 | 2020-05-17 | Kershaw | South Carolina | 45055 | 265 | 12 |
156507 | 156507 | 2020-05-18 | Kershaw | South Carolina | 45055 | 270 | 12 |
159528 | 159528 | 2020-05-19 | Kershaw | South Carolina | 45055 | 272 | 12 |
162555 | 162555 | 2020-05-20 | Kershaw | South Carolina | 45055 | 275 | 12 |
165584 | 165584 | 2020-05-21 | Kershaw | South Carolina | 45055 | 281 | 13 |
168620 | 168620 | 2020-05-22 | Kershaw | South Carolina | 45055 | 289 | 13 |
171659 | 171659 | 2020-05-23 | Kershaw | South Carolina | 45055 | 299 | 13 |
174701 | 174701 | 2020-05-24 | Kershaw | South Carolina | 45055 | 300 | 14 |
177745 | 177745 | 2020-05-25 | Kershaw | South Carolina | 45055 | 300 | 14 |
180788 | 180788 | 2020-05-26 | Kershaw | South Carolina | 45055 | 305 | 14 |
183838 | 183838 | 2020-05-27 | Kershaw | South Carolina | 45055 | 312 | 14 |
186895 | 186895 | 2020-05-28 | Kershaw | South Carolina | 45055 | 317 | 14 |
189957 | 189957 | 2020-05-29 | Kershaw | South Carolina | 45055 | 324 | 14 |
193022 | 193022 | 2020-05-30 | Kershaw | South Carolina | 45055 | 329 | 14 |
196091 | 196091 | 2020-05-31 | Kershaw | South Carolina | 45055 | 332 | 14 |
199164 | 199164 | 2020-06-01 | Kershaw | South Carolina | 45055 | 338 | 14 |
202239 | 202239 | 2020-06-02 | Kershaw | South Carolina | 45055 | 339 | 14 |
205316 | 205316 | 2020-06-03 | Kershaw | South Carolina | 45055 | 347 | 14 |
208397 | 208397 | 2020-06-04 | Kershaw | South Carolina | 45055 | 351 | 14 |
211479 | 211479 | 2020-06-05 | Kershaw | South Carolina | 45055 | 368 | 14 |
214565 | 214565 | 2020-06-06 | Kershaw | South Carolina | 45055 | 373 | 14 |
217655 | 217655 | 2020-06-07 | Kershaw | South Carolina | 45055 | 379 | 14 |
220747 | 220747 | 2020-06-08 | Kershaw | South Carolina | 45055 | 384 | 15 |
223842 | 223842 | 2020-06-09 | Kershaw | South Carolina | 45055 | 391 | 15 |
226942 | 226942 | 2020-06-10 | Kershaw | South Carolina | 45055 | 397 | 15 |
230046 | 230046 | 2020-06-11 | Kershaw | South Carolina | 45055 | 404 | 15 |
233151 | 233151 | 2020-06-12 | Kershaw | South Carolina | 45055 | 419 | 15 |
236256 | 236256 | 2020-06-13 | Kershaw | South Carolina | 45055 | 430 | 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);