ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Wayne" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387916 | 387916 | 2020-07-31 | Wayne | North Carolina | 37191 | 2282 | 37 |
384699 | 384699 | 2020-07-30 | Wayne | North Carolina | 37191 | 2262 | 37 |
381481 | 381481 | 2020-07-29 | Wayne | North Carolina | 37191 | 2249 | 36 |
378264 | 378264 | 2020-07-28 | Wayne | North Carolina | 37191 | 2233 | 36 |
375048 | 375048 | 2020-07-27 | Wayne | North Carolina | 37191 | 2215 | 36 |
371836 | 371836 | 2020-07-26 | Wayne | North Carolina | 37191 | 2207 | 36 |
368624 | 368624 | 2020-07-25 | Wayne | North Carolina | 37191 | 2195 | 36 |
365415 | 365415 | 2020-07-24 | Wayne | North Carolina | 37191 | 2179 | 36 |
362209 | 362209 | 2020-07-23 | Wayne | North Carolina | 37191 | 2155 | 35 |
359003 | 359003 | 2020-07-22 | Wayne | North Carolina | 37191 | 2142 | 35 |
355799 | 355799 | 2020-07-21 | Wayne | North Carolina | 37191 | 2123 | 35 |
352596 | 352596 | 2020-07-20 | Wayne | North Carolina | 37191 | 2103 | 34 |
349393 | 349393 | 2020-07-19 | Wayne | North Carolina | 37191 | 2100 | 34 |
346192 | 346192 | 2020-07-18 | Wayne | North Carolina | 37191 | 2082 | 34 |
342993 | 342993 | 2020-07-17 | Wayne | North Carolina | 37191 | 2071 | 34 |
339795 | 339795 | 2020-07-16 | Wayne | North Carolina | 37191 | 2055 | 34 |
336599 | 336599 | 2020-07-15 | Wayne | North Carolina | 37191 | 2039 | 34 |
333405 | 333405 | 2020-07-14 | Wayne | North Carolina | 37191 | 2021 | 32 |
330215 | 330215 | 2020-07-13 | Wayne | North Carolina | 37191 | 2006 | 30 |
327028 | 327028 | 2020-07-12 | Wayne | North Carolina | 37191 | 1990 | 30 |
323844 | 323844 | 2020-07-11 | Wayne | North Carolina | 37191 | 1980 | 30 |
320664 | 320664 | 2020-07-10 | Wayne | North Carolina | 37191 | 1964 | 30 |
317487 | 317487 | 2020-07-09 | Wayne | North Carolina | 37191 | 1942 | 30 |
314313 | 314313 | 2020-07-08 | Wayne | North Carolina | 37191 | 1935 | 30 |
311142 | 311142 | 2020-07-07 | Wayne | North Carolina | 37191 | 1926 | 29 |
307974 | 307974 | 2020-07-06 | Wayne | North Carolina | 37191 | 1913 | 28 |
304807 | 304807 | 2020-07-05 | Wayne | North Carolina | 37191 | 1897 | 28 |
301644 | 301644 | 2020-07-04 | Wayne | North Carolina | 37191 | 1879 | 28 |
298481 | 298481 | 2020-07-03 | Wayne | North Carolina | 37191 | 1864 | 28 |
295321 | 295321 | 2020-07-02 | Wayne | North Carolina | 37191 | 1847 | 28 |
292166 | 292166 | 2020-07-01 | Wayne | North Carolina | 37191 | 1822 | 28 |
289014 | 289014 | 2020-06-30 | Wayne | North Carolina | 37191 | 1802 | 26 |
285864 | 285864 | 2020-06-29 | Wayne | North Carolina | 37191 | 1795 | 25 |
282719 | 282719 | 2020-06-28 | Wayne | North Carolina | 37191 | 1767 | 25 |
279573 | 279573 | 2020-06-27 | Wayne | North Carolina | 37191 | 1740 | 25 |
276425 | 276425 | 2020-06-26 | Wayne | North Carolina | 37191 | 1724 | 24 |
273279 | 273279 | 2020-06-25 | Wayne | North Carolina | 37191 | 1712 | 24 |
270140 | 270140 | 2020-06-24 | Wayne | North Carolina | 37191 | 1703 | 24 |
267006 | 267006 | 2020-06-23 | Wayne | North Carolina | 37191 | 1673 | 23 |
263878 | 263878 | 2020-06-22 | Wayne | North Carolina | 37191 | 1658 | 23 |
260750 | 260750 | 2020-06-21 | Wayne | North Carolina | 37191 | 1643 | 23 |
257623 | 257623 | 2020-06-20 | Wayne | North Carolina | 37191 | 1622 | 22 |
254500 | 254500 | 2020-06-19 | Wayne | North Carolina | 37191 | 1587 | 21 |
251385 | 251385 | 2020-06-18 | Wayne | North Carolina | 37191 | 1565 | 20 |
248270 | 248270 | 2020-06-17 | Wayne | North Carolina | 37191 | 1540 | 20 |
245157 | 245157 | 2020-06-16 | Wayne | North Carolina | 37191 | 1535 | 20 |
242045 | 242045 | 2020-06-15 | Wayne | North Carolina | 37191 | 1533 | 20 |
238936 | 238936 | 2020-06-14 | Wayne | North Carolina | 37191 | 1512 | 20 |
235828 | 235828 | 2020-06-13 | Wayne | North Carolina | 37191 | 1467 | 20 |
232723 | 232723 | 2020-06-12 | Wayne | North Carolina | 37191 | 1448 | 20 |
229618 | 229618 | 2020-06-11 | Wayne | North Carolina | 37191 | 1403 | 20 |
226514 | 226514 | 2020-06-10 | Wayne | North Carolina | 37191 | 1367 | 20 |
223414 | 223414 | 2020-06-09 | Wayne | North Carolina | 37191 | 1337 | 20 |
220320 | 220320 | 2020-06-08 | Wayne | North Carolina | 37191 | 1335 | 20 |
217228 | 217228 | 2020-06-07 | Wayne | North Carolina | 37191 | 1306 | 20 |
214138 | 214138 | 2020-06-06 | Wayne | North Carolina | 37191 | 1268 | 20 |
211054 | 211054 | 2020-06-05 | Wayne | North Carolina | 37191 | 1240 | 20 |
207972 | 207972 | 2020-06-04 | Wayne | North Carolina | 37191 | 1212 | 20 |
204891 | 204891 | 2020-06-03 | Wayne | North Carolina | 37191 | 1188 | 20 |
201814 | 201814 | 2020-06-02 | Wayne | North Carolina | 37191 | 1179 | 20 |
198740 | 198740 | 2020-06-01 | Wayne | North Carolina | 37191 | 1161 | 20 |
195667 | 195667 | 2020-05-31 | Wayne | North Carolina | 37191 | 1138 | 20 |
192597 | 192597 | 2020-05-30 | Wayne | North Carolina | 37191 | 1112 | 20 |
189533 | 189533 | 2020-05-29 | Wayne | North Carolina | 37191 | 1088 | 20 |
186473 | 186473 | 2020-05-28 | Wayne | North Carolina | 37191 | 1054 | 20 |
183416 | 183416 | 2020-05-27 | Wayne | North Carolina | 37191 | 1045 | 20 |
180368 | 180368 | 2020-05-26 | Wayne | North Carolina | 37191 | 1031 | 18 |
177325 | 177325 | 2020-05-25 | Wayne | North Carolina | 37191 | 1031 | 18 |
174281 | 174281 | 2020-05-24 | Wayne | North Carolina | 37191 | 1000 | 18 |
171239 | 171239 | 2020-05-23 | Wayne | North Carolina | 37191 | 980 | 18 |
168200 | 168200 | 2020-05-22 | Wayne | North Carolina | 37191 | 949 | 18 |
165165 | 165165 | 2020-05-21 | Wayne | North Carolina | 37191 | 910 | 17 |
162136 | 162136 | 2020-05-20 | Wayne | North Carolina | 37191 | 888 | 16 |
159109 | 159109 | 2020-05-19 | Wayne | North Carolina | 37191 | 879 | 16 |
156090 | 156090 | 2020-05-18 | Wayne | North Carolina | 37191 | 867 | 15 |
153073 | 153073 | 2020-05-17 | Wayne | North Carolina | 37191 | 832 | 15 |
150063 | 150063 | 2020-05-16 | Wayne | North Carolina | 37191 | 819 | 15 |
147056 | 147056 | 2020-05-15 | Wayne | North Carolina | 37191 | 801 | 15 |
144055 | 144055 | 2020-05-14 | Wayne | North Carolina | 37191 | 775 | 14 |
141060 | 141060 | 2020-05-13 | Wayne | North Carolina | 37191 | 760 | 13 |
138064 | 138064 | 2020-05-12 | Wayne | North Carolina | 37191 | 755 | 13 |
135074 | 135074 | 2020-05-11 | Wayne | North Carolina | 37191 | 752 | 13 |
132083 | 132083 | 2020-05-10 | Wayne | North Carolina | 37191 | 743 | 13 |
129094 | 129094 | 2020-05-09 | Wayne | North Carolina | 37191 | 726 | 13 |
126105 | 126105 | 2020-05-08 | Wayne | North Carolina | 37191 | 715 | 12 |
123122 | 123122 | 2020-05-07 | Wayne | North Carolina | 37191 | 699 | 12 |
120147 | 120147 | 2020-05-06 | Wayne | North Carolina | 37191 | 687 | 12 |
117186 | 117186 | 2020-05-05 | Wayne | North Carolina | 37191 | 688 | 12 |
114306 | 114306 | 2020-05-04 | Wayne | North Carolina | 37191 | 685 | 12 |
111425 | 111425 | 2020-05-03 | Wayne | North Carolina | 37191 | 677 | 11 |
108552 | 108552 | 2020-05-02 | Wayne | North Carolina | 37191 | 674 | 11 |
105685 | 105685 | 2020-05-01 | Wayne | North Carolina | 37191 | 658 | 11 |
102823 | 102823 | 2020-04-30 | Wayne | North Carolina | 37191 | 655 | 10 |
99970 | 99970 | 2020-04-29 | Wayne | North Carolina | 37191 | 645 | 10 |
97121 | 97121 | 2020-04-28 | Wayne | North Carolina | 37191 | 641 | 10 |
94284 | 94284 | 2020-04-27 | Wayne | North Carolina | 37191 | 635 | 10 |
91458 | 91458 | 2020-04-26 | Wayne | North Carolina | 37191 | 630 | 8 |
88643 | 88643 | 2020-04-25 | Wayne | North Carolina | 37191 | 618 | 8 |
85830 | 85830 | 2020-04-24 | Wayne | North Carolina | 37191 | 603 | 6 |
83026 | 83026 | 2020-04-23 | Wayne | North Carolina | 37191 | 596 | 6 |
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);