ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 16001 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1713 | 1713 | 2020-03-13 | Ada | Idaho | 16001 | 1 | 0 |
2037 | 2037 | 2020-03-14 | Ada | Idaho | 16001 | 2 | 0 |
2427 | 2427 | 2020-03-15 | Ada | Idaho | 16001 | 2 | 0 |
2868 | 2868 | 2020-03-16 | Ada | Idaho | 16001 | 2 | 0 |
3356 | 3356 | 2020-03-17 | Ada | Idaho | 16001 | 3 | 0 |
3918 | 3918 | 2020-03-18 | Ada | Idaho | 16001 | 3 | 0 |
4594 | 4594 | 2020-03-19 | Ada | Idaho | 16001 | 3 | 0 |
5394 | 5394 | 2020-03-20 | Ada | Idaho | 16001 | 4 | 0 |
6328 | 6328 | 2020-03-21 | Ada | Idaho | 16001 | 11 | 0 |
7376 | 7376 | 2020-03-22 | Ada | Idaho | 16001 | 13 | 0 |
8531 | 8531 | 2020-03-23 | Ada | Idaho | 16001 | 15 | 0 |
9792 | 9792 | 2020-03-24 | Ada | Idaho | 16001 | 22 | 0 |
11177 | 11177 | 2020-03-25 | Ada | Idaho | 16001 | 37 | 0 |
12730 | 12730 | 2020-03-26 | Ada | Idaho | 16001 | 54 | 0 |
14405 | 14405 | 2020-03-27 | Ada | Idaho | 16001 | 76 | 0 |
16196 | 16196 | 2020-03-28 | Ada | Idaho | 16001 | 88 | 1 |
18093 | 18093 | 2020-03-29 | Ada | Idaho | 16001 | 113 | 2 |
20089 | 20089 | 2020-03-30 | Ada | Idaho | 16001 | 151 | 3 |
22178 | 22178 | 2020-03-31 | Ada | Idaho | 16001 | 195 | 3 |
24344 | 24344 | 2020-04-01 | Ada | Idaho | 16001 | 226 | 3 |
26576 | 26576 | 2020-04-02 | Ada | Idaho | 16001 | 307 | 3 |
28883 | 28883 | 2020-04-03 | Ada | Idaho | 16001 | 351 | 3 |
31244 | 31244 | 2020-04-04 | Ada | Idaho | 16001 | 385 | 3 |
33651 | 33651 | 2020-04-05 | Ada | Idaho | 16001 | 402 | 3 |
36102 | 36102 | 2020-04-06 | Ada | Idaho | 16001 | 419 | 3 |
38595 | 38595 | 2020-04-07 | Ada | Idaho | 16001 | 438 | 3 |
41139 | 41139 | 2020-04-08 | Ada | Idaho | 16001 | 447 | 5 |
43713 | 43713 | 2020-04-09 | Ada | Idaho | 16001 | 496 | 6 |
46315 | 46315 | 2020-04-10 | Ada | Idaho | 16001 | 516 | 6 |
48946 | 48946 | 2020-04-11 | Ada | Idaho | 16001 | 521 | 6 |
51608 | 51608 | 2020-04-12 | Ada | Idaho | 16001 | 521 | 6 |
54288 | 54288 | 2020-04-13 | Ada | Idaho | 16001 | 539 | 9 |
56980 | 56980 | 2020-04-14 | Ada | Idaho | 16001 | 557 | 9 |
59687 | 59687 | 2020-04-15 | Ada | Idaho | 16001 | 567 | 9 |
62407 | 62407 | 2020-04-16 | Ada | Idaho | 16001 | 576 | 9 |
65139 | 65139 | 2020-04-17 | Ada | Idaho | 16001 | 593 | 9 |
67887 | 67887 | 2020-04-18 | Ada | Idaho | 16001 | 598 | 10 |
70649 | 70649 | 2020-04-19 | Ada | Idaho | 16001 | 598 | 10 |
73418 | 73418 | 2020-04-20 | Ada | Idaho | 16001 | 616 | 12 |
76194 | 76194 | 2020-04-21 | Ada | Idaho | 16001 | 622 | 12 |
78978 | 78978 | 2020-04-22 | Ada | Idaho | 16001 | 630 | 14 |
81771 | 81771 | 2020-04-23 | Ada | Idaho | 16001 | 635 | 14 |
84571 | 84571 | 2020-04-24 | Ada | Idaho | 16001 | 642 | 14 |
87380 | 87380 | 2020-04-25 | Ada | Idaho | 16001 | 650 | 15 |
90196 | 90196 | 2020-04-26 | Ada | Idaho | 16001 | 650 | 15 |
93015 | 93015 | 2020-04-27 | Ada | Idaho | 16001 | 661 | 15 |
95847 | 95847 | 2020-04-28 | Ada | Idaho | 16001 | 662 | 16 |
98691 | 98691 | 2020-04-29 | Ada | Idaho | 16001 | 671 | 16 |
101542 | 101542 | 2020-04-30 | Ada | Idaho | 16001 | 681 | 16 |
104397 | 104397 | 2020-05-01 | Ada | Idaho | 16001 | 689 | 16 |
107262 | 107262 | 2020-05-02 | Ada | Idaho | 16001 | 705 | 17 |
110132 | 110132 | 2020-05-03 | Ada | Idaho | 16001 | 705 | 17 |
113007 | 113007 | 2020-05-04 | Ada | Idaho | 16001 | 710 | 17 |
115890 | 115890 | 2020-05-05 | Ada | Idaho | 16001 | 713 | 19 |
118850 | 118850 | 2020-05-06 | Ada | Idaho | 16001 | 717 | 19 |
121820 | 121820 | 2020-05-07 | Ada | Idaho | 16001 | 721 | 19 |
124799 | 124799 | 2020-05-08 | Ada | Idaho | 16001 | 731 | 19 |
127786 | 127786 | 2020-05-09 | Ada | Idaho | 16001 | 733 | 19 |
130777 | 130777 | 2020-05-10 | Ada | Idaho | 16001 | 733 | 19 |
133768 | 133768 | 2020-05-11 | Ada | Idaho | 16001 | 739 | 21 |
136757 | 136757 | 2020-05-12 | Ada | Idaho | 16001 | 744 | 21 |
139748 | 139748 | 2020-05-13 | Ada | Idaho | 16001 | 754 | 21 |
142744 | 142744 | 2020-05-14 | Ada | Idaho | 16001 | 759 | 22 |
145744 | 145744 | 2020-05-15 | Ada | Idaho | 16001 | 770 | 22 |
148747 | 148747 | 2020-05-16 | Ada | Idaho | 16001 | 773 | 22 |
151756 | 151756 | 2020-05-17 | Ada | Idaho | 16001 | 773 | 22 |
154768 | 154768 | 2020-05-18 | Ada | Idaho | 16001 | 780 | 22 |
157784 | 157784 | 2020-05-19 | Ada | Idaho | 16001 | 783 | 23 |
160810 | 160810 | 2020-05-20 | Ada | Idaho | 16001 | 792 | 23 |
163838 | 163838 | 2020-05-21 | Ada | Idaho | 16001 | 791 | 23 |
166871 | 166871 | 2020-05-22 | Ada | Idaho | 16001 | 794 | 23 |
169908 | 169908 | 2020-05-23 | Ada | Idaho | 16001 | 796 | 23 |
172949 | 172949 | 2020-05-24 | Ada | Idaho | 16001 | 796 | 23 |
175992 | 175992 | 2020-05-25 | Ada | Idaho | 16001 | 798 | 23 |
179036 | 179036 | 2020-05-26 | Ada | Idaho | 16001 | 798 | 22 |
182080 | 182080 | 2020-05-27 | Ada | Idaho | 16001 | 800 | 22 |
185134 | 185134 | 2020-05-28 | Ada | Idaho | 16001 | 803 | 22 |
188190 | 188190 | 2020-05-29 | Ada | Idaho | 16001 | 805 | 22 |
191255 | 191255 | 2020-05-30 | Ada | Idaho | 16001 | 812 | 22 |
194322 | 194322 | 2020-05-31 | Ada | Idaho | 16001 | 812 | 22 |
197392 | 197392 | 2020-06-01 | Ada | Idaho | 16001 | 818 | 22 |
200465 | 200465 | 2020-06-02 | Ada | Idaho | 16001 | 818 | 22 |
203541 | 203541 | 2020-06-03 | Ada | Idaho | 16001 | 823 | 22 |
206621 | 206621 | 2020-06-04 | Ada | Idaho | 16001 | 832 | 22 |
209702 | 209702 | 2020-06-05 | Ada | Idaho | 16001 | 833 | 22 |
212787 | 212787 | 2020-06-06 | Ada | Idaho | 16001 | 838 | 22 |
215874 | 215874 | 2020-06-07 | Ada | Idaho | 16001 | 838 | 22 |
218965 | 218965 | 2020-06-08 | Ada | Idaho | 16001 | 844 | 22 |
222060 | 222060 | 2020-06-09 | Ada | Idaho | 16001 | 848 | 22 |
225155 | 225155 | 2020-06-10 | Ada | Idaho | 16001 | 854 | 22 |
228257 | 228257 | 2020-06-11 | Ada | Idaho | 16001 | 866 | 22 |
231360 | 231360 | 2020-06-12 | Ada | Idaho | 16001 | 877 | 22 |
234466 | 234466 | 2020-06-13 | Ada | Idaho | 16001 | 892 | 22 |
237573 | 237573 | 2020-06-14 | Ada | Idaho | 16001 | 892 | 22 |
240681 | 240681 | 2020-06-15 | Ada | Idaho | 16001 | 915 | 22 |
243792 | 243792 | 2020-06-16 | Ada | Idaho | 16001 | 947 | 22 |
246905 | 246905 | 2020-06-17 | Ada | Idaho | 16001 | 986 | 22 |
250017 | 250017 | 2020-06-18 | Ada | Idaho | 16001 | 1043 | 22 |
253132 | 253132 | 2020-06-19 | Ada | Idaho | 16001 | 1100 | 22 |
256251 | 256251 | 2020-06-20 | Ada | Idaho | 16001 | 1166 | 22 |
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);