ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Orleans" and state = "Vermont" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537327 | 537327 | 2020-09-15 | Orleans | Vermont | 50019 | 22 | 0 |
534091 | 534091 | 2020-09-14 | Orleans | Vermont | 50019 | 22 | 0 |
530856 | 530856 | 2020-09-13 | Orleans | Vermont | 50019 | 22 | 0 |
527619 | 527619 | 2020-09-12 | Orleans | Vermont | 50019 | 22 | 0 |
524383 | 524383 | 2020-09-11 | Orleans | Vermont | 50019 | 22 | 0 |
521147 | 521147 | 2020-09-10 | Orleans | Vermont | 50019 | 22 | 0 |
517910 | 517910 | 2020-09-09 | Orleans | Vermont | 50019 | 18 | 0 |
514675 | 514675 | 2020-09-08 | Orleans | Vermont | 50019 | 18 | 0 |
511442 | 511442 | 2020-09-07 | Orleans | Vermont | 50019 | 17 | 0 |
508209 | 508209 | 2020-09-06 | Orleans | Vermont | 50019 | 17 | 0 |
504977 | 504977 | 2020-09-05 | Orleans | Vermont | 50019 | 16 | 0 |
501743 | 501743 | 2020-09-04 | Orleans | Vermont | 50019 | 15 | 0 |
498509 | 498509 | 2020-09-03 | Orleans | Vermont | 50019 | 15 | 0 |
495276 | 495276 | 2020-09-02 | Orleans | Vermont | 50019 | 15 | 0 |
492042 | 492042 | 2020-09-01 | Orleans | Vermont | 50019 | 15 | 0 |
488809 | 488809 | 2020-08-31 | Orleans | Vermont | 50019 | 15 | 0 |
485576 | 485576 | 2020-08-30 | Orleans | Vermont | 50019 | 15 | 0 |
482341 | 482341 | 2020-08-29 | Orleans | Vermont | 50019 | 15 | 0 |
479107 | 479107 | 2020-08-28 | Orleans | Vermont | 50019 | 15 | 0 |
475874 | 475874 | 2020-08-27 | Orleans | Vermont | 50019 | 15 | 0 |
472641 | 472641 | 2020-08-26 | Orleans | Vermont | 50019 | 15 | 0 |
469409 | 469409 | 2020-08-25 | Orleans | Vermont | 50019 | 15 | 0 |
466180 | 466180 | 2020-08-24 | Orleans | Vermont | 50019 | 15 | 0 |
462951 | 462951 | 2020-08-23 | Orleans | Vermont | 50019 | 15 | 0 |
459722 | 459722 | 2020-08-22 | Orleans | Vermont | 50019 | 15 | 0 |
456495 | 456495 | 2020-08-21 | Orleans | Vermont | 50019 | 15 | 0 |
453267 | 453267 | 2020-08-20 | Orleans | Vermont | 50019 | 15 | 0 |
450039 | 450039 | 2020-08-19 | Orleans | Vermont | 50019 | 15 | 0 |
446811 | 446811 | 2020-08-18 | Orleans | Vermont | 50019 | 15 | 0 |
443584 | 443584 | 2020-08-17 | Orleans | Vermont | 50019 | 15 | 0 |
440358 | 440358 | 2020-08-16 | Orleans | Vermont | 50019 | 15 | 0 |
437132 | 437132 | 2020-08-15 | Orleans | Vermont | 50019 | 15 | 0 |
433906 | 433906 | 2020-08-14 | Orleans | Vermont | 50019 | 15 | 0 |
430681 | 430681 | 2020-08-13 | Orleans | Vermont | 50019 | 14 | 0 |
427453 | 427453 | 2020-08-12 | Orleans | Vermont | 50019 | 14 | 0 |
424229 | 424229 | 2020-08-11 | Orleans | Vermont | 50019 | 14 | 0 |
421008 | 421008 | 2020-08-10 | Orleans | Vermont | 50019 | 14 | 0 |
417787 | 417787 | 2020-08-09 | Orleans | Vermont | 50019 | 14 | 0 |
414566 | 414566 | 2020-08-08 | Orleans | Vermont | 50019 | 14 | 0 |
411346 | 411346 | 2020-08-07 | Orleans | Vermont | 50019 | 14 | 0 |
408127 | 408127 | 2020-08-06 | Orleans | Vermont | 50019 | 14 | 0 |
404907 | 404907 | 2020-08-05 | Orleans | Vermont | 50019 | 14 | 0 |
401689 | 401689 | 2020-08-04 | Orleans | Vermont | 50019 | 14 | 0 |
398473 | 398473 | 2020-08-03 | Orleans | Vermont | 50019 | 14 | 0 |
395257 | 395257 | 2020-08-02 | Orleans | Vermont | 50019 | 14 | 0 |
392041 | 392041 | 2020-08-01 | Orleans | Vermont | 50019 | 14 | 0 |
388824 | 388824 | 2020-07-31 | Orleans | Vermont | 50019 | 14 | 0 |
385607 | 385607 | 2020-07-30 | Orleans | Vermont | 50019 | 14 | 0 |
382389 | 382389 | 2020-07-29 | Orleans | Vermont | 50019 | 14 | 0 |
379172 | 379172 | 2020-07-28 | Orleans | Vermont | 50019 | 14 | 0 |
375956 | 375956 | 2020-07-27 | Orleans | Vermont | 50019 | 14 | 0 |
372742 | 372742 | 2020-07-26 | Orleans | Vermont | 50019 | 14 | 0 |
369530 | 369530 | 2020-07-25 | Orleans | Vermont | 50019 | 14 | 0 |
366321 | 366321 | 2020-07-24 | Orleans | Vermont | 50019 | 14 | 0 |
363115 | 363115 | 2020-07-23 | Orleans | Vermont | 50019 | 14 | 0 |
359908 | 359908 | 2020-07-22 | Orleans | Vermont | 50019 | 14 | 0 |
356703 | 356703 | 2020-07-21 | Orleans | Vermont | 50019 | 14 | 0 |
353500 | 353500 | 2020-07-20 | Orleans | Vermont | 50019 | 14 | 0 |
350298 | 350298 | 2020-07-19 | Orleans | Vermont | 50019 | 14 | 0 |
347097 | 347097 | 2020-07-18 | Orleans | Vermont | 50019 | 14 | 0 |
343897 | 343897 | 2020-07-17 | Orleans | Vermont | 50019 | 14 | 0 |
340698 | 340698 | 2020-07-16 | Orleans | Vermont | 50019 | 14 | 0 |
337502 | 337502 | 2020-07-15 | Orleans | Vermont | 50019 | 14 | 0 |
334307 | 334307 | 2020-07-14 | Orleans | Vermont | 50019 | 14 | 0 |
331114 | 331114 | 2020-07-13 | Orleans | Vermont | 50019 | 14 | 0 |
327928 | 327928 | 2020-07-12 | Orleans | Vermont | 50019 | 14 | 0 |
324743 | 324743 | 2020-07-11 | Orleans | Vermont | 50019 | 14 | 0 |
321562 | 321562 | 2020-07-10 | Orleans | Vermont | 50019 | 14 | 0 |
318383 | 318383 | 2020-07-09 | Orleans | Vermont | 50019 | 14 | 0 |
315210 | 315210 | 2020-07-08 | Orleans | Vermont | 50019 | 14 | 0 |
312036 | 312036 | 2020-07-07 | Orleans | Vermont | 50019 | 14 | 0 |
308867 | 308867 | 2020-07-06 | Orleans | Vermont | 50019 | 14 | 0 |
305699 | 305699 | 2020-07-05 | Orleans | Vermont | 50019 | 14 | 0 |
302535 | 302535 | 2020-07-04 | Orleans | Vermont | 50019 | 14 | 0 |
299371 | 299371 | 2020-07-03 | Orleans | Vermont | 50019 | 14 | 0 |
296209 | 296209 | 2020-07-02 | Orleans | Vermont | 50019 | 14 | 0 |
293054 | 293054 | 2020-07-01 | Orleans | Vermont | 50019 | 14 | 0 |
289901 | 289901 | 2020-06-30 | Orleans | Vermont | 50019 | 14 | 0 |
286751 | 286751 | 2020-06-29 | Orleans | Vermont | 50019 | 14 | 0 |
283605 | 283605 | 2020-06-28 | Orleans | Vermont | 50019 | 14 | 0 |
280459 | 280459 | 2020-06-27 | Orleans | Vermont | 50019 | 14 | 0 |
277311 | 277311 | 2020-06-26 | Orleans | Vermont | 50019 | 14 | 0 |
274163 | 274163 | 2020-06-25 | Orleans | Vermont | 50019 | 14 | 0 |
271023 | 271023 | 2020-06-24 | Orleans | Vermont | 50019 | 14 | 0 |
267889 | 267889 | 2020-06-23 | Orleans | Vermont | 50019 | 14 | 0 |
264760 | 264760 | 2020-06-22 | Orleans | Vermont | 50019 | 14 | 0 |
261631 | 261631 | 2020-06-21 | Orleans | Vermont | 50019 | 14 | 0 |
258504 | 258504 | 2020-06-20 | Orleans | Vermont | 50019 | 14 | 0 |
255377 | 255377 | 2020-06-19 | Orleans | Vermont | 50019 | 14 | 0 |
252259 | 252259 | 2020-06-18 | Orleans | Vermont | 50019 | 13 | 0 |
249144 | 249144 | 2020-06-17 | Orleans | Vermont | 50019 | 13 | 0 |
246032 | 246032 | 2020-06-16 | Orleans | Vermont | 50019 | 13 | 0 |
242920 | 242920 | 2020-06-15 | Orleans | Vermont | 50019 | 13 | 0 |
239809 | 239809 | 2020-06-14 | Orleans | Vermont | 50019 | 13 | 0 |
236701 | 236701 | 2020-06-13 | Orleans | Vermont | 50019 | 13 | 0 |
233594 | 233594 | 2020-06-12 | Orleans | Vermont | 50019 | 13 | 0 |
230489 | 230489 | 2020-06-11 | Orleans | Vermont | 50019 | 13 | 0 |
227385 | 227385 | 2020-06-10 | Orleans | Vermont | 50019 | 13 | 0 |
224285 | 224285 | 2020-06-09 | Orleans | Vermont | 50019 | 13 | 0 |
221189 | 221189 | 2020-06-08 | Orleans | Vermont | 50019 | 13 | 0 |
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);