ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,553 rows where county = "Johnston" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, 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 |
58324 | 58324 | 2020-04-14 | Johnston | Oklahoma | 40069 | 2 | 0 |
60847 | 60847 | 2020-04-15 | Johnston | North Carolina | 37101 | 106 | 9 |
61039 | 61039 | 2020-04-15 | Johnston | Oklahoma | 40069 | 2 | 0 |
63573 | 63573 | 2020-04-16 | Johnston | North Carolina | 37101 | 109 | 9 |
63765 | 63765 | 2020-04-16 | Johnston | Oklahoma | 40069 | 2 | 0 |
66316 | 66316 | 2020-04-17 | Johnston | North Carolina | 37101 | 118 | 9 |
66509 | 66509 | 2020-04-17 | Johnston | Oklahoma | 40069 | 3 | 0 |
69073 | 69073 | 2020-04-18 | Johnston | North Carolina | 37101 | 121 | 9 |
69267 | 69267 | 2020-04-18 | Johnston | Oklahoma | 40069 | 3 | 0 |
71839 | 71839 | 2020-04-19 | Johnston | North Carolina | 37101 | 123 | 9 |
72034 | 72034 | 2020-04-19 | Johnston | Oklahoma | 40069 | 3 | 0 |
74614 | 74614 | 2020-04-20 | Johnston | North Carolina | 37101 | 123 | 9 |
74809 | 74809 | 2020-04-20 | Johnston | Oklahoma | 40069 | 3 | 0 |
77395 | 77395 | 2020-04-21 | Johnston | North Carolina | 37101 | 122 | 9 |
77591 | 77591 | 2020-04-21 | Johnston | Oklahoma | 40069 | 3 | 0 |
80184 | 80184 | 2020-04-22 | Johnston | North Carolina | 37101 | 122 | 10 |
80381 | 80381 | 2020-04-22 | Johnston | Oklahoma | 40069 | 3 | 0 |
82983 | 82983 | 2020-04-23 | Johnston | North Carolina | 37101 | 121 | 10 |
83180 | 83180 | 2020-04-23 | Johnston | Oklahoma | 40069 | 3 | 0 |
85787 | 85787 | 2020-04-24 | Johnston | North Carolina | 37101 | 125 | 10 |
85984 | 85984 | 2020-04-24 | Johnston | Oklahoma | 40069 | 3 | 0 |
88599 | 88599 | 2020-04-25 | Johnston | North Carolina | 37101 | 127 | 10 |
88798 | 88798 | 2020-04-25 | Johnston | Oklahoma | 40069 | 4 | 0 |
91414 | 91414 | 2020-04-26 | Johnston | North Carolina | 37101 | 135 | 10 |
91614 | 91614 | 2020-04-26 | Johnston | Oklahoma | 40069 | 3 | 0 |
94240 | 94240 | 2020-04-27 | Johnston | North Carolina | 37101 | 137 | 10 |
94440 | 94440 | 2020-04-27 | Johnston | Oklahoma | 40069 | 3 | 0 |
97077 | 97077 | 2020-04-28 | Johnston | North Carolina | 37101 | 140 | 12 |
97278 | 97278 | 2020-04-28 | Johnston | Oklahoma | 40069 | 3 | 0 |
99925 | 99925 | 2020-04-29 | Johnston | North Carolina | 37101 | 147 | 12 |
100127 | 100127 | 2020-04-29 | Johnston | Oklahoma | 40069 | 3 | 0 |
102778 | 102778 | 2020-04-30 | Johnston | North Carolina | 37101 | 150 | 12 |
102980 | 102980 | 2020-04-30 | Johnston | Oklahoma | 40069 | 3 | 0 |
105640 | 105640 | 2020-05-01 | Johnston | North Carolina | 37101 | 159 | 12 |
105843 | 105843 | 2020-05-01 | Johnston | Oklahoma | 40069 | 3 | 0 |
108507 | 108507 | 2020-05-02 | Johnston | North Carolina | 37101 | 162 | 15 |
108710 | 108710 | 2020-05-02 | Johnston | Oklahoma | 40069 | 3 | 0 |
111380 | 111380 | 2020-05-03 | Johnston | North Carolina | 37101 | 164 | 15 |
111584 | 111584 | 2020-05-03 | Johnston | Oklahoma | 40069 | 3 | 0 |
114261 | 114261 | 2020-05-04 | Johnston | North Carolina | 37101 | 166 | 16 |
114466 | 114466 | 2020-05-04 | Johnston | Oklahoma | 40069 | 3 | 0 |
117141 | 117141 | 2020-05-05 | Johnston | North Carolina | 37101 | 173 | 17 |
117347 | 117347 | 2020-05-05 | Johnston | Oklahoma | 40069 | 3 | 0 |
120102 | 120102 | 2020-05-06 | Johnston | North Carolina | 37101 | 188 | 17 |
120308 | 120308 | 2020-05-06 | Johnston | Oklahoma | 40069 | 3 | 0 |
123077 | 123077 | 2020-05-07 | Johnston | North Carolina | 37101 | 189 | 17 |
123285 | 123285 | 2020-05-07 | Johnston | Oklahoma | 40069 | 3 | 0 |
126060 | 126060 | 2020-05-08 | Johnston | North Carolina | 37101 | 191 | 17 |
126268 | 126268 | 2020-05-08 | Johnston | Oklahoma | 40069 | 3 | 0 |
129049 | 129049 | 2020-05-09 | Johnston | North Carolina | 37101 | 201 | 17 |
129257 | 129257 | 2020-05-09 | Johnston | Oklahoma | 40069 | 3 | 0 |
132038 | 132038 | 2020-05-10 | Johnston | North Carolina | 37101 | 205 | 17 |
132246 | 132246 | 2020-05-10 | Johnston | Oklahoma | 40069 | 3 | 0 |
135029 | 135029 | 2020-05-11 | Johnston | North Carolina | 37101 | 209 | 18 |
135237 | 135237 | 2020-05-11 | Johnston | Oklahoma | 40069 | 3 | 0 |
138019 | 138019 | 2020-05-12 | Johnston | North Carolina | 37101 | 217 | 19 |
138227 | 138227 | 2020-05-12 | Johnston | Oklahoma | 40069 | 3 | 0 |
141015 | 141015 | 2020-05-13 | Johnston | North Carolina | 37101 | 220 | 19 |
141223 | 141223 | 2020-05-13 | Johnston | Oklahoma | 40069 | 3 | 0 |
144010 | 144010 | 2020-05-14 | Johnston | North Carolina | 37101 | 228 | 19 |
144218 | 144218 | 2020-05-14 | Johnston | Oklahoma | 40069 | 3 | 0 |
147011 | 147011 | 2020-05-15 | Johnston | North Carolina | 37101 | 233 | 19 |
147219 | 147219 | 2020-05-15 | Johnston | Oklahoma | 40069 | 3 | 0 |
150018 | 150018 | 2020-05-16 | Johnston | North Carolina | 37101 | 234 | 19 |
150226 | 150226 | 2020-05-16 | Johnston | Oklahoma | 40069 | 3 | 0 |
153028 | 153028 | 2020-05-17 | Johnston | North Carolina | 37101 | 247 | 19 |
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);