ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 37101 and state = "North Carolina" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1532 | 1532 | 2020-03-12 | Johnston | North Carolina | 37101 | 1 | 0 |
1826 | 1826 | 2020-03-13 | Johnston | North Carolina | 37101 | 1 | 0 |
2180 | 2180 | 2020-03-14 | Johnston | North Carolina | 37101 | 2 | 0 |
2592 | 2592 | 2020-03-15 | Johnston | North Carolina | 37101 | 2 | 0 |
3054 | 3054 | 2020-03-16 | Johnston | North Carolina | 37101 | 2 | 0 |
3574 | 3574 | 2020-03-17 | Johnston | North Carolina | 37101 | 2 | 0 |
4180 | 4180 | 2020-03-18 | Johnston | North Carolina | 37101 | 2 | 0 |
4911 | 4911 | 2020-03-19 | Johnston | North Carolina | 37101 | 2 | 0 |
5765 | 5765 | 2020-03-20 | Johnston | North Carolina | 37101 | 2 | 0 |
6762 | 6762 | 2020-03-21 | Johnston | North Carolina | 37101 | 2 | 0 |
7863 | 7863 | 2020-03-22 | Johnston | North Carolina | 37101 | 3 | 0 |
9064 | 9064 | 2020-03-23 | Johnston | North Carolina | 37101 | 3 | 0 |
10372 | 10372 | 2020-03-24 | Johnston | North Carolina | 37101 | 4 | 0 |
11814 | 11814 | 2020-03-25 | Johnston | North Carolina | 37101 | 8 | 0 |
13418 | 13418 | 2020-03-26 | Johnston | North Carolina | 37101 | 9 | 0 |
15153 | 15153 | 2020-03-27 | Johnston | North Carolina | 37101 | 9 | 1 |
16985 | 16985 | 2020-03-28 | Johnston | North Carolina | 37101 | 9 | 1 |
18916 | 18916 | 2020-03-29 | Johnston | North Carolina | 37101 | 10 | 1 |
20956 | 20956 | 2020-03-30 | Johnston | North Carolina | 37101 | 11 | 1 |
23082 | 23082 | 2020-03-31 | Johnston | North Carolina | 37101 | 15 | 1 |
25276 | 25276 | 2020-04-01 | Johnston | North Carolina | 37101 | 17 | 1 |
27539 | 27539 | 2020-04-02 | Johnston | North Carolina | 37101 | 20 | 1 |
29866 | 29866 | 2020-04-03 | Johnston | North Carolina | 37101 | 24 | 1 |
32253 | 32253 | 2020-04-04 | Johnston | North Carolina | 37101 | 26 | 2 |
34684 | 34684 | 2020-04-05 | Johnston | North Carolina | 37101 | 32 | 3 |
37153 | 37153 | 2020-04-06 | Johnston | North Carolina | 37101 | 37 | 3 |
39668 | 39668 | 2020-04-07 | Johnston | North Carolina | 37101 | 47 | 4 |
42225 | 42225 | 2020-04-08 | Johnston | North Carolina | 37101 | 51 | 4 |
44808 | 44808 | 2020-04-09 | Johnston | North Carolina | 37101 | 57 | 5 |
47421 | 47421 | 2020-04-10 | Johnston | North Carolina | 37101 | 80 | 4 |
50076 | 50076 | 2020-04-11 | Johnston | North Carolina | 37101 | 92 | 4 |
52749 | 52749 | 2020-04-12 | Johnston | North Carolina | 37101 | 97 | 4 |
55433 | 55433 | 2020-04-13 | Johnston | North Carolina | 37101 | 97 | 4 |
58133 | 58133 | 2020-04-14 | Johnston | North Carolina | 37101 | 104 | 8 |
60847 | 60847 | 2020-04-15 | Johnston | North Carolina | 37101 | 106 | 9 |
63573 | 63573 | 2020-04-16 | Johnston | North Carolina | 37101 | 109 | 9 |
66316 | 66316 | 2020-04-17 | Johnston | North Carolina | 37101 | 118 | 9 |
69073 | 69073 | 2020-04-18 | Johnston | North Carolina | 37101 | 121 | 9 |
71839 | 71839 | 2020-04-19 | Johnston | North Carolina | 37101 | 123 | 9 |
74614 | 74614 | 2020-04-20 | Johnston | North Carolina | 37101 | 123 | 9 |
77395 | 77395 | 2020-04-21 | Johnston | North Carolina | 37101 | 122 | 9 |
80184 | 80184 | 2020-04-22 | Johnston | North Carolina | 37101 | 122 | 10 |
82983 | 82983 | 2020-04-23 | Johnston | North Carolina | 37101 | 121 | 10 |
85787 | 85787 | 2020-04-24 | Johnston | North Carolina | 37101 | 125 | 10 |
88599 | 88599 | 2020-04-25 | Johnston | North Carolina | 37101 | 127 | 10 |
91414 | 91414 | 2020-04-26 | Johnston | North Carolina | 37101 | 135 | 10 |
94240 | 94240 | 2020-04-27 | Johnston | North Carolina | 37101 | 137 | 10 |
97077 | 97077 | 2020-04-28 | Johnston | North Carolina | 37101 | 140 | 12 |
99925 | 99925 | 2020-04-29 | Johnston | North Carolina | 37101 | 147 | 12 |
102778 | 102778 | 2020-04-30 | Johnston | North Carolina | 37101 | 150 | 12 |
105640 | 105640 | 2020-05-01 | Johnston | North Carolina | 37101 | 159 | 12 |
108507 | 108507 | 2020-05-02 | Johnston | North Carolina | 37101 | 162 | 15 |
111380 | 111380 | 2020-05-03 | Johnston | North Carolina | 37101 | 164 | 15 |
114261 | 114261 | 2020-05-04 | Johnston | North Carolina | 37101 | 166 | 16 |
117141 | 117141 | 2020-05-05 | Johnston | North Carolina | 37101 | 173 | 17 |
120102 | 120102 | 2020-05-06 | Johnston | North Carolina | 37101 | 188 | 17 |
123077 | 123077 | 2020-05-07 | Johnston | North Carolina | 37101 | 189 | 17 |
126060 | 126060 | 2020-05-08 | Johnston | North Carolina | 37101 | 191 | 17 |
129049 | 129049 | 2020-05-09 | Johnston | North Carolina | 37101 | 201 | 17 |
132038 | 132038 | 2020-05-10 | Johnston | North Carolina | 37101 | 205 | 17 |
135029 | 135029 | 2020-05-11 | Johnston | North Carolina | 37101 | 209 | 18 |
138019 | 138019 | 2020-05-12 | Johnston | North Carolina | 37101 | 217 | 19 |
141015 | 141015 | 2020-05-13 | Johnston | North Carolina | 37101 | 220 | 19 |
144010 | 144010 | 2020-05-14 | Johnston | North Carolina | 37101 | 228 | 19 |
147011 | 147011 | 2020-05-15 | Johnston | North Carolina | 37101 | 233 | 19 |
150018 | 150018 | 2020-05-16 | Johnston | North Carolina | 37101 | 234 | 19 |
153028 | 153028 | 2020-05-17 | Johnston | North Carolina | 37101 | 247 | 19 |
156045 | 156045 | 2020-05-18 | Johnston | North Carolina | 37101 | 259 | 19 |
159064 | 159064 | 2020-05-19 | Johnston | North Carolina | 37101 | 269 | 19 |
162091 | 162091 | 2020-05-20 | Johnston | North Carolina | 37101 | 276 | 19 |
165120 | 165120 | 2020-05-21 | Johnston | North Carolina | 37101 | 290 | 20 |
168155 | 168155 | 2020-05-22 | Johnston | North Carolina | 37101 | 305 | 20 |
171194 | 171194 | 2020-05-23 | Johnston | North Carolina | 37101 | 320 | 20 |
174236 | 174236 | 2020-05-24 | Johnston | North Carolina | 37101 | 330 | 20 |
177280 | 177280 | 2020-05-25 | Johnston | North Carolina | 37101 | 351 | 20 |
180323 | 180323 | 2020-05-26 | Johnston | North Carolina | 37101 | 361 | 20 |
183371 | 183371 | 2020-05-27 | Johnston | North Carolina | 37101 | 365 | 20 |
186428 | 186428 | 2020-05-28 | Johnston | North Carolina | 37101 | 408 | 21 |
189488 | 189488 | 2020-05-29 | Johnston | North Carolina | 37101 | 428 | 21 |
192552 | 192552 | 2020-05-30 | Johnston | North Carolina | 37101 | 440 | 21 |
195622 | 195622 | 2020-05-31 | Johnston | North Carolina | 37101 | 456 | 21 |
198695 | 198695 | 2020-06-01 | Johnston | North Carolina | 37101 | 466 | 21 |
201769 | 201769 | 2020-06-02 | Johnston | North Carolina | 37101 | 494 | 22 |
204846 | 204846 | 2020-06-03 | Johnston | North Carolina | 37101 | 513 | 23 |
207927 | 207927 | 2020-06-04 | Johnston | North Carolina | 37101 | 552 | 23 |
211009 | 211009 | 2020-06-05 | Johnston | North Carolina | 37101 | 582 | 23 |
214093 | 214093 | 2020-06-06 | Johnston | North Carolina | 37101 | 601 | 23 |
217183 | 217183 | 2020-06-07 | Johnston | North Carolina | 37101 | 620 | 23 |
220275 | 220275 | 2020-06-08 | Johnston | North Carolina | 37101 | 648 | 23 |
223369 | 223369 | 2020-06-09 | Johnston | North Carolina | 37101 | 669 | 23 |
226469 | 226469 | 2020-06-10 | Johnston | North Carolina | 37101 | 677 | 23 |
229573 | 229573 | 2020-06-11 | Johnston | North Carolina | 37101 | 699 | 24 |
232678 | 232678 | 2020-06-12 | Johnston | North Carolina | 37101 | 804 | 25 |
235783 | 235783 | 2020-06-13 | Johnston | North Carolina | 37101 | 804 | 25 |
238891 | 238891 | 2020-06-14 | Johnston | North Carolina | 37101 | 849 | 25 |
242000 | 242000 | 2020-06-15 | Johnston | North Carolina | 37101 | 903 | 25 |
245112 | 245112 | 2020-06-16 | Johnston | North Carolina | 37101 | 935 | 25 |
248225 | 248225 | 2020-06-17 | Johnston | North Carolina | 37101 | 972 | 26 |
251340 | 251340 | 2020-06-18 | Johnston | North Carolina | 37101 | 1000 | 26 |
254455 | 254455 | 2020-06-19 | Johnston | North Carolina | 37101 | 1037 | 26 |
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);