ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "York" 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 |
---|---|---|---|---|---|---|---|
80571 | 80571 | 2020-04-22 | York | South Carolina | 45091 | 166 | 3 |
77781 | 77781 | 2020-04-21 | York | South Carolina | 45091 | 162 | 3 |
74999 | 74999 | 2020-04-20 | York | South Carolina | 45091 | 159 | 3 |
72224 | 72224 | 2020-04-19 | York | South Carolina | 45091 | 156 | 3 |
69457 | 69457 | 2020-04-18 | York | South Carolina | 45091 | 156 | 3 |
66699 | 66699 | 2020-04-17 | York | South Carolina | 45091 | 151 | 3 |
63953 | 63953 | 2020-04-16 | York | South Carolina | 45091 | 149 | 3 |
61227 | 61227 | 2020-04-15 | York | South Carolina | 45091 | 138 | 3 |
58512 | 58512 | 2020-04-14 | York | South Carolina | 45091 | 138 | 3 |
55809 | 55809 | 2020-04-13 | York | South Carolina | 45091 | 136 | 3 |
53124 | 53124 | 2020-04-12 | York | South Carolina | 45091 | 134 | 3 |
50451 | 50451 | 2020-04-11 | York | South Carolina | 45091 | 127 | 3 |
47794 | 47794 | 2020-04-10 | York | South Carolina | 45091 | 125 | 2 |
45177 | 45177 | 2020-04-09 | York | South Carolina | 45091 | 120 | 2 |
42591 | 42591 | 2020-04-08 | York | South Carolina | 45091 | 115 | 2 |
40031 | 40031 | 2020-04-07 | York | South Carolina | 45091 | 108 | 2 |
37508 | 37508 | 2020-04-06 | York | South Carolina | 45091 | 95 | 2 |
35033 | 35033 | 2020-04-05 | York | South Carolina | 45091 | 85 | 2 |
32597 | 32597 | 2020-04-04 | York | South Carolina | 45091 | 81 | 2 |
30206 | 30206 | 2020-04-03 | York | South Carolina | 45091 | 73 | 1 |
27871 | 27871 | 2020-04-02 | York | South Carolina | 45091 | 66 | 1 |
25595 | 25595 | 2020-04-01 | York | South Carolina | 45091 | 66 | 1 |
23397 | 23397 | 2020-03-31 | York | South Carolina | 45091 | 56 | 1 |
21259 | 21259 | 2020-03-30 | York | South Carolina | 45091 | 43 | 0 |
19207 | 19207 | 2020-03-29 | York | South Carolina | 45091 | 36 | 0 |
17267 | 17267 | 2020-03-28 | York | South Carolina | 45091 | 31 | 0 |
15412 | 15412 | 2020-03-27 | York | South Carolina | 45091 | 19 | 0 |
13665 | 13665 | 2020-03-26 | York | South Carolina | 45091 | 19 | 0 |
12043 | 12043 | 2020-03-25 | York | South Carolina | 45091 | 18 | 0 |
10569 | 10569 | 2020-03-24 | York | South Carolina | 45091 | 11 | 0 |
9243 | 9243 | 2020-03-23 | York | South Carolina | 45091 | 7 | 0 |
8029 | 8029 | 2020-03-22 | York | South Carolina | 45091 | 4 | 0 |
6908 | 6908 | 2020-03-21 | York | South Carolina | 45091 | 2 | 0 |
5898 | 5898 | 2020-03-20 | York | South Carolina | 45091 | 1 | 0 |
5017 | 5017 | 2020-03-19 | York | South Carolina | 45091 | 1 | 0 |
4272 | 4272 | 2020-03-18 | York | South Carolina | 45091 | 1 | 0 |
3652 | 3652 | 2020-03-17 | York | South Carolina | 45091 | 1 | 0 |
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);