ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Lexington" 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 |
---|---|---|---|---|---|---|---|
2227 | 2227 | 2020-03-14 | Lexington | South Carolina | 45063 | 1 | 0 |
2652 | 2652 | 2020-03-15 | Lexington | South Carolina | 45063 | 1 | 0 |
3118 | 3118 | 2020-03-16 | Lexington | South Carolina | 45063 | 2 | 1 |
3649 | 3649 | 2020-03-17 | Lexington | South Carolina | 45063 | 3 | 1 |
4269 | 4269 | 2020-03-18 | Lexington | South Carolina | 45063 | 4 | 1 |
5013 | 5013 | 2020-03-19 | Lexington | South Carolina | 45063 | 5 | 1 |
5891 | 5891 | 2020-03-20 | Lexington | South Carolina | 45063 | 8 | 1 |
6899 | 6899 | 2020-03-21 | Lexington | South Carolina | 45063 | 12 | 1 |
8020 | 8020 | 2020-03-22 | Lexington | South Carolina | 45063 | 12 | 1 |
9233 | 9233 | 2020-03-23 | Lexington | South Carolina | 45063 | 17 | 1 |
10559 | 10559 | 2020-03-24 | Lexington | South Carolina | 45063 | 19 | 1 |
12030 | 12030 | 2020-03-25 | Lexington | South Carolina | 45063 | 18 | 1 |
13652 | 13652 | 2020-03-26 | Lexington | South Carolina | 45063 | 20 | 1 |
15399 | 15399 | 2020-03-27 | Lexington | South Carolina | 45063 | 25 | 1 |
17254 | 17254 | 2020-03-28 | Lexington | South Carolina | 45063 | 30 | 1 |
19194 | 19194 | 2020-03-29 | Lexington | South Carolina | 45063 | 35 | 1 |
21246 | 21246 | 2020-03-30 | Lexington | South Carolina | 45063 | 41 | 1 |
23384 | 23384 | 2020-03-31 | Lexington | South Carolina | 45063 | 54 | 1 |
25582 | 25582 | 2020-04-01 | Lexington | South Carolina | 45063 | 61 | 1 |
27857 | 27857 | 2020-04-02 | Lexington | South Carolina | 45063 | 70 | 1 |
30192 | 30192 | 2020-04-03 | Lexington | South Carolina | 45063 | 78 | 1 |
32583 | 32583 | 2020-04-04 | Lexington | South Carolina | 45063 | 95 | 3 |
35019 | 35019 | 2020-04-05 | Lexington | South Carolina | 45063 | 117 | 3 |
37494 | 37494 | 2020-04-06 | Lexington | South Carolina | 45063 | 124 | 3 |
40017 | 40017 | 2020-04-07 | Lexington | South Carolina | 45063 | 130 | 5 |
42577 | 42577 | 2020-04-08 | Lexington | South Carolina | 45063 | 128 | 5 |
45163 | 45163 | 2020-04-09 | Lexington | South Carolina | 45063 | 161 | 6 |
47780 | 47780 | 2020-04-10 | Lexington | South Carolina | 45063 | 184 | 6 |
50437 | 50437 | 2020-04-11 | Lexington | South Carolina | 45063 | 202 | 6 |
53110 | 53110 | 2020-04-12 | Lexington | South Carolina | 45063 | 212 | 6 |
55795 | 55795 | 2020-04-13 | Lexington | South Carolina | 45063 | 206 | 6 |
58498 | 58498 | 2020-04-14 | Lexington | South Carolina | 45063 | 208 | 8 |
61213 | 61213 | 2020-04-15 | Lexington | South Carolina | 45063 | 218 | 8 |
63939 | 63939 | 2020-04-16 | Lexington | South Carolina | 45063 | 267 | 8 |
66685 | 66685 | 2020-04-17 | Lexington | South Carolina | 45063 | 254 | 9 |
69443 | 69443 | 2020-04-18 | Lexington | South Carolina | 45063 | 271 | 9 |
72210 | 72210 | 2020-04-19 | Lexington | South Carolina | 45063 | 273 | 9 |
74985 | 74985 | 2020-04-20 | Lexington | South Carolina | 45063 | 274 | 9 |
77767 | 77767 | 2020-04-21 | Lexington | South Carolina | 45063 | 283 | 9 |
80557 | 80557 | 2020-04-22 | Lexington | South Carolina | 45063 | 286 | 9 |
83356 | 83356 | 2020-04-23 | Lexington | South Carolina | 45063 | 294 | 11 |
86160 | 86160 | 2020-04-24 | Lexington | South Carolina | 45063 | 302 | 12 |
88974 | 88974 | 2020-04-25 | Lexington | South Carolina | 45063 | 317 | 12 |
91790 | 91790 | 2020-04-26 | Lexington | South Carolina | 45063 | 329 | 12 |
94617 | 94617 | 2020-04-27 | Lexington | South Carolina | 45063 | 334 | 12 |
97456 | 97456 | 2020-04-28 | Lexington | South Carolina | 45063 | 347 | 12 |
100305 | 100305 | 2020-04-29 | Lexington | South Carolina | 45063 | 358 | 14 |
103158 | 103158 | 2020-04-30 | Lexington | South Carolina | 45063 | 361 | 15 |
106021 | 106021 | 2020-05-01 | Lexington | South Carolina | 45063 | 370 | 15 |
108888 | 108888 | 2020-05-02 | Lexington | South Carolina | 45063 | 414 | 16 |
111762 | 111762 | 2020-05-03 | Lexington | South Carolina | 45063 | 420 | 17 |
114644 | 114644 | 2020-05-04 | Lexington | South Carolina | 45063 | 432 | 17 |
117600 | 117600 | 2020-05-05 | Lexington | South Carolina | 45063 | 440 | 17 |
120562 | 120562 | 2020-05-06 | Lexington | South Carolina | 45063 | 442 | 18 |
123540 | 123540 | 2020-05-07 | Lexington | South Carolina | 45063 | 458 | 19 |
126523 | 126523 | 2020-05-08 | Lexington | South Carolina | 45063 | 465 | 19 |
129512 | 129512 | 2020-05-09 | Lexington | South Carolina | 45063 | 472 | 21 |
132501 | 132501 | 2020-05-10 | Lexington | South Carolina | 45063 | 478 | 21 |
135492 | 135492 | 2020-05-11 | Lexington | South Carolina | 45063 | 484 | 24 |
138482 | 138482 | 2020-05-12 | Lexington | South Carolina | 45063 | 482 | 24 |
141478 | 141478 | 2020-05-13 | Lexington | South Carolina | 45063 | 492 | 25 |
144474 | 144474 | 2020-05-14 | Lexington | South Carolina | 45063 | 503 | 26 |
147475 | 147475 | 2020-05-15 | Lexington | South Carolina | 45063 | 512 | 26 |
150483 | 150483 | 2020-05-16 | Lexington | South Carolina | 45063 | 509 | 26 |
153494 | 153494 | 2020-05-17 | Lexington | South Carolina | 45063 | 516 | 26 |
156511 | 156511 | 2020-05-18 | Lexington | South Carolina | 45063 | 518 | 27 |
159532 | 159532 | 2020-05-19 | Lexington | South Carolina | 45063 | 516 | 28 |
162559 | 162559 | 2020-05-20 | Lexington | South Carolina | 45063 | 519 | 29 |
165588 | 165588 | 2020-05-21 | Lexington | South Carolina | 45063 | 525 | 29 |
168624 | 168624 | 2020-05-22 | Lexington | South Carolina | 45063 | 537 | 29 |
171663 | 171663 | 2020-05-23 | Lexington | South Carolina | 45063 | 548 | 29 |
174705 | 174705 | 2020-05-24 | Lexington | South Carolina | 45063 | 553 | 31 |
177749 | 177749 | 2020-05-25 | Lexington | South Carolina | 45063 | 558 | 32 |
180792 | 180792 | 2020-05-26 | Lexington | South Carolina | 45063 | 572 | 33 |
183842 | 183842 | 2020-05-27 | Lexington | South Carolina | 45063 | 581 | 33 |
186899 | 186899 | 2020-05-28 | Lexington | South Carolina | 45063 | 589 | 33 |
189961 | 189961 | 2020-05-29 | Lexington | South Carolina | 45063 | 597 | 33 |
193026 | 193026 | 2020-05-30 | Lexington | South Carolina | 45063 | 625 | 33 |
196095 | 196095 | 2020-05-31 | Lexington | South Carolina | 45063 | 645 | 33 |
199168 | 199168 | 2020-06-01 | Lexington | South Carolina | 45063 | 657 | 34 |
202243 | 202243 | 2020-06-02 | Lexington | South Carolina | 45063 | 677 | 34 |
205320 | 205320 | 2020-06-03 | Lexington | South Carolina | 45063 | 697 | 34 |
208401 | 208401 | 2020-06-04 | Lexington | South Carolina | 45063 | 723 | 36 |
211483 | 211483 | 2020-06-05 | Lexington | South Carolina | 45063 | 766 | 36 |
214569 | 214569 | 2020-06-06 | Lexington | South Carolina | 45063 | 807 | 37 |
217659 | 217659 | 2020-06-07 | Lexington | South Carolina | 45063 | 836 | 37 |
220751 | 220751 | 2020-06-08 | Lexington | South Carolina | 45063 | 879 | 37 |
223846 | 223846 | 2020-06-09 | Lexington | South Carolina | 45063 | 913 | 37 |
226946 | 226946 | 2020-06-10 | Lexington | South Carolina | 45063 | 941 | 37 |
230050 | 230050 | 2020-06-11 | Lexington | South Carolina | 45063 | 992 | 38 |
233155 | 233155 | 2020-06-12 | Lexington | South Carolina | 45063 | 1049 | 39 |
236260 | 236260 | 2020-06-13 | Lexington | South Carolina | 45063 | 1098 | 39 |
239368 | 239368 | 2020-06-14 | Lexington | South Carolina | 45063 | 1155 | 39 |
242477 | 242477 | 2020-06-15 | Lexington | South Carolina | 45063 | 1185 | 40 |
245589 | 245589 | 2020-06-16 | Lexington | South Carolina | 45063 | 1217 | 40 |
248702 | 248702 | 2020-06-17 | Lexington | South Carolina | 45063 | 1255 | 42 |
251817 | 251817 | 2020-06-18 | Lexington | South Carolina | 45063 | 1300 | 42 |
254932 | 254932 | 2020-06-19 | Lexington | South Carolina | 45063 | 1381 | 42 |
258058 | 258058 | 2020-06-20 | Lexington | South Carolina | 45063 | 1456 | 42 |
261185 | 261185 | 2020-06-21 | Lexington | South Carolina | 45063 | 1496 | 42 |
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);