ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where county = "New York City" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536289 | 536289 | 2020-09-15 | New York City | New York | 243061 | 23758 | |
533053 | 533053 | 2020-09-14 | New York City | New York | 242754 | 23750 | |
529818 | 529818 | 2020-09-13 | New York City | New York | 242486 | 23743 | |
526581 | 526581 | 2020-09-12 | New York City | New York | 242242 | 23743 | |
523345 | 523345 | 2020-09-11 | New York City | New York | 241936 | 23739 | |
520109 | 520109 | 2020-09-10 | New York City | New York | 241686 | 23741 | |
516873 | 516873 | 2020-09-09 | New York City | New York | 241351 | 23741 | |
513638 | 513638 | 2020-09-08 | New York City | New York | 241141 | 23744 | |
510405 | 510405 | 2020-09-07 | New York City | New York | 240919 | 23736 | |
507172 | 507172 | 2020-09-06 | New York City | New York | 240711 | 23721 | |
503940 | 503940 | 2020-09-05 | New York City | New York | 240416 | 23721 | |
500706 | 500706 | 2020-09-04 | New York City | New York | 240139 | 23716 | |
497472 | 497472 | 2020-09-03 | New York City | New York | 239815 | 23710 | |
494239 | 494239 | 2020-09-02 | New York City | New York | 239512 | 23708 | |
491005 | 491005 | 2020-09-01 | New York City | New York | 239246 | 23703 | |
487772 | 487772 | 2020-08-31 | New York City | New York | 238938 | 23695 | |
484539 | 484539 | 2020-08-30 | New York City | New York | 238677 | 23689 | |
481304 | 481304 | 2020-08-29 | New York City | New York | 238385 | 23683 | |
478071 | 478071 | 2020-08-28 | New York City | New York | 238107 | 23680 | |
474838 | 474838 | 2020-08-27 | New York City | New York | 237838 | 23674 | |
471604 | 471604 | 2020-08-26 | New York City | New York | 237525 | 23669 | |
468372 | 468372 | 2020-08-25 | New York City | New York | 237263 | 23666 | |
465144 | 465144 | 2020-08-24 | New York City | New York | 237032 | 23662 | |
461915 | 461915 | 2020-08-23 | New York City | New York | 236822 | 23658 | |
458687 | 458687 | 2020-08-22 | New York City | New York | 236534 | 23646 | |
455459 | 455459 | 2020-08-21 | New York City | New York | 236269 | 23641 | |
452231 | 452231 | 2020-08-20 | New York City | New York | 235985 | 23639 | |
449003 | 449003 | 2020-08-19 | New York City | New York | 235714 | 23643 | |
445775 | 445775 | 2020-08-18 | New York City | New York | 235446 | 23642 | |
442549 | 442549 | 2020-08-17 | New York City | New York | 235155 | 23634 | |
439322 | 439322 | 2020-08-16 | New York City | New York | 234918 | 23628 | |
436097 | 436097 | 2020-08-15 | New York City | New York | 234609 | 23621 | |
432871 | 432871 | 2020-08-14 | New York City | New York | 234223 | 23615 | |
429645 | 429645 | 2020-08-13 | New York City | New York | 233859 | 23610 | |
426420 | 426420 | 2020-08-12 | New York City | New York | 233422 | 23602 | |
423197 | 423197 | 2020-08-11 | New York City | New York | 233030 | 23592 | |
419974 | 419974 | 2020-08-10 | New York City | New York | 232756 | 23586 | |
416754 | 416754 | 2020-08-09 | New York City | New York | 232517 | 23580 | |
413533 | 413533 | 2020-08-08 | New York City | New York | 232271 | 23575 | |
410313 | 410313 | 2020-08-07 | New York City | New York | 231942 | 23567 | |
407093 | 407093 | 2020-08-06 | New York City | New York | 231600 | 23563 | |
403874 | 403874 | 2020-08-05 | New York City | New York | 231268 | 23034 | |
400656 | 400656 | 2020-08-04 | New York City | New York | 230964 | 23027 | |
397441 | 397441 | 2020-08-03 | New York City | New York | 230648 | 23021 | |
394224 | 394224 | 2020-08-02 | New York City | New York | 230410 | 23012 | |
391008 | 391008 | 2020-08-01 | New York City | New York | 230147 | 23007 | |
387791 | 387791 | 2020-07-31 | New York City | New York | 229834 | 23002 | |
384574 | 384574 | 2020-07-30 | New York City | New York | 229551 | 22996 | |
381356 | 381356 | 2020-07-29 | New York City | New York | 229237 | 22982 | |
378139 | 378139 | 2020-07-28 | New York City | New York | 228939 | 22977 | |
374923 | 374923 | 2020-07-27 | New York City | New York | 228740 | 22970 | |
371711 | 371711 | 2020-07-26 | New York City | New York | 228445 | 22956 | |
368499 | 368499 | 2020-07-25 | New York City | New York | 228220 | 22947 | |
365290 | 365290 | 2020-07-24 | New York City | New York | 227882 | 22936 | |
362084 | 362084 | 2020-07-23 | New York City | New York | 227517 | 22934 | |
358878 | 358878 | 2020-07-22 | New York City | New York | 227130 | 22899 | |
355674 | 355674 | 2020-07-21 | New York City | New York | 226779 | 22895 | |
352471 | 352471 | 2020-07-20 | New York City | New York | 226388 | 22882 | |
349268 | 349268 | 2020-07-19 | New York City | New York | 226104 | 22872 | |
346067 | 346067 | 2020-07-18 | New York City | New York | 225799 | 22859 | |
342868 | 342868 | 2020-07-17 | New York City | New York | 225414 | 22848 | |
339670 | 339670 | 2020-07-16 | New York City | New York | 225045 | 22842 | |
336474 | 336474 | 2020-07-15 | New York City | New York | 224662 | 22825 | |
333280 | 333280 | 2020-07-14 | New York City | New York | 224293 | 22808 | |
330090 | 330090 | 2020-07-13 | New York City | New York | 223977 | 22795 | |
326903 | 326903 | 2020-07-12 | New York City | New York | 223725 | 22755 | |
323719 | 323719 | 2020-07-11 | New York City | New York | 223382 | 22750 | |
320539 | 320539 | 2020-07-10 | New York City | New York | 223078 | 22739 | |
317362 | 317362 | 2020-07-09 | New York City | New York | 222723 | 22719 | |
314188 | 314188 | 2020-07-08 | New York City | New York | 222444 | 22696 | |
311017 | 311017 | 2020-07-07 | New York City | New York | 222156 | 22690 | |
307849 | 307849 | 2020-07-06 | New York City | New York | 221882 | 22672 | |
304682 | 304682 | 2020-07-05 | New York City | New York | 221637 | 22661 | |
301519 | 301519 | 2020-07-04 | New York City | New York | 221395 | 22630 | |
298356 | 298356 | 2020-07-03 | New York City | New York | 221028 | 22610 | |
295196 | 295196 | 2020-07-02 | New York City | New York | 220567 | 22593 | |
292041 | 292041 | 2020-07-01 | New York City | New York | 220143 | 22574 | |
288889 | 288889 | 2020-06-30 | New York City | New York | 219844 | 22566 | |
285739 | 285739 | 2020-06-29 | New York City | New York | 219670 | 21941 | |
282594 | 282594 | 2020-06-28 | New York City | New York | 219481 | 21940 | |
279448 | 279448 | 2020-06-27 | New York City | New York | 219157 | 21913 | |
276300 | 276300 | 2020-06-26 | New York City | New York | 218799 | 21893 | |
273154 | 273154 | 2020-06-25 | New York City | New York | 218429 | 21856 | |
270015 | 270015 | 2020-06-24 | New York City | New York | 218089 | 21838 | |
266881 | 266881 | 2020-06-23 | New York City | New York | 217803 | 21817 | |
263753 | 263753 | 2020-06-22 | New York City | New York | 217487 | 21796 | |
260625 | 260625 | 2020-06-21 | New York City | New York | 217189 | 21753 | |
257498 | 257498 | 2020-06-20 | New York City | New York | 216803 | 21719 | |
254375 | 254375 | 2020-06-19 | New York City | New York | 216421 | 21710 | |
251260 | 251260 | 2020-06-18 | New York City | New York | 216013 | 21673 | |
248145 | 248145 | 2020-06-17 | New York City | New York | 215686 | 21645 | |
245032 | 245032 | 2020-06-16 | New York City | New York | 215342 | 21619 | |
241920 | 241920 | 2020-06-15 | New York City | New York | 215011 | 21600 | |
238811 | 238811 | 2020-06-14 | New York City | New York | 214627 | 21578 | |
235703 | 235703 | 2020-06-13 | New York City | New York | 214242 | 21551 | |
232598 | 232598 | 2020-06-12 | New York City | New York | 213707 | 21519 | |
229493 | 229493 | 2020-06-11 | New York City | New York | 213271 | 21468 | |
226389 | 226389 | 2020-06-10 | New York City | New York | 212884 | 21436 | |
223289 | 223289 | 2020-06-09 | New York City | New York | 212469 | 21396 | |
220195 | 220195 | 2020-06-08 | New York City | New York | 212122 | 21356 |
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);