ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Union" and fips = 18161 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921220 | 921220 | 2021-01-12 | Union | Indiana | 18161 | 624 | 2 |
917975 | 917975 | 2021-01-11 | Union | Indiana | 18161 | 616 | 2 |
914730 | 914730 | 2021-01-10 | Union | Indiana | 18161 | 610 | 2 |
911485 | 911485 | 2021-01-09 | Union | Indiana | 18161 | 598 | 2 |
908240 | 908240 | 2021-01-08 | Union | Indiana | 18161 | 592 | 2 |
904994 | 904994 | 2021-01-07 | Union | Indiana | 18161 | 580 | 2 |
901749 | 901749 | 2021-01-06 | Union | Indiana | 18161 | 573 | 2 |
898504 | 898504 | 2021-01-05 | Union | Indiana | 18161 | 564 | 2 |
895259 | 895259 | 2021-01-04 | Union | Indiana | 18161 | 557 | 2 |
892012 | 892012 | 2021-01-03 | Union | Indiana | 18161 | 552 | 2 |
888766 | 888766 | 2021-01-02 | Union | Indiana | 18161 | 548 | 2 |
885520 | 885520 | 2021-01-01 | Union | Indiana | 18161 | 537 | 2 |
882275 | 882275 | 2020-12-31 | Union | Indiana | 18161 | 530 | 2 |
879030 | 879030 | 2020-12-30 | Union | Indiana | 18161 | 514 | 2 |
875785 | 875785 | 2020-12-29 | Union | Indiana | 18161 | 502 | 2 |
872540 | 872540 | 2020-12-28 | Union | Indiana | 18161 | 499 | 2 |
869295 | 869295 | 2020-12-27 | Union | Indiana | 18161 | 497 | 2 |
866050 | 866050 | 2020-12-26 | Union | Indiana | 18161 | 497 | 2 |
862805 | 862805 | 2020-12-25 | Union | Indiana | 18161 | 491 | 2 |
859560 | 859560 | 2020-12-24 | Union | Indiana | 18161 | 482 | 2 |
856315 | 856315 | 2020-12-23 | Union | Indiana | 18161 | 467 | 2 |
853070 | 853070 | 2020-12-22 | Union | Indiana | 18161 | 456 | 2 |
849825 | 849825 | 2020-12-21 | Union | Indiana | 18161 | 455 | 2 |
846580 | 846580 | 2020-12-20 | Union | Indiana | 18161 | 451 | 2 |
843334 | 843334 | 2020-12-19 | Union | Indiana | 18161 | 442 | 2 |
840089 | 840089 | 2020-12-18 | Union | Indiana | 18161 | 433 | 2 |
836844 | 836844 | 2020-12-17 | Union | Indiana | 18161 | 423 | 2 |
833598 | 833598 | 2020-12-16 | Union | Indiana | 18161 | 411 | 2 |
830351 | 830351 | 2020-12-15 | Union | Indiana | 18161 | 402 | 2 |
827105 | 827105 | 2020-12-14 | Union | Indiana | 18161 | 392 | 2 |
823858 | 823858 | 2020-12-13 | Union | Indiana | 18161 | 390 | 2 |
820612 | 820612 | 2020-12-12 | Union | Indiana | 18161 | 390 | 2 |
817366 | 817366 | 2020-12-11 | Union | Indiana | 18161 | 388 | 2 |
814120 | 814120 | 2020-12-10 | Union | Indiana | 18161 | 361 | 2 |
810875 | 810875 | 2020-12-09 | Union | Indiana | 18161 | 356 | 2 |
807630 | 807630 | 2020-12-08 | Union | Indiana | 18161 | 351 | 2 |
804385 | 804385 | 2020-12-07 | Union | Indiana | 18161 | 348 | 2 |
801140 | 801140 | 2020-12-06 | Union | Indiana | 18161 | 344 | 2 |
797895 | 797895 | 2020-12-05 | Union | Indiana | 18161 | 343 | 2 |
794650 | 794650 | 2020-12-04 | Union | Indiana | 18161 | 341 | 2 |
791405 | 791405 | 2020-12-03 | Union | Indiana | 18161 | 332 | 2 |
788160 | 788160 | 2020-12-02 | Union | Indiana | 18161 | 326 | 2 |
784916 | 784916 | 2020-12-01 | Union | Indiana | 18161 | 325 | 2 |
781671 | 781671 | 2020-11-30 | Union | Indiana | 18161 | 330 | 2 |
778425 | 778425 | 2020-11-29 | Union | Indiana | 18161 | 315 | 2 |
775180 | 775180 | 2020-11-28 | Union | Indiana | 18161 | 311 | 2 |
771935 | 771935 | 2020-11-27 | Union | Indiana | 18161 | 307 | 2 |
768690 | 768690 | 2020-11-26 | Union | Indiana | 18161 | 304 | 2 |
765444 | 765444 | 2020-11-25 | Union | Indiana | 18161 | 299 | 2 |
762199 | 762199 | 2020-11-24 | Union | Indiana | 18161 | 296 | 1 |
758954 | 758954 | 2020-11-23 | Union | Indiana | 18161 | 291 | 1 |
755707 | 755707 | 2020-11-22 | Union | Indiana | 18161 | 284 | 1 |
752461 | 752461 | 2020-11-21 | Union | Indiana | 18161 | 280 | 1 |
749215 | 749215 | 2020-11-20 | Union | Indiana | 18161 | 277 | 1 |
745969 | 745969 | 2020-11-19 | Union | Indiana | 18161 | 267 | 1 |
742722 | 742722 | 2020-11-18 | Union | Indiana | 18161 | 264 | 1 |
739475 | 739475 | 2020-11-17 | Union | Indiana | 18161 | 260 | 1 |
736231 | 736231 | 2020-11-16 | Union | Indiana | 18161 | 256 | 1 |
732985 | 732985 | 2020-11-15 | Union | Indiana | 18161 | 251 | 1 |
729740 | 729740 | 2020-11-14 | Union | Indiana | 18161 | 245 | 1 |
726497 | 726497 | 2020-11-13 | Union | Indiana | 18161 | 232 | 1 |
723254 | 723254 | 2020-11-12 | Union | Indiana | 18161 | 227 | 1 |
720011 | 720011 | 2020-11-11 | Union | Indiana | 18161 | 217 | 1 |
716768 | 716768 | 2020-11-10 | Union | Indiana | 18161 | 205 | 0 |
713524 | 713524 | 2020-11-09 | Union | Indiana | 18161 | 199 | 0 |
710280 | 710280 | 2020-11-08 | Union | Indiana | 18161 | 195 | 0 |
707036 | 707036 | 2020-11-07 | Union | Indiana | 18161 | 190 | 0 |
703793 | 703793 | 2020-11-06 | Union | Indiana | 18161 | 185 | 0 |
700551 | 700551 | 2020-11-05 | Union | Indiana | 18161 | 178 | 0 |
697307 | 697307 | 2020-11-04 | Union | Indiana | 18161 | 172 | 0 |
694065 | 694065 | 2020-11-03 | Union | Indiana | 18161 | 164 | 0 |
690822 | 690822 | 2020-11-02 | Union | Indiana | 18161 | 163 | 0 |
687577 | 687577 | 2020-11-01 | Union | Indiana | 18161 | 160 | 0 |
684333 | 684333 | 2020-10-31 | Union | Indiana | 18161 | 158 | 0 |
681090 | 681090 | 2020-10-30 | Union | Indiana | 18161 | 157 | 0 |
677847 | 677847 | 2020-10-29 | Union | Indiana | 18161 | 155 | 0 |
674604 | 674604 | 2020-10-28 | Union | Indiana | 18161 | 151 | 0 |
671362 | 671362 | 2020-10-27 | Union | Indiana | 18161 | 145 | 0 |
668119 | 668119 | 2020-10-26 | Union | Indiana | 18161 | 141 | 0 |
664875 | 664875 | 2020-10-25 | Union | Indiana | 18161 | 141 | 0 |
661630 | 661630 | 2020-10-24 | Union | Indiana | 18161 | 139 | 0 |
658386 | 658386 | 2020-10-23 | Union | Indiana | 18161 | 138 | 0 |
655141 | 655141 | 2020-10-22 | Union | Indiana | 18161 | 137 | 0 |
651896 | 651896 | 2020-10-21 | Union | Indiana | 18161 | 133 | 0 |
648652 | 648652 | 2020-10-20 | Union | Indiana | 18161 | 131 | 0 |
645407 | 645407 | 2020-10-19 | Union | Indiana | 18161 | 129 | 0 |
642160 | 642160 | 2020-10-18 | Union | Indiana | 18161 | 128 | 0 |
638913 | 638913 | 2020-10-17 | Union | Indiana | 18161 | 124 | 0 |
635667 | 635667 | 2020-10-16 | Union | Indiana | 18161 | 121 | 0 |
632421 | 632421 | 2020-10-15 | Union | Indiana | 18161 | 119 | 0 |
629177 | 629177 | 2020-10-14 | Union | Indiana | 18161 | 115 | 0 |
625934 | 625934 | 2020-10-13 | Union | Indiana | 18161 | 112 | 0 |
622692 | 622692 | 2020-10-12 | Union | Indiana | 18161 | 112 | 0 |
619448 | 619448 | 2020-10-11 | Union | Indiana | 18161 | 111 | 0 |
616206 | 616206 | 2020-10-10 | Union | Indiana | 18161 | 110 | 0 |
612965 | 612965 | 2020-10-09 | Union | Indiana | 18161 | 110 | 0 |
609723 | 609723 | 2020-10-08 | Union | Indiana | 18161 | 110 | 0 |
606480 | 606480 | 2020-10-07 | Union | Indiana | 18161 | 109 | 0 |
603238 | 603238 | 2020-10-06 | Union | Indiana | 18161 | 108 | 0 |
599995 | 599995 | 2020-10-05 | Union | Indiana | 18161 | 107 | 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);