ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "Jones" and state = "North Carolina" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
44809 | 44809 | 2020-04-09 | Jones | North Carolina | 37103 | 3 | 0 |
47422 | 47422 | 2020-04-10 | Jones | North Carolina | 37103 | 3 | 0 |
50077 | 50077 | 2020-04-11 | Jones | North Carolina | 37103 | 6 | 1 |
52750 | 52750 | 2020-04-12 | Jones | North Carolina | 37103 | 7 | 1 |
55434 | 55434 | 2020-04-13 | Jones | North Carolina | 37103 | 7 | 1 |
58134 | 58134 | 2020-04-14 | Jones | North Carolina | 37103 | 7 | 1 |
60848 | 60848 | 2020-04-15 | Jones | North Carolina | 37103 | 8 | 1 |
63574 | 63574 | 2020-04-16 | Jones | North Carolina | 37103 | 8 | 1 |
66317 | 66317 | 2020-04-17 | Jones | North Carolina | 37103 | 8 | 1 |
69074 | 69074 | 2020-04-18 | Jones | North Carolina | 37103 | 8 | 1 |
71840 | 71840 | 2020-04-19 | Jones | North Carolina | 37103 | 8 | 1 |
74615 | 74615 | 2020-04-20 | Jones | North Carolina | 37103 | 8 | 1 |
77396 | 77396 | 2020-04-21 | Jones | North Carolina | 37103 | 9 | 1 |
80185 | 80185 | 2020-04-22 | Jones | North Carolina | 37103 | 9 | 2 |
82984 | 82984 | 2020-04-23 | Jones | North Carolina | 37103 | 9 | 2 |
85788 | 85788 | 2020-04-24 | Jones | North Carolina | 37103 | 9 | 2 |
88600 | 88600 | 2020-04-25 | Jones | North Carolina | 37103 | 11 | 2 |
91415 | 91415 | 2020-04-26 | Jones | North Carolina | 37103 | 11 | 2 |
94241 | 94241 | 2020-04-27 | Jones | North Carolina | 37103 | 12 | 2 |
97078 | 97078 | 2020-04-28 | Jones | North Carolina | 37103 | 12 | 2 |
99926 | 99926 | 2020-04-29 | Jones | North Carolina | 37103 | 12 | 2 |
102779 | 102779 | 2020-04-30 | Jones | North Carolina | 37103 | 14 | 2 |
105641 | 105641 | 2020-05-01 | Jones | North Carolina | 37103 | 15 | 2 |
108508 | 108508 | 2020-05-02 | Jones | North Carolina | 37103 | 17 | 2 |
111381 | 111381 | 2020-05-03 | Jones | North Carolina | 37103 | 18 | 2 |
114262 | 114262 | 2020-05-04 | Jones | North Carolina | 37103 | 18 | 2 |
117142 | 117142 | 2020-05-05 | Jones | North Carolina | 37103 | 18 | 2 |
120103 | 120103 | 2020-05-06 | Jones | North Carolina | 37103 | 19 | 2 |
123078 | 123078 | 2020-05-07 | Jones | North Carolina | 37103 | 19 | 2 |
126061 | 126061 | 2020-05-08 | Jones | North Carolina | 37103 | 18 | 2 |
129050 | 129050 | 2020-05-09 | Jones | North Carolina | 37103 | 18 | 2 |
132039 | 132039 | 2020-05-10 | Jones | North Carolina | 37103 | 18 | 2 |
135030 | 135030 | 2020-05-11 | Jones | North Carolina | 37103 | 20 | 2 |
138020 | 138020 | 2020-05-12 | Jones | North Carolina | 37103 | 19 | 2 |
141016 | 141016 | 2020-05-13 | Jones | North Carolina | 37103 | 20 | 2 |
144011 | 144011 | 2020-05-14 | Jones | North Carolina | 37103 | 21 | 2 |
147012 | 147012 | 2020-05-15 | Jones | North Carolina | 37103 | 21 | 2 |
150019 | 150019 | 2020-05-16 | Jones | North Carolina | 37103 | 21 | 2 |
153029 | 153029 | 2020-05-17 | Jones | North Carolina | 37103 | 21 | 2 |
156046 | 156046 | 2020-05-18 | Jones | North Carolina | 37103 | 23 | 2 |
159065 | 159065 | 2020-05-19 | Jones | North Carolina | 37103 | 22 | 2 |
162092 | 162092 | 2020-05-20 | Jones | North Carolina | 37103 | 22 | 2 |
165121 | 165121 | 2020-05-21 | Jones | North Carolina | 37103 | 22 | 2 |
168156 | 168156 | 2020-05-22 | Jones | North Carolina | 37103 | 26 | 2 |
171195 | 171195 | 2020-05-23 | Jones | North Carolina | 37103 | 28 | 2 |
174237 | 174237 | 2020-05-24 | Jones | North Carolina | 37103 | 26 | 2 |
177281 | 177281 | 2020-05-25 | Jones | North Carolina | 37103 | 26 | 2 |
180324 | 180324 | 2020-05-26 | Jones | North Carolina | 37103 | 26 | 2 |
183372 | 183372 | 2020-05-27 | Jones | North Carolina | 37103 | 26 | 3 |
186429 | 186429 | 2020-05-28 | Jones | North Carolina | 37103 | 26 | 3 |
189489 | 189489 | 2020-05-29 | Jones | North Carolina | 37103 | 26 | 3 |
192553 | 192553 | 2020-05-30 | Jones | North Carolina | 37103 | 26 | 3 |
195623 | 195623 | 2020-05-31 | Jones | North Carolina | 37103 | 26 | 3 |
198696 | 198696 | 2020-06-01 | Jones | North Carolina | 37103 | 26 | 3 |
201770 | 201770 | 2020-06-02 | Jones | North Carolina | 37103 | 26 | 3 |
204847 | 204847 | 2020-06-03 | Jones | North Carolina | 37103 | 26 | 3 |
207928 | 207928 | 2020-06-04 | Jones | North Carolina | 37103 | 26 | 3 |
211010 | 211010 | 2020-06-05 | Jones | North Carolina | 37103 | 26 | 3 |
214094 | 214094 | 2020-06-06 | Jones | North Carolina | 37103 | 26 | 3 |
217184 | 217184 | 2020-06-07 | Jones | North Carolina | 37103 | 26 | 3 |
220276 | 220276 | 2020-06-08 | Jones | North Carolina | 37103 | 26 | 3 |
223370 | 223370 | 2020-06-09 | Jones | North Carolina | 37103 | 26 | 3 |
226470 | 226470 | 2020-06-10 | Jones | North Carolina | 37103 | 26 | 3 |
229574 | 229574 | 2020-06-11 | Jones | North Carolina | 37103 | 26 | 3 |
232679 | 232679 | 2020-06-12 | Jones | North Carolina | 37103 | 26 | 3 |
235784 | 235784 | 2020-06-13 | Jones | North Carolina | 37103 | 26 | 3 |
238892 | 238892 | 2020-06-14 | Jones | North Carolina | 37103 | 27 | 3 |
242001 | 242001 | 2020-06-15 | Jones | North Carolina | 37103 | 27 | 3 |
245113 | 245113 | 2020-06-16 | Jones | North Carolina | 37103 | 26 | 3 |
248226 | 248226 | 2020-06-17 | Jones | North Carolina | 37103 | 26 | 3 |
251341 | 251341 | 2020-06-18 | Jones | North Carolina | 37103 | 26 | 3 |
254456 | 254456 | 2020-06-19 | Jones | North Carolina | 37103 | 26 | 3 |
257579 | 257579 | 2020-06-20 | Jones | North Carolina | 37103 | 26 | 3 |
260706 | 260706 | 2020-06-21 | Jones | North Carolina | 37103 | 28 | 3 |
263834 | 263834 | 2020-06-22 | Jones | North Carolina | 37103 | 28 | 3 |
266962 | 266962 | 2020-06-23 | Jones | North Carolina | 37103 | 29 | 3 |
270096 | 270096 | 2020-06-24 | Jones | North Carolina | 37103 | 29 | 3 |
273235 | 273235 | 2020-06-25 | Jones | North Carolina | 37103 | 29 | 3 |
276381 | 276381 | 2020-06-26 | Jones | North Carolina | 37103 | 32 | 3 |
279529 | 279529 | 2020-06-27 | Jones | North Carolina | 37103 | 32 | 3 |
282675 | 282675 | 2020-06-28 | Jones | North Carolina | 37103 | 35 | 3 |
285820 | 285820 | 2020-06-29 | Jones | North Carolina | 37103 | 35 | 3 |
288970 | 288970 | 2020-06-30 | Jones | North Carolina | 37103 | 35 | 3 |
292122 | 292122 | 2020-07-01 | Jones | North Carolina | 37103 | 35 | 3 |
295277 | 295277 | 2020-07-02 | Jones | North Carolina | 37103 | 35 | 3 |
298437 | 298437 | 2020-07-03 | Jones | North Carolina | 37103 | 36 | 3 |
301600 | 301600 | 2020-07-04 | Jones | North Carolina | 37103 | 36 | 3 |
304763 | 304763 | 2020-07-05 | Jones | North Carolina | 37103 | 36 | 3 |
307930 | 307930 | 2020-07-06 | Jones | North Carolina | 37103 | 38 | 3 |
311098 | 311098 | 2020-07-07 | Jones | North Carolina | 37103 | 39 | 3 |
314269 | 314269 | 2020-07-08 | Jones | North Carolina | 37103 | 37 | 3 |
317443 | 317443 | 2020-07-09 | Jones | North Carolina | 37103 | 38 | 3 |
320620 | 320620 | 2020-07-10 | Jones | North Carolina | 37103 | 37 | 3 |
323800 | 323800 | 2020-07-11 | Jones | North Carolina | 37103 | 39 | 3 |
326984 | 326984 | 2020-07-12 | Jones | North Carolina | 37103 | 43 | 3 |
330171 | 330171 | 2020-07-13 | Jones | North Carolina | 37103 | 43 | 3 |
333361 | 333361 | 2020-07-14 | Jones | North Carolina | 37103 | 39 | 3 |
336555 | 336555 | 2020-07-15 | Jones | North Carolina | 37103 | 39 | 3 |
339751 | 339751 | 2020-07-16 | Jones | North Carolina | 37103 | 41 | 3 |
342949 | 342949 | 2020-07-17 | Jones | North Carolina | 37103 | 42 | 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);