ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Onslow" and state = "North Carolina" 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 |
---|---|---|---|---|---|---|---|
1534 | 1534 | 2020-03-12 | Onslow | North Carolina | 37133 | 1 | 0 |
1828 | 1828 | 2020-03-13 | Onslow | North Carolina | 37133 | 1 | 0 |
2182 | 2182 | 2020-03-14 | Onslow | North Carolina | 37133 | 1 | 0 |
2594 | 2594 | 2020-03-15 | Onslow | North Carolina | 37133 | 1 | 0 |
3056 | 3056 | 2020-03-16 | Onslow | North Carolina | 37133 | 1 | 0 |
3576 | 3576 | 2020-03-17 | Onslow | North Carolina | 37133 | 1 | 0 |
4185 | 4185 | 2020-03-18 | Onslow | North Carolina | 37133 | 1 | 0 |
4916 | 4916 | 2020-03-19 | Onslow | North Carolina | 37133 | 1 | 0 |
5770 | 5770 | 2020-03-20 | Onslow | North Carolina | 37133 | 1 | 0 |
6767 | 6767 | 2020-03-21 | Onslow | North Carolina | 37133 | 1 | 0 |
7870 | 7870 | 2020-03-22 | Onslow | North Carolina | 37133 | 1 | 0 |
9071 | 9071 | 2020-03-23 | Onslow | North Carolina | 37133 | 1 | 0 |
10380 | 10380 | 2020-03-24 | Onslow | North Carolina | 37133 | 3 | 0 |
11825 | 11825 | 2020-03-25 | Onslow | North Carolina | 37133 | 3 | 0 |
13429 | 13429 | 2020-03-26 | Onslow | North Carolina | 37133 | 4 | 0 |
15164 | 15164 | 2020-03-27 | Onslow | North Carolina | 37133 | 4 | 0 |
16996 | 16996 | 2020-03-28 | Onslow | North Carolina | 37133 | 4 | 0 |
18927 | 18927 | 2020-03-29 | Onslow | North Carolina | 37133 | 4 | 0 |
20967 | 20967 | 2020-03-30 | Onslow | North Carolina | 37133 | 6 | 0 |
23094 | 23094 | 2020-03-31 | Onslow | North Carolina | 37133 | 7 | 1 |
25288 | 25288 | 2020-04-01 | Onslow | North Carolina | 37133 | 7 | 1 |
27553 | 27553 | 2020-04-02 | Onslow | North Carolina | 37133 | 8 | 1 |
29880 | 29880 | 2020-04-03 | Onslow | North Carolina | 37133 | 9 | 1 |
32267 | 32267 | 2020-04-04 | Onslow | North Carolina | 37133 | 13 | 1 |
34698 | 34698 | 2020-04-05 | Onslow | North Carolina | 37133 | 16 | 1 |
37167 | 37167 | 2020-04-06 | Onslow | North Carolina | 37133 | 18 | 1 |
39682 | 39682 | 2020-04-07 | Onslow | North Carolina | 37133 | 23 | 1 |
42239 | 42239 | 2020-04-08 | Onslow | North Carolina | 37133 | 23 | 1 |
44823 | 44823 | 2020-04-09 | Onslow | North Carolina | 37133 | 24 | 1 |
47436 | 47436 | 2020-04-10 | Onslow | North Carolina | 37133 | 26 | 1 |
50091 | 50091 | 2020-04-11 | Onslow | North Carolina | 37133 | 28 | 1 |
52764 | 52764 | 2020-04-12 | Onslow | North Carolina | 37133 | 29 | 1 |
55448 | 55448 | 2020-04-13 | Onslow | North Carolina | 37133 | 29 | 1 |
58148 | 58148 | 2020-04-14 | Onslow | North Carolina | 37133 | 29 | 1 |
60862 | 60862 | 2020-04-15 | Onslow | North Carolina | 37133 | 29 | 1 |
63588 | 63588 | 2020-04-16 | Onslow | North Carolina | 37133 | 31 | 1 |
66331 | 66331 | 2020-04-17 | Onslow | North Carolina | 37133 | 32 | 1 |
69088 | 69088 | 2020-04-18 | Onslow | North Carolina | 37133 | 33 | 1 |
71854 | 71854 | 2020-04-19 | Onslow | North Carolina | 37133 | 33 | 1 |
74629 | 74629 | 2020-04-20 | Onslow | North Carolina | 37133 | 33 | 1 |
77410 | 77410 | 2020-04-21 | Onslow | North Carolina | 37133 | 33 | 1 |
80199 | 80199 | 2020-04-22 | Onslow | North Carolina | 37133 | 33 | 1 |
82998 | 82998 | 2020-04-23 | Onslow | North Carolina | 37133 | 33 | 1 |
85802 | 85802 | 2020-04-24 | Onslow | North Carolina | 37133 | 40 | 1 |
88615 | 88615 | 2020-04-25 | Onslow | North Carolina | 37133 | 42 | 1 |
91430 | 91430 | 2020-04-26 | Onslow | North Carolina | 37133 | 42 | 1 |
94256 | 94256 | 2020-04-27 | Onslow | North Carolina | 37133 | 43 | 1 |
97093 | 97093 | 2020-04-28 | Onslow | North Carolina | 37133 | 43 | 1 |
99941 | 99941 | 2020-04-29 | Onslow | North Carolina | 37133 | 43 | 1 |
102794 | 102794 | 2020-04-30 | Onslow | North Carolina | 37133 | 45 | 1 |
105656 | 105656 | 2020-05-01 | Onslow | North Carolina | 37133 | 46 | 1 |
108523 | 108523 | 2020-05-02 | Onslow | North Carolina | 37133 | 51 | 1 |
111396 | 111396 | 2020-05-03 | Onslow | North Carolina | 37133 | 50 | 1 |
114277 | 114277 | 2020-05-04 | Onslow | North Carolina | 37133 | 50 | 2 |
117157 | 117157 | 2020-05-05 | Onslow | North Carolina | 37133 | 51 | 2 |
120118 | 120118 | 2020-05-06 | Onslow | North Carolina | 37133 | 52 | 2 |
123093 | 123093 | 2020-05-07 | Onslow | North Carolina | 37133 | 53 | 2 |
126076 | 126076 | 2020-05-08 | Onslow | North Carolina | 37133 | 53 | 2 |
129065 | 129065 | 2020-05-09 | Onslow | North Carolina | 37133 | 54 | 2 |
132054 | 132054 | 2020-05-10 | Onslow | North Carolina | 37133 | 53 | 2 |
135045 | 135045 | 2020-05-11 | Onslow | North Carolina | 37133 | 54 | 2 |
138035 | 138035 | 2020-05-12 | Onslow | North Carolina | 37133 | 58 | 2 |
141031 | 141031 | 2020-05-13 | Onslow | North Carolina | 37133 | 59 | 2 |
144026 | 144026 | 2020-05-14 | Onslow | North Carolina | 37133 | 63 | 2 |
147027 | 147027 | 2020-05-15 | Onslow | North Carolina | 37133 | 67 | 2 |
150034 | 150034 | 2020-05-16 | Onslow | North Carolina | 37133 | 70 | 2 |
153044 | 153044 | 2020-05-17 | Onslow | North Carolina | 37133 | 71 | 2 |
156061 | 156061 | 2020-05-18 | Onslow | North Carolina | 37133 | 75 | 2 |
159080 | 159080 | 2020-05-19 | Onslow | North Carolina | 37133 | 80 | 2 |
162107 | 162107 | 2020-05-20 | Onslow | North Carolina | 37133 | 79 | 2 |
165136 | 165136 | 2020-05-21 | Onslow | North Carolina | 37133 | 81 | 2 |
168171 | 168171 | 2020-05-22 | Onslow | North Carolina | 37133 | 83 | 2 |
171210 | 171210 | 2020-05-23 | Onslow | North Carolina | 37133 | 94 | 2 |
174252 | 174252 | 2020-05-24 | Onslow | North Carolina | 37133 | 97 | 2 |
177296 | 177296 | 2020-05-25 | Onslow | North Carolina | 37133 | 98 | 2 |
180339 | 180339 | 2020-05-26 | Onslow | North Carolina | 37133 | 98 | 2 |
183387 | 183387 | 2020-05-27 | Onslow | North Carolina | 37133 | 98 | 2 |
186444 | 186444 | 2020-05-28 | Onslow | North Carolina | 37133 | 98 | 2 |
189504 | 189504 | 2020-05-29 | Onslow | North Carolina | 37133 | 100 | 2 |
192568 | 192568 | 2020-05-30 | Onslow | North Carolina | 37133 | 108 | 2 |
195638 | 195638 | 2020-05-31 | Onslow | North Carolina | 37133 | 110 | 2 |
198711 | 198711 | 2020-06-01 | Onslow | North Carolina | 37133 | 110 | 2 |
201785 | 201785 | 2020-06-02 | Onslow | North Carolina | 37133 | 112 | 2 |
204862 | 204862 | 2020-06-03 | Onslow | North Carolina | 37133 | 114 | 2 |
207943 | 207943 | 2020-06-04 | Onslow | North Carolina | 37133 | 117 | 2 |
211025 | 211025 | 2020-06-05 | Onslow | North Carolina | 37133 | 120 | 2 |
214109 | 214109 | 2020-06-06 | Onslow | North Carolina | 37133 | 121 | 2 |
217199 | 217199 | 2020-06-07 | Onslow | North Carolina | 37133 | 134 | 2 |
220291 | 220291 | 2020-06-08 | Onslow | North Carolina | 37133 | 134 | 2 |
223385 | 223385 | 2020-06-09 | Onslow | North Carolina | 37133 | 136 | 2 |
226485 | 226485 | 2020-06-10 | Onslow | North Carolina | 37133 | 136 | 2 |
229589 | 229589 | 2020-06-11 | Onslow | North Carolina | 37133 | 145 | 2 |
232694 | 232694 | 2020-06-12 | Onslow | North Carolina | 37133 | 149 | 2 |
235799 | 235799 | 2020-06-13 | Onslow | North Carolina | 37133 | 156 | 3 |
238907 | 238907 | 2020-06-14 | Onslow | North Carolina | 37133 | 159 | 3 |
242016 | 242016 | 2020-06-15 | Onslow | North Carolina | 37133 | 160 | 3 |
245128 | 245128 | 2020-06-16 | Onslow | North Carolina | 37133 | 166 | 3 |
248241 | 248241 | 2020-06-17 | Onslow | North Carolina | 37133 | 178 | 3 |
251356 | 251356 | 2020-06-18 | Onslow | North Carolina | 37133 | 180 | 3 |
254471 | 254471 | 2020-06-19 | Onslow | North Carolina | 37133 | 188 | 3 |
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);