ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where county = "Jones", deaths = 3 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
410394 | 410394 | 2020-08-07 | Jones | North Carolina | 37103 | 78 | 3 |
407174 | 407174 | 2020-08-06 | Jones | North Carolina | 37103 | 79 | 3 |
403955 | 403955 | 2020-08-05 | Jones | North Carolina | 37103 | 79 | 3 |
400737 | 400737 | 2020-08-04 | Jones | North Carolina | 37103 | 78 | 3 |
397522 | 397522 | 2020-08-03 | Jones | North Carolina | 37103 | 74 | 3 |
394305 | 394305 | 2020-08-02 | Jones | North Carolina | 37103 | 59 | 3 |
391089 | 391089 | 2020-08-01 | Jones | North Carolina | 37103 | 57 | 3 |
387872 | 387872 | 2020-07-31 | Jones | North Carolina | 37103 | 58 | 3 |
384655 | 384655 | 2020-07-30 | Jones | North Carolina | 37103 | 55 | 3 |
381437 | 381437 | 2020-07-29 | Jones | North Carolina | 37103 | 54 | 3 |
378220 | 378220 | 2020-07-28 | Jones | North Carolina | 37103 | 50 | 3 |
375004 | 375004 | 2020-07-27 | Jones | North Carolina | 37103 | 46 | 3 |
371792 | 371792 | 2020-07-26 | Jones | North Carolina | 37103 | 46 | 3 |
368580 | 368580 | 2020-07-25 | Jones | North Carolina | 37103 | 45 | 3 |
365371 | 365371 | 2020-07-24 | Jones | North Carolina | 37103 | 46 | 3 |
362165 | 362165 | 2020-07-23 | Jones | North Carolina | 37103 | 44 | 3 |
358959 | 358959 | 2020-07-22 | Jones | North Carolina | 37103 | 44 | 3 |
355755 | 355755 | 2020-07-21 | Jones | North Carolina | 37103 | 43 | 3 |
352552 | 352552 | 2020-07-20 | Jones | North Carolina | 37103 | 43 | 3 |
349349 | 349349 | 2020-07-19 | Jones | North Carolina | 37103 | 43 | 3 |
346148 | 346148 | 2020-07-18 | Jones | North Carolina | 37103 | 42 | 3 |
342949 | 342949 | 2020-07-17 | Jones | North Carolina | 37103 | 42 | 3 |
339751 | 339751 | 2020-07-16 | Jones | North Carolina | 37103 | 41 | 3 |
336555 | 336555 | 2020-07-15 | Jones | North Carolina | 37103 | 39 | 3 |
333361 | 333361 | 2020-07-14 | Jones | North Carolina | 37103 | 39 | 3 |
330171 | 330171 | 2020-07-13 | Jones | North Carolina | 37103 | 43 | 3 |
326984 | 326984 | 2020-07-12 | Jones | North Carolina | 37103 | 43 | 3 |
323800 | 323800 | 2020-07-11 | Jones | North Carolina | 37103 | 39 | 3 |
320620 | 320620 | 2020-07-10 | Jones | North Carolina | 37103 | 37 | 3 |
317443 | 317443 | 2020-07-09 | Jones | North Carolina | 37103 | 38 | 3 |
314269 | 314269 | 2020-07-08 | Jones | North Carolina | 37103 | 37 | 3 |
311098 | 311098 | 2020-07-07 | Jones | North Carolina | 37103 | 39 | 3 |
307930 | 307930 | 2020-07-06 | Jones | North Carolina | 37103 | 38 | 3 |
304763 | 304763 | 2020-07-05 | Jones | North Carolina | 37103 | 36 | 3 |
301600 | 301600 | 2020-07-04 | Jones | North Carolina | 37103 | 36 | 3 |
298437 | 298437 | 2020-07-03 | Jones | North Carolina | 37103 | 36 | 3 |
295277 | 295277 | 2020-07-02 | Jones | North Carolina | 37103 | 35 | 3 |
292122 | 292122 | 2020-07-01 | Jones | North Carolina | 37103 | 35 | 3 |
288970 | 288970 | 2020-06-30 | Jones | North Carolina | 37103 | 35 | 3 |
285820 | 285820 | 2020-06-29 | Jones | North Carolina | 37103 | 35 | 3 |
282675 | 282675 | 2020-06-28 | Jones | North Carolina | 37103 | 35 | 3 |
279529 | 279529 | 2020-06-27 | Jones | North Carolina | 37103 | 32 | 3 |
276381 | 276381 | 2020-06-26 | Jones | North Carolina | 37103 | 32 | 3 |
273235 | 273235 | 2020-06-25 | Jones | North Carolina | 37103 | 29 | 3 |
270096 | 270096 | 2020-06-24 | Jones | North Carolina | 37103 | 29 | 3 |
266962 | 266962 | 2020-06-23 | Jones | North Carolina | 37103 | 29 | 3 |
263834 | 263834 | 2020-06-22 | Jones | North Carolina | 37103 | 28 | 3 |
260706 | 260706 | 2020-06-21 | Jones | North Carolina | 37103 | 28 | 3 |
257579 | 257579 | 2020-06-20 | Jones | North Carolina | 37103 | 26 | 3 |
254456 | 254456 | 2020-06-19 | Jones | North Carolina | 37103 | 26 | 3 |
251341 | 251341 | 2020-06-18 | Jones | North Carolina | 37103 | 26 | 3 |
248226 | 248226 | 2020-06-17 | Jones | North Carolina | 37103 | 26 | 3 |
245113 | 245113 | 2020-06-16 | Jones | North Carolina | 37103 | 26 | 3 |
242001 | 242001 | 2020-06-15 | Jones | North Carolina | 37103 | 27 | 3 |
238892 | 238892 | 2020-06-14 | Jones | North Carolina | 37103 | 27 | 3 |
235784 | 235784 | 2020-06-13 | Jones | North Carolina | 37103 | 26 | 3 |
232679 | 232679 | 2020-06-12 | Jones | North Carolina | 37103 | 26 | 3 |
229574 | 229574 | 2020-06-11 | Jones | North Carolina | 37103 | 26 | 3 |
226470 | 226470 | 2020-06-10 | Jones | North Carolina | 37103 | 26 | 3 |
223370 | 223370 | 2020-06-09 | Jones | North Carolina | 37103 | 26 | 3 |
220276 | 220276 | 2020-06-08 | Jones | North Carolina | 37103 | 26 | 3 |
217184 | 217184 | 2020-06-07 | Jones | North Carolina | 37103 | 26 | 3 |
214094 | 214094 | 2020-06-06 | Jones | North Carolina | 37103 | 26 | 3 |
211010 | 211010 | 2020-06-05 | Jones | North Carolina | 37103 | 26 | 3 |
207928 | 207928 | 2020-06-04 | Jones | North Carolina | 37103 | 26 | 3 |
204847 | 204847 | 2020-06-03 | Jones | North Carolina | 37103 | 26 | 3 |
201770 | 201770 | 2020-06-02 | Jones | North Carolina | 37103 | 26 | 3 |
198696 | 198696 | 2020-06-01 | Jones | North Carolina | 37103 | 26 | 3 |
195623 | 195623 | 2020-05-31 | Jones | North Carolina | 37103 | 26 | 3 |
192553 | 192553 | 2020-05-30 | Jones | North Carolina | 37103 | 26 | 3 |
189489 | 189489 | 2020-05-29 | Jones | North Carolina | 37103 | 26 | 3 |
186429 | 186429 | 2020-05-28 | Jones | North Carolina | 37103 | 26 | 3 |
183372 | 183372 | 2020-05-27 | Jones | North Carolina | 37103 | 26 | 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);