ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Pasquotank" and state = "North Carolina" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5772 | 5772 | 2020-03-20 | Pasquotank | North Carolina | 37139 | 1 | 0 |
6769 | 6769 | 2020-03-21 | Pasquotank | North Carolina | 37139 | 1 | 0 |
7872 | 7872 | 2020-03-22 | Pasquotank | North Carolina | 37139 | 1 | 0 |
9073 | 9073 | 2020-03-23 | Pasquotank | North Carolina | 37139 | 1 | 0 |
10382 | 10382 | 2020-03-24 | Pasquotank | North Carolina | 37139 | 1 | 0 |
11827 | 11827 | 2020-03-25 | Pasquotank | North Carolina | 37139 | 1 | 0 |
13431 | 13431 | 2020-03-26 | Pasquotank | North Carolina | 37139 | 1 | 0 |
15166 | 15166 | 2020-03-27 | Pasquotank | North Carolina | 37139 | 1 | 0 |
16998 | 16998 | 2020-03-28 | Pasquotank | North Carolina | 37139 | 1 | 0 |
18930 | 18930 | 2020-03-29 | Pasquotank | North Carolina | 37139 | 2 | 0 |
20970 | 20970 | 2020-03-30 | Pasquotank | North Carolina | 37139 | 2 | 0 |
23097 | 23097 | 2020-03-31 | Pasquotank | North Carolina | 37139 | 4 | 0 |
25291 | 25291 | 2020-04-01 | Pasquotank | North Carolina | 37139 | 4 | 0 |
27556 | 27556 | 2020-04-02 | Pasquotank | North Carolina | 37139 | 7 | 0 |
29883 | 29883 | 2020-04-03 | Pasquotank | North Carolina | 37139 | 7 | 0 |
32270 | 32270 | 2020-04-04 | Pasquotank | North Carolina | 37139 | 8 | 0 |
34701 | 34701 | 2020-04-05 | Pasquotank | North Carolina | 37139 | 8 | 0 |
37170 | 37170 | 2020-04-06 | Pasquotank | North Carolina | 37139 | 8 | 0 |
39685 | 39685 | 2020-04-07 | Pasquotank | North Carolina | 37139 | 9 | 0 |
42242 | 42242 | 2020-04-08 | Pasquotank | North Carolina | 37139 | 10 | 0 |
44826 | 44826 | 2020-04-09 | Pasquotank | North Carolina | 37139 | 10 | 0 |
47439 | 47439 | 2020-04-10 | Pasquotank | North Carolina | 37139 | 11 | 0 |
50094 | 50094 | 2020-04-11 | Pasquotank | North Carolina | 37139 | 15 | 0 |
52767 | 52767 | 2020-04-12 | Pasquotank | North Carolina | 37139 | 15 | 0 |
55451 | 55451 | 2020-04-13 | Pasquotank | North Carolina | 37139 | 15 | 0 |
58151 | 58151 | 2020-04-14 | Pasquotank | North Carolina | 37139 | 15 | 0 |
60865 | 60865 | 2020-04-15 | Pasquotank | North Carolina | 37139 | 15 | 0 |
63591 | 63591 | 2020-04-16 | Pasquotank | North Carolina | 37139 | 16 | 0 |
66334 | 66334 | 2020-04-17 | Pasquotank | North Carolina | 37139 | 20 | 0 |
69091 | 69091 | 2020-04-18 | Pasquotank | North Carolina | 37139 | 20 | 0 |
71857 | 71857 | 2020-04-19 | Pasquotank | North Carolina | 37139 | 20 | 0 |
74632 | 74632 | 2020-04-20 | Pasquotank | North Carolina | 37139 | 32 | 0 |
77413 | 77413 | 2020-04-21 | Pasquotank | North Carolina | 37139 | 32 | 1 |
80202 | 80202 | 2020-04-22 | Pasquotank | North Carolina | 37139 | 32 | 1 |
83001 | 83001 | 2020-04-23 | Pasquotank | North Carolina | 37139 | 33 | 1 |
85805 | 85805 | 2020-04-24 | Pasquotank | North Carolina | 37139 | 34 | 1 |
88618 | 88618 | 2020-04-25 | Pasquotank | North Carolina | 37139 | 34 | 1 |
91433 | 91433 | 2020-04-26 | Pasquotank | North Carolina | 37139 | 34 | 1 |
94259 | 94259 | 2020-04-27 | Pasquotank | North Carolina | 37139 | 34 | 1 |
97096 | 97096 | 2020-04-28 | Pasquotank | North Carolina | 37139 | 35 | 1 |
99944 | 99944 | 2020-04-29 | Pasquotank | North Carolina | 37139 | 36 | 1 |
102797 | 102797 | 2020-04-30 | Pasquotank | North Carolina | 37139 | 36 | 1 |
105659 | 105659 | 2020-05-01 | Pasquotank | North Carolina | 37139 | 36 | 1 |
108526 | 108526 | 2020-05-02 | Pasquotank | North Carolina | 37139 | 36 | 1 |
111399 | 111399 | 2020-05-03 | Pasquotank | North Carolina | 37139 | 37 | 1 |
114280 | 114280 | 2020-05-04 | Pasquotank | North Carolina | 37139 | 37 | 1 |
117160 | 117160 | 2020-05-05 | Pasquotank | North Carolina | 37139 | 38 | 1 |
120121 | 120121 | 2020-05-06 | Pasquotank | North Carolina | 37139 | 38 | 2 |
123096 | 123096 | 2020-05-07 | Pasquotank | North Carolina | 37139 | 39 | 2 |
126079 | 126079 | 2020-05-08 | Pasquotank | North Carolina | 37139 | 75 | 3 |
129068 | 129068 | 2020-05-09 | Pasquotank | North Carolina | 37139 | 81 | 3 |
132057 | 132057 | 2020-05-10 | Pasquotank | North Carolina | 37139 | 82 | 3 |
135048 | 135048 | 2020-05-11 | Pasquotank | North Carolina | 37139 | 81 | 3 |
138038 | 138038 | 2020-05-12 | Pasquotank | North Carolina | 37139 | 81 | 5 |
141034 | 141034 | 2020-05-13 | Pasquotank | North Carolina | 37139 | 81 | 5 |
144029 | 144029 | 2020-05-14 | Pasquotank | North Carolina | 37139 | 80 | 5 |
147030 | 147030 | 2020-05-15 | Pasquotank | North Carolina | 37139 | 83 | 5 |
150037 | 150037 | 2020-05-16 | Pasquotank | North Carolina | 37139 | 87 | 5 |
153047 | 153047 | 2020-05-17 | Pasquotank | North Carolina | 37139 | 88 | 7 |
156064 | 156064 | 2020-05-18 | Pasquotank | North Carolina | 37139 | 87 | 7 |
159083 | 159083 | 2020-05-19 | Pasquotank | North Carolina | 37139 | 87 | 7 |
162110 | 162110 | 2020-05-20 | Pasquotank | North Carolina | 37139 | 90 | 7 |
165139 | 165139 | 2020-05-21 | Pasquotank | North Carolina | 37139 | 93 | 7 |
168174 | 168174 | 2020-05-22 | Pasquotank | North Carolina | 37139 | 95 | 8 |
171213 | 171213 | 2020-05-23 | Pasquotank | North Carolina | 37139 | 95 | 8 |
174255 | 174255 | 2020-05-24 | Pasquotank | North Carolina | 37139 | 96 | 8 |
177299 | 177299 | 2020-05-25 | Pasquotank | North Carolina | 37139 | 96 | 8 |
180342 | 180342 | 2020-05-26 | Pasquotank | North Carolina | 37139 | 96 | 8 |
183390 | 183390 | 2020-05-27 | Pasquotank | North Carolina | 37139 | 100 | 9 |
186447 | 186447 | 2020-05-28 | Pasquotank | North Carolina | 37139 | 102 | 9 |
189507 | 189507 | 2020-05-29 | Pasquotank | North Carolina | 37139 | 104 | 10 |
192571 | 192571 | 2020-05-30 | Pasquotank | North Carolina | 37139 | 105 | 11 |
195641 | 195641 | 2020-05-31 | Pasquotank | North Carolina | 37139 | 105 | 11 |
198714 | 198714 | 2020-06-01 | Pasquotank | North Carolina | 37139 | 105 | 12 |
201788 | 201788 | 2020-06-02 | Pasquotank | North Carolina | 37139 | 110 | 12 |
204865 | 204865 | 2020-06-03 | Pasquotank | North Carolina | 37139 | 112 | 12 |
207946 | 207946 | 2020-06-04 | Pasquotank | North Carolina | 37139 | 115 | 12 |
211028 | 211028 | 2020-06-05 | Pasquotank | North Carolina | 37139 | 117 | 13 |
214112 | 214112 | 2020-06-06 | Pasquotank | North Carolina | 37139 | 119 | 13 |
217202 | 217202 | 2020-06-07 | Pasquotank | North Carolina | 37139 | 117 | 13 |
220294 | 220294 | 2020-06-08 | Pasquotank | North Carolina | 37139 | 114 | 13 |
223388 | 223388 | 2020-06-09 | Pasquotank | North Carolina | 37139 | 115 | 13 |
226488 | 226488 | 2020-06-10 | Pasquotank | North Carolina | 37139 | 120 | 14 |
229592 | 229592 | 2020-06-11 | Pasquotank | North Carolina | 37139 | 125 | 14 |
232697 | 232697 | 2020-06-12 | Pasquotank | North Carolina | 37139 | 128 | 14 |
235802 | 235802 | 2020-06-13 | Pasquotank | North Carolina | 37139 | 131 | 14 |
238910 | 238910 | 2020-06-14 | Pasquotank | North Carolina | 37139 | 131 | 14 |
242019 | 242019 | 2020-06-15 | Pasquotank | North Carolina | 37139 | 131 | 14 |
245131 | 245131 | 2020-06-16 | Pasquotank | North Carolina | 37139 | 131 | 14 |
248244 | 248244 | 2020-06-17 | Pasquotank | North Carolina | 37139 | 147 | 15 |
251359 | 251359 | 2020-06-18 | Pasquotank | North Carolina | 37139 | 152 | 15 |
254474 | 254474 | 2020-06-19 | Pasquotank | North Carolina | 37139 | 153 | 15 |
257597 | 257597 | 2020-06-20 | Pasquotank | North Carolina | 37139 | 155 | 15 |
260724 | 260724 | 2020-06-21 | Pasquotank | North Carolina | 37139 | 163 | 15 |
263852 | 263852 | 2020-06-22 | Pasquotank | North Carolina | 37139 | 164 | 15 |
266980 | 266980 | 2020-06-23 | Pasquotank | North Carolina | 37139 | 168 | 15 |
270114 | 270114 | 2020-06-24 | Pasquotank | North Carolina | 37139 | 172 | 15 |
273253 | 273253 | 2020-06-25 | Pasquotank | North Carolina | 37139 | 172 | 15 |
276399 | 276399 | 2020-06-26 | Pasquotank | North Carolina | 37139 | 180 | 15 |
279547 | 279547 | 2020-06-27 | Pasquotank | North Carolina | 37139 | 198 | 15 |
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);