ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 18005 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054211 | 1054211 | 2021-02-22 | Bartholomew | Indiana | 18005 | 7380 | 153 |
1050964 | 1050964 | 2021-02-21 | Bartholomew | Indiana | 18005 | 7360 | 153 |
1047717 | 1047717 | 2021-02-20 | Bartholomew | Indiana | 18005 | 7340 | 152 |
1044472 | 1044472 | 2021-02-19 | Bartholomew | Indiana | 18005 | 7317 | 152 |
1041227 | 1041227 | 2021-02-18 | Bartholomew | Indiana | 18005 | 7281 | 151 |
1037982 | 1037982 | 2021-02-17 | Bartholomew | Indiana | 18005 | 7267 | 151 |
1034737 | 1034737 | 2021-02-16 | Bartholomew | Indiana | 18005 | 7247 | 151 |
1031491 | 1031491 | 2021-02-15 | Bartholomew | Indiana | 18005 | 7229 | 150 |
1028244 | 1028244 | 2021-02-14 | Bartholomew | Indiana | 18005 | 7208 | 150 |
1024999 | 1024999 | 2021-02-13 | Bartholomew | Indiana | 18005 | 7184 | 150 |
1021754 | 1021754 | 2021-02-12 | Bartholomew | Indiana | 18005 | 7155 | 150 |
1018509 | 1018509 | 2021-02-11 | Bartholomew | Indiana | 18005 | 7132 | 146 |
1015264 | 1015264 | 2021-02-10 | Bartholomew | Indiana | 18005 | 7102 | 145 |
1012019 | 1012019 | 2021-02-09 | Bartholomew | Indiana | 18005 | 7081 | 144 |
1008773 | 1008773 | 2021-02-08 | Bartholomew | Indiana | 18005 | 7063 | 143 |
1005527 | 1005527 | 2021-02-07 | Bartholomew | Indiana | 18005 | 7047 | 143 |
1002281 | 1002281 | 2021-02-06 | Bartholomew | Indiana | 18005 | 7029 | 143 |
999035 | 999035 | 2021-02-05 | Bartholomew | Indiana | 18005 | 6979 | 143 |
995789 | 995789 | 2021-02-04 | Bartholomew | Indiana | 18005 | 6953 | 143 |
992543 | 992543 | 2021-02-03 | Bartholomew | Indiana | 18005 | 6919 | 113 |
989297 | 989297 | 2021-02-02 | Bartholomew | Indiana | 18005 | 6898 | 113 |
986050 | 986050 | 2021-02-01 | Bartholomew | Indiana | 18005 | 6871 | 110 |
982803 | 982803 | 2021-01-31 | Bartholomew | Indiana | 18005 | 6855 | 110 |
979557 | 979557 | 2021-01-30 | Bartholomew | Indiana | 18005 | 6818 | 108 |
976311 | 976311 | 2021-01-29 | Bartholomew | Indiana | 18005 | 6784 | 108 |
973066 | 973066 | 2021-01-28 | Bartholomew | Indiana | 18005 | 6747 | 107 |
969821 | 969821 | 2021-01-27 | Bartholomew | Indiana | 18005 | 6703 | 106 |
966577 | 966577 | 2021-01-26 | Bartholomew | Indiana | 18005 | 6678 | 106 |
963332 | 963332 | 2021-01-25 | Bartholomew | Indiana | 18005 | 6659 | 106 |
960087 | 960087 | 2021-01-24 | Bartholomew | Indiana | 18005 | 6542 | 106 |
956841 | 956841 | 2021-01-23 | Bartholomew | Indiana | 18005 | 6503 | 106 |
953596 | 953596 | 2021-01-22 | Bartholomew | Indiana | 18005 | 6462 | 106 |
950351 | 950351 | 2021-01-21 | Bartholomew | Indiana | 18005 | 6398 | 105 |
947105 | 947105 | 2021-01-20 | Bartholomew | Indiana | 18005 | 6359 | 103 |
943858 | 943858 | 2021-01-19 | Bartholomew | Indiana | 18005 | 6329 | 102 |
940613 | 940613 | 2021-01-18 | Bartholomew | Indiana | 18005 | 6311 | 100 |
937368 | 937368 | 2021-01-17 | Bartholomew | Indiana | 18005 | 6285 | 100 |
934123 | 934123 | 2021-01-16 | Bartholomew | Indiana | 18005 | 6261 | 100 |
930878 | 930878 | 2021-01-15 | Bartholomew | Indiana | 18005 | 6235 | 100 |
927633 | 927633 | 2021-01-14 | Bartholomew | Indiana | 18005 | 6179 | 100 |
924387 | 924387 | 2021-01-13 | Bartholomew | Indiana | 18005 | 6141 | 100 |
921142 | 921142 | 2021-01-12 | Bartholomew | Indiana | 18005 | 6110 | 99 |
917897 | 917897 | 2021-01-11 | Bartholomew | Indiana | 18005 | 6062 | 97 |
914652 | 914652 | 2021-01-10 | Bartholomew | Indiana | 18005 | 6008 | 97 |
911407 | 911407 | 2021-01-09 | Bartholomew | Indiana | 18005 | 5964 | 97 |
908162 | 908162 | 2021-01-08 | Bartholomew | Indiana | 18005 | 5893 | 95 |
904916 | 904916 | 2021-01-07 | Bartholomew | Indiana | 18005 | 5820 | 95 |
901671 | 901671 | 2021-01-06 | Bartholomew | Indiana | 18005 | 5760 | 96 |
898426 | 898426 | 2021-01-05 | Bartholomew | Indiana | 18005 | 5713 | 95 |
895181 | 895181 | 2021-01-04 | Bartholomew | Indiana | 18005 | 5676 | 95 |
891934 | 891934 | 2021-01-03 | Bartholomew | Indiana | 18005 | 5631 | 93 |
888688 | 888688 | 2021-01-02 | Bartholomew | Indiana | 18005 | 5582 | 93 |
885442 | 885442 | 2021-01-01 | Bartholomew | Indiana | 18005 | 5541 | 93 |
882197 | 882197 | 2020-12-31 | Bartholomew | Indiana | 18005 | 5485 | 91 |
878952 | 878952 | 2020-12-30 | Bartholomew | Indiana | 18005 | 5413 | 90 |
875707 | 875707 | 2020-12-29 | Bartholomew | Indiana | 18005 | 5350 | 90 |
872462 | 872462 | 2020-12-28 | Bartholomew | Indiana | 18005 | 5317 | 85 |
869217 | 869217 | 2020-12-27 | Bartholomew | Indiana | 18005 | 5304 | 85 |
865972 | 865972 | 2020-12-26 | Bartholomew | Indiana | 18005 | 5277 | 84 |
862727 | 862727 | 2020-12-25 | Bartholomew | Indiana | 18005 | 5240 | 84 |
859482 | 859482 | 2020-12-24 | Bartholomew | Indiana | 18005 | 5211 | 84 |
856237 | 856237 | 2020-12-23 | Bartholomew | Indiana | 18005 | 5119 | 84 |
852992 | 852992 | 2020-12-22 | Bartholomew | Indiana | 18005 | 5080 | 84 |
849747 | 849747 | 2020-12-21 | Bartholomew | Indiana | 18005 | 5040 | 83 |
846502 | 846502 | 2020-12-20 | Bartholomew | Indiana | 18005 | 4987 | 83 |
843256 | 843256 | 2020-12-19 | Bartholomew | Indiana | 18005 | 4921 | 83 |
840011 | 840011 | 2020-12-18 | Bartholomew | Indiana | 18005 | 4895 | 83 |
836766 | 836766 | 2020-12-17 | Bartholomew | Indiana | 18005 | 4822 | 82 |
833520 | 833520 | 2020-12-16 | Bartholomew | Indiana | 18005 | 4735 | 80 |
830273 | 830273 | 2020-12-15 | Bartholomew | Indiana | 18005 | 4697 | 79 |
827027 | 827027 | 2020-12-14 | Bartholomew | Indiana | 18005 | 4636 | 76 |
823780 | 823780 | 2020-12-13 | Bartholomew | Indiana | 18005 | 4573 | 76 |
820534 | 820534 | 2020-12-12 | Bartholomew | Indiana | 18005 | 4514 | 75 |
817288 | 817288 | 2020-12-11 | Bartholomew | Indiana | 18005 | 4431 | 75 |
814042 | 814042 | 2020-12-10 | Bartholomew | Indiana | 18005 | 4339 | 74 |
810797 | 810797 | 2020-12-09 | Bartholomew | Indiana | 18005 | 4271 | 73 |
807552 | 807552 | 2020-12-08 | Bartholomew | Indiana | 18005 | 4222 | 73 |
804307 | 804307 | 2020-12-07 | Bartholomew | Indiana | 18005 | 4149 | 73 |
801062 | 801062 | 2020-12-06 | Bartholomew | Indiana | 18005 | 4087 | 73 |
797817 | 797817 | 2020-12-05 | Bartholomew | Indiana | 18005 | 4024 | 73 |
794572 | 794572 | 2020-12-04 | Bartholomew | Indiana | 18005 | 3933 | 71 |
791327 | 791327 | 2020-12-03 | Bartholomew | Indiana | 18005 | 3818 | 70 |
788082 | 788082 | 2020-12-02 | Bartholomew | Indiana | 18005 | 3693 | 70 |
784838 | 784838 | 2020-12-01 | Bartholomew | Indiana | 18005 | 3634 | 70 |
781593 | 781593 | 2020-11-30 | Bartholomew | Indiana | 18005 | 3569 | 70 |
778347 | 778347 | 2020-11-29 | Bartholomew | Indiana | 18005 | 3490 | 70 |
775102 | 775102 | 2020-11-28 | Bartholomew | Indiana | 18005 | 3426 | 70 |
771857 | 771857 | 2020-11-27 | Bartholomew | Indiana | 18005 | 3370 | 70 |
768612 | 768612 | 2020-11-26 | Bartholomew | Indiana | 18005 | 3252 | 68 |
765366 | 765366 | 2020-11-25 | Bartholomew | Indiana | 18005 | 3185 | 68 |
762121 | 762121 | 2020-11-24 | Bartholomew | Indiana | 18005 | 3101 | 67 |
758876 | 758876 | 2020-11-23 | Bartholomew | Indiana | 18005 | 3049 | 67 |
755629 | 755629 | 2020-11-22 | Bartholomew | Indiana | 18005 | 2979 | 67 |
752383 | 752383 | 2020-11-21 | Bartholomew | Indiana | 18005 | 2905 | 66 |
749137 | 749137 | 2020-11-20 | Bartholomew | Indiana | 18005 | 2805 | 66 |
745891 | 745891 | 2020-11-19 | Bartholomew | Indiana | 18005 | 2686 | 66 |
742644 | 742644 | 2020-11-18 | Bartholomew | Indiana | 18005 | 2589 | 66 |
739397 | 739397 | 2020-11-17 | Bartholomew | Indiana | 18005 | 2505 | 66 |
736153 | 736153 | 2020-11-16 | Bartholomew | Indiana | 18005 | 2461 | 65 |
732907 | 732907 | 2020-11-15 | Bartholomew | Indiana | 18005 | 2394 | 65 |
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);