ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 45003 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5875 | 5875 | 2020-03-20 | Aiken | South Carolina | 45003 | 1 | 0 |
6879 | 6879 | 2020-03-21 | Aiken | South Carolina | 45003 | 1 | 0 |
7999 | 7999 | 2020-03-22 | Aiken | South Carolina | 45003 | 1 | 0 |
9210 | 9210 | 2020-03-23 | Aiken | South Carolina | 45003 | 1 | 0 |
10535 | 10535 | 2020-03-24 | Aiken | South Carolina | 45003 | 2 | 0 |
12006 | 12006 | 2020-03-25 | Aiken | South Carolina | 45003 | 2 | 0 |
13628 | 13628 | 2020-03-26 | Aiken | South Carolina | 45003 | 4 | 0 |
15375 | 15375 | 2020-03-27 | Aiken | South Carolina | 45003 | 6 | 0 |
17229 | 17229 | 2020-03-28 | Aiken | South Carolina | 45003 | 7 | 0 |
19169 | 19169 | 2020-03-29 | Aiken | South Carolina | 45003 | 9 | 0 |
21220 | 21220 | 2020-03-30 | Aiken | South Carolina | 45003 | 9 | 0 |
23357 | 23357 | 2020-03-31 | Aiken | South Carolina | 45003 | 13 | 1 |
25554 | 25554 | 2020-04-01 | Aiken | South Carolina | 45003 | 18 | 1 |
27827 | 27827 | 2020-04-02 | Aiken | South Carolina | 45003 | 22 | 1 |
30162 | 30162 | 2020-04-03 | Aiken | South Carolina | 45003 | 22 | 1 |
32553 | 32553 | 2020-04-04 | Aiken | South Carolina | 45003 | 24 | 1 |
34989 | 34989 | 2020-04-05 | Aiken | South Carolina | 45003 | 27 | 1 |
37464 | 37464 | 2020-04-06 | Aiken | South Carolina | 45003 | 27 | 1 |
39987 | 39987 | 2020-04-07 | Aiken | South Carolina | 45003 | 28 | 1 |
42547 | 42547 | 2020-04-08 | Aiken | South Carolina | 45003 | 32 | 1 |
45133 | 45133 | 2020-04-09 | Aiken | South Carolina | 45003 | 42 | 1 |
47750 | 47750 | 2020-04-10 | Aiken | South Carolina | 45003 | 48 | 1 |
50407 | 50407 | 2020-04-11 | Aiken | South Carolina | 45003 | 50 | 1 |
53080 | 53080 | 2020-04-12 | Aiken | South Carolina | 45003 | 50 | 1 |
55765 | 55765 | 2020-04-13 | Aiken | South Carolina | 45003 | 51 | 2 |
58468 | 58468 | 2020-04-14 | Aiken | South Carolina | 45003 | 60 | 3 |
61183 | 61183 | 2020-04-15 | Aiken | South Carolina | 45003 | 60 | 3 |
63909 | 63909 | 2020-04-16 | Aiken | South Carolina | 45003 | 63 | 3 |
66655 | 66655 | 2020-04-17 | Aiken | South Carolina | 45003 | 66 | 3 |
69413 | 69413 | 2020-04-18 | Aiken | South Carolina | 45003 | 67 | 4 |
72180 | 72180 | 2020-04-19 | Aiken | South Carolina | 45003 | 69 | 4 |
74955 | 74955 | 2020-04-20 | Aiken | South Carolina | 45003 | 70 | 4 |
77737 | 77737 | 2020-04-21 | Aiken | South Carolina | 45003 | 70 | 4 |
80527 | 80527 | 2020-04-22 | Aiken | South Carolina | 45003 | 82 | 4 |
83326 | 83326 | 2020-04-23 | Aiken | South Carolina | 45003 | 84 | 5 |
86130 | 86130 | 2020-04-24 | Aiken | South Carolina | 45003 | 86 | 6 |
88944 | 88944 | 2020-04-25 | Aiken | South Carolina | 45003 | 89 | 6 |
91760 | 91760 | 2020-04-26 | Aiken | South Carolina | 45003 | 89 | 6 |
94587 | 94587 | 2020-04-27 | Aiken | South Carolina | 45003 | 92 | 6 |
97426 | 97426 | 2020-04-28 | Aiken | South Carolina | 45003 | 94 | 6 |
100275 | 100275 | 2020-04-29 | Aiken | South Carolina | 45003 | 97 | 6 |
103128 | 103128 | 2020-04-30 | Aiken | South Carolina | 45003 | 99 | 6 |
105991 | 105991 | 2020-05-01 | Aiken | South Carolina | 45003 | 101 | 6 |
108858 | 108858 | 2020-05-02 | Aiken | South Carolina | 45003 | 105 | 6 |
111732 | 111732 | 2020-05-03 | Aiken | South Carolina | 45003 | 108 | 6 |
114614 | 114614 | 2020-05-04 | Aiken | South Carolina | 45003 | 108 | 6 |
117570 | 117570 | 2020-05-05 | Aiken | South Carolina | 45003 | 108 | 6 |
120532 | 120532 | 2020-05-06 | Aiken | South Carolina | 45003 | 108 | 6 |
123510 | 123510 | 2020-05-07 | Aiken | South Carolina | 45003 | 109 | 6 |
126493 | 126493 | 2020-05-08 | Aiken | South Carolina | 45003 | 112 | 6 |
129482 | 129482 | 2020-05-09 | Aiken | South Carolina | 45003 | 116 | 6 |
132471 | 132471 | 2020-05-10 | Aiken | South Carolina | 45003 | 118 | 6 |
135462 | 135462 | 2020-05-11 | Aiken | South Carolina | 45003 | 119 | 6 |
138452 | 138452 | 2020-05-12 | Aiken | South Carolina | 45003 | 123 | 7 |
141448 | 141448 | 2020-05-13 | Aiken | South Carolina | 45003 | 132 | 7 |
144444 | 144444 | 2020-05-14 | Aiken | South Carolina | 45003 | 135 | 7 |
147445 | 147445 | 2020-05-15 | Aiken | South Carolina | 45003 | 137 | 7 |
150453 | 150453 | 2020-05-16 | Aiken | South Carolina | 45003 | 150 | 7 |
153464 | 153464 | 2020-05-17 | Aiken | South Carolina | 45003 | 154 | 7 |
156481 | 156481 | 2020-05-18 | Aiken | South Carolina | 45003 | 155 | 7 |
159502 | 159502 | 2020-05-19 | Aiken | South Carolina | 45003 | 156 | 7 |
162529 | 162529 | 2020-05-20 | Aiken | South Carolina | 45003 | 160 | 7 |
165558 | 165558 | 2020-05-21 | Aiken | South Carolina | 45003 | 161 | 7 |
168594 | 168594 | 2020-05-22 | Aiken | South Carolina | 45003 | 166 | 7 |
171633 | 171633 | 2020-05-23 | Aiken | South Carolina | 45003 | 169 | 7 |
174675 | 174675 | 2020-05-24 | Aiken | South Carolina | 45003 | 173 | 7 |
177719 | 177719 | 2020-05-25 | Aiken | South Carolina | 45003 | 178 | 7 |
180762 | 180762 | 2020-05-26 | Aiken | South Carolina | 45003 | 181 | 7 |
183812 | 183812 | 2020-05-27 | Aiken | South Carolina | 45003 | 184 | 7 |
186869 | 186869 | 2020-05-28 | Aiken | South Carolina | 45003 | 189 | 7 |
189931 | 189931 | 2020-05-29 | Aiken | South Carolina | 45003 | 191 | 7 |
192996 | 192996 | 2020-05-30 | Aiken | South Carolina | 45003 | 194 | 7 |
196065 | 196065 | 2020-05-31 | Aiken | South Carolina | 45003 | 197 | 7 |
199138 | 199138 | 2020-06-01 | Aiken | South Carolina | 45003 | 206 | 7 |
202213 | 202213 | 2020-06-02 | Aiken | South Carolina | 45003 | 208 | 7 |
205290 | 205290 | 2020-06-03 | Aiken | South Carolina | 45003 | 210 | 8 |
208371 | 208371 | 2020-06-04 | Aiken | South Carolina | 45003 | 215 | 8 |
211453 | 211453 | 2020-06-05 | Aiken | South Carolina | 45003 | 216 | 8 |
214539 | 214539 | 2020-06-06 | Aiken | South Carolina | 45003 | 207 | 8 |
217629 | 217629 | 2020-06-07 | Aiken | South Carolina | 45003 | 208 | 8 |
220721 | 220721 | 2020-06-08 | Aiken | South Carolina | 45003 | 212 | 8 |
223816 | 223816 | 2020-06-09 | Aiken | South Carolina | 45003 | 213 | 8 |
226916 | 226916 | 2020-06-10 | Aiken | South Carolina | 45003 | 216 | 8 |
230020 | 230020 | 2020-06-11 | Aiken | South Carolina | 45003 | 222 | 8 |
233125 | 233125 | 2020-06-12 | Aiken | South Carolina | 45003 | 225 | 9 |
236230 | 236230 | 2020-06-13 | Aiken | South Carolina | 45003 | 228 | 9 |
239338 | 239338 | 2020-06-14 | Aiken | South Carolina | 45003 | 232 | 9 |
242447 | 242447 | 2020-06-15 | Aiken | South Carolina | 45003 | 234 | 9 |
245559 | 245559 | 2020-06-16 | Aiken | South Carolina | 45003 | 240 | 9 |
248672 | 248672 | 2020-06-17 | Aiken | South Carolina | 45003 | 246 | 9 |
251787 | 251787 | 2020-06-18 | Aiken | South Carolina | 45003 | 256 | 9 |
254902 | 254902 | 2020-06-19 | Aiken | South Carolina | 45003 | 261 | 9 |
258028 | 258028 | 2020-06-20 | Aiken | South Carolina | 45003 | 267 | 9 |
261155 | 261155 | 2020-06-21 | Aiken | South Carolina | 45003 | 274 | 9 |
264283 | 264283 | 2020-06-22 | Aiken | South Carolina | 45003 | 279 | 9 |
267411 | 267411 | 2020-06-23 | Aiken | South Carolina | 45003 | 281 | 9 |
270545 | 270545 | 2020-06-24 | Aiken | South Carolina | 45003 | 302 | 9 |
273684 | 273684 | 2020-06-25 | Aiken | South Carolina | 45003 | 314 | 9 |
276831 | 276831 | 2020-06-26 | Aiken | South Carolina | 45003 | 325 | 9 |
279979 | 279979 | 2020-06-27 | Aiken | South Carolina | 45003 | 335 | 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);