ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
802 rows where county = "Wake" and state = "North Carolina" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
484 | 484 | 2020-03-03 | Wake | North Carolina | 37183 | 1 | 0 |
521 | 521 | 2020-03-04 | Wake | North Carolina | 37183 | 1 | 0 |
568 | 568 | 2020-03-05 | Wake | North Carolina | 37183 | 1 | 0 |
632 | 632 | 2020-03-06 | Wake | North Carolina | 37183 | 1 | 0 |
721 | 721 | 2020-03-07 | Wake | North Carolina | 37183 | 1 | 0 |
828 | 828 | 2020-03-08 | Wake | North Carolina | 37183 | 1 | 0 |
955 | 955 | 2020-03-09 | Wake | North Carolina | 37183 | 6 | 0 |
1106 | 1106 | 2020-03-10 | Wake | North Carolina | 37183 | 6 | 0 |
1293 | 1293 | 2020-03-11 | Wake | North Carolina | 37183 | 7 | 0 |
1535 | 1535 | 2020-03-12 | Wake | North Carolina | 37183 | 8 | 0 |
1829 | 1829 | 2020-03-13 | Wake | North Carolina | 37183 | 9 | 0 |
2183 | 2183 | 2020-03-14 | Wake | North Carolina | 37183 | 11 | 0 |
2595 | 2595 | 2020-03-15 | Wake | North Carolina | 37183 | 14 | 0 |
3057 | 3057 | 2020-03-16 | Wake | North Carolina | 37183 | 15 | 0 |
3578 | 3578 | 2020-03-17 | Wake | North Carolina | 37183 | 17 | 0 |
4187 | 4187 | 2020-03-18 | Wake | North Carolina | 37183 | 17 | 0 |
4918 | 4918 | 2020-03-19 | Wake | North Carolina | 37183 | 25 | 0 |
5777 | 5777 | 2020-03-20 | Wake | North Carolina | 37183 | 25 | 0 |
6774 | 6774 | 2020-03-21 | Wake | North Carolina | 37183 | 49 | 0 |
7880 | 7880 | 2020-03-22 | Wake | North Carolina | 37183 | 49 | 0 |
9082 | 9082 | 2020-03-23 | Wake | North Carolina | 37183 | 52 | 0 |
10393 | 10393 | 2020-03-24 | Wake | North Carolina | 37183 | 54 | 0 |
11838 | 11838 | 2020-03-25 | Wake | North Carolina | 37183 | 73 | 0 |
13442 | 13442 | 2020-03-26 | Wake | North Carolina | 37183 | 83 | 0 |
15179 | 15179 | 2020-03-27 | Wake | North Carolina | 37183 | 121 | 0 |
17013 | 17013 | 2020-03-28 | Wake | North Carolina | 37183 | 124 | 0 |
18945 | 18945 | 2020-03-29 | Wake | North Carolina | 37183 | 146 | 0 |
20986 | 20986 | 2020-03-30 | Wake | North Carolina | 37183 | 166 | 0 |
23114 | 23114 | 2020-03-31 | Wake | North Carolina | 37183 | 192 | 0 |
25308 | 25308 | 2020-04-01 | Wake | North Carolina | 37183 | 195 | 0 |
27574 | 27574 | 2020-04-02 | Wake | North Carolina | 37183 | 234 | 0 |
29901 | 29901 | 2020-04-03 | Wake | North Carolina | 37183 | 258 | 0 |
32288 | 32288 | 2020-04-04 | Wake | North Carolina | 37183 | 283 | 0 |
34720 | 34720 | 2020-04-05 | Wake | North Carolina | 37183 | 304 | 0 |
37189 | 37189 | 2020-04-06 | Wake | North Carolina | 37183 | 314 | 0 |
39705 | 39705 | 2020-04-07 | Wake | North Carolina | 37183 | 336 | 0 |
42262 | 42262 | 2020-04-08 | Wake | North Carolina | 37183 | 363 | 0 |
44846 | 44846 | 2020-04-09 | Wake | North Carolina | 37183 | 371 | 0 |
47459 | 47459 | 2020-04-10 | Wake | North Carolina | 37183 | 391 | 0 |
50114 | 50114 | 2020-04-11 | Wake | North Carolina | 37183 | 424 | 0 |
52787 | 52787 | 2020-04-12 | Wake | North Carolina | 37183 | 470 | 0 |
55471 | 55471 | 2020-04-13 | Wake | North Carolina | 37183 | 476 | 0 |
58172 | 58172 | 2020-04-14 | Wake | North Carolina | 37183 | 501 | 0 |
60886 | 60886 | 2020-04-15 | Wake | North Carolina | 37183 | 510 | 1 |
63612 | 63612 | 2020-04-16 | Wake | North Carolina | 37183 | 552 | 1 |
66355 | 66355 | 2020-04-17 | Wake | North Carolina | 37183 | 566 | 3 |
69112 | 69112 | 2020-04-18 | Wake | North Carolina | 37183 | 579 | 4 |
71878 | 71878 | 2020-04-19 | Wake | North Carolina | 37183 | 592 | 4 |
74653 | 74653 | 2020-04-20 | Wake | North Carolina | 37183 | 599 | 4 |
77434 | 77434 | 2020-04-21 | Wake | North Carolina | 37183 | 611 | 8 |
80223 | 80223 | 2020-04-22 | Wake | North Carolina | 37183 | 616 | 9 |
83022 | 83022 | 2020-04-23 | Wake | North Carolina | 37183 | 626 | 11 |
85826 | 85826 | 2020-04-24 | Wake | North Carolina | 37183 | 633 | 11 |
88639 | 88639 | 2020-04-25 | Wake | North Carolina | 37183 | 645 | 13 |
91454 | 91454 | 2020-04-26 | Wake | North Carolina | 37183 | 663 | 13 |
94280 | 94280 | 2020-04-27 | Wake | North Carolina | 37183 | 671 | 15 |
97117 | 97117 | 2020-04-28 | Wake | North Carolina | 37183 | 769 | 15 |
99966 | 99966 | 2020-04-29 | Wake | North Carolina | 37183 | 788 | 16 |
102819 | 102819 | 2020-04-30 | Wake | North Carolina | 37183 | 821 | 17 |
105681 | 105681 | 2020-05-01 | Wake | North Carolina | 37183 | 839 | 18 |
108548 | 108548 | 2020-05-02 | Wake | North Carolina | 37183 | 870 | 19 |
111421 | 111421 | 2020-05-03 | Wake | North Carolina | 37183 | 874 | 19 |
114302 | 114302 | 2020-05-04 | Wake | North Carolina | 37183 | 891 | 20 |
117182 | 117182 | 2020-05-05 | Wake | North Carolina | 37183 | 919 | 21 |
120143 | 120143 | 2020-05-06 | Wake | North Carolina | 37183 | 937 | 21 |
123118 | 123118 | 2020-05-07 | Wake | North Carolina | 37183 | 961 | 21 |
126101 | 126101 | 2020-05-08 | Wake | North Carolina | 37183 | 986 | 22 |
129090 | 129090 | 2020-05-09 | Wake | North Carolina | 37183 | 1013 | 23 |
132079 | 132079 | 2020-05-10 | Wake | North Carolina | 37183 | 1030 | 23 |
135070 | 135070 | 2020-05-11 | Wake | North Carolina | 37183 | 1048 | 23 |
138060 | 138060 | 2020-05-12 | Wake | North Carolina | 37183 | 1061 | 23 |
141056 | 141056 | 2020-05-13 | Wake | North Carolina | 37183 | 1080 | 25 |
144051 | 144051 | 2020-05-14 | Wake | North Carolina | 37183 | 1107 | 27 |
147052 | 147052 | 2020-05-15 | Wake | North Carolina | 37183 | 1143 | 28 |
150059 | 150059 | 2020-05-16 | Wake | North Carolina | 37183 | 1176 | 28 |
153069 | 153069 | 2020-05-17 | Wake | North Carolina | 37183 | 1212 | 28 |
156086 | 156086 | 2020-05-18 | Wake | North Carolina | 37183 | 1239 | 28 |
159105 | 159105 | 2020-05-19 | Wake | North Carolina | 37183 | 1272 | 30 |
162132 | 162132 | 2020-05-20 | Wake | North Carolina | 37183 | 1307 | 30 |
165161 | 165161 | 2020-05-21 | Wake | North Carolina | 37183 | 1345 | 32 |
168196 | 168196 | 2020-05-22 | Wake | North Carolina | 37183 | 1389 | 32 |
171235 | 171235 | 2020-05-23 | Wake | North Carolina | 37183 | 1434 | 32 |
174277 | 174277 | 2020-05-24 | Wake | North Carolina | 37183 | 1448 | 32 |
177321 | 177321 | 2020-05-25 | Wake | North Carolina | 37183 | 1471 | 33 |
180364 | 180364 | 2020-05-26 | Wake | North Carolina | 37183 | 1478 | 34 |
183412 | 183412 | 2020-05-27 | Wake | North Carolina | 37183 | 1523 | 36 |
186469 | 186469 | 2020-05-28 | Wake | North Carolina | 37183 | 1604 | 36 |
189529 | 189529 | 2020-05-29 | Wake | North Carolina | 37183 | 1661 | 38 |
192593 | 192593 | 2020-05-30 | Wake | North Carolina | 37183 | 1713 | 39 |
195663 | 195663 | 2020-05-31 | Wake | North Carolina | 37183 | 1747 | 39 |
198736 | 198736 | 2020-06-01 | Wake | North Carolina | 37183 | 1773 | 39 |
201810 | 201810 | 2020-06-02 | Wake | North Carolina | 37183 | 1878 | 40 |
204887 | 204887 | 2020-06-03 | Wake | North Carolina | 37183 | 1901 | 40 |
207968 | 207968 | 2020-06-04 | Wake | North Carolina | 37183 | 2051 | 40 |
211050 | 211050 | 2020-06-05 | Wake | North Carolina | 37183 | 2133 | 40 |
214134 | 214134 | 2020-06-06 | Wake | North Carolina | 37183 | 2186 | 40 |
217224 | 217224 | 2020-06-07 | Wake | North Carolina | 37183 | 2255 | 40 |
220316 | 220316 | 2020-06-08 | Wake | North Carolina | 37183 | 2325 | 41 |
223410 | 223410 | 2020-06-09 | Wake | North Carolina | 37183 | 2440 | 42 |
226510 | 226510 | 2020-06-10 | Wake | North Carolina | 37183 | 2541 | 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);