ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Tulare" and state = "California" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1393 | 1393 | 2020-03-12 | Tulare | California | 6107 | 1 | 0 |
1654 | 1654 | 2020-03-13 | Tulare | California | 6107 | 2 | 0 |
1972 | 1972 | 2020-03-14 | Tulare | California | 6107 | 3 | 0 |
2353 | 2353 | 2020-03-15 | Tulare | California | 6107 | 3 | 0 |
2788 | 2788 | 2020-03-16 | Tulare | California | 6107 | 3 | 0 |
3270 | 3270 | 2020-03-17 | Tulare | California | 6107 | 3 | 0 |
3824 | 3824 | 2020-03-18 | Tulare | California | 6107 | 5 | 0 |
4484 | 4484 | 2020-03-19 | Tulare | California | 6107 | 7 | 0 |
5259 | 5259 | 2020-03-20 | Tulare | California | 6107 | 11 | 0 |
6181 | 6181 | 2020-03-21 | Tulare | California | 6107 | 11 | 0 |
7215 | 7215 | 2020-03-22 | Tulare | California | 6107 | 12 | 0 |
8358 | 8358 | 2020-03-23 | Tulare | California | 6107 | 16 | 0 |
9601 | 9601 | 2020-03-24 | Tulare | California | 6107 | 17 | 0 |
10974 | 10974 | 2020-03-25 | Tulare | California | 6107 | 18 | 0 |
12519 | 12519 | 2020-03-26 | Tulare | California | 6107 | 20 | 0 |
14185 | 14185 | 2020-03-27 | Tulare | California | 6107 | 24 | 0 |
15967 | 15967 | 2020-03-28 | Tulare | California | 6107 | 29 | 1 |
17856 | 17856 | 2020-03-29 | Tulare | California | 6107 | 35 | 1 |
19833 | 19833 | 2020-03-30 | Tulare | California | 6107 | 43 | 1 |
21908 | 21908 | 2020-03-31 | Tulare | California | 6107 | 45 | 1 |
24066 | 24066 | 2020-04-01 | Tulare | California | 6107 | 59 | 2 |
26295 | 26295 | 2020-04-02 | Tulare | California | 6107 | 74 | 2 |
28595 | 28595 | 2020-04-03 | Tulare | California | 6107 | 81 | 3 |
30953 | 30953 | 2020-04-04 | Tulare | California | 6107 | 107 | 5 |
33359 | 33359 | 2020-04-05 | Tulare | California | 6107 | 116 | 5 |
35804 | 35804 | 2020-04-06 | Tulare | California | 6107 | 135 | 6 |
38293 | 38293 | 2020-04-07 | Tulare | California | 6107 | 157 | 6 |
40837 | 40837 | 2020-04-08 | Tulare | California | 6107 | 168 | 7 |
43409 | 43409 | 2020-04-09 | Tulare | California | 6107 | 187 | 10 |
46009 | 46009 | 2020-04-10 | Tulare | California | 6107 | 203 | 11 |
48639 | 48639 | 2020-04-11 | Tulare | California | 6107 | 227 | 11 |
51301 | 51301 | 2020-04-12 | Tulare | California | 6107 | 227 | 11 |
53980 | 53980 | 2020-04-13 | Tulare | California | 6107 | 264 | 13 |
56672 | 56672 | 2020-04-14 | Tulare | California | 6107 | 296 | 13 |
59380 | 59380 | 2020-04-15 | Tulare | California | 6107 | 352 | 15 |
62099 | 62099 | 2020-04-16 | Tulare | California | 6107 | 372 | 17 |
64832 | 64832 | 2020-04-17 | Tulare | California | 6107 | 382 | 17 |
67580 | 67580 | 2020-04-18 | Tulare | California | 6107 | 397 | 17 |
70342 | 70342 | 2020-04-19 | Tulare | California | 6107 | 411 | 17 |
73111 | 73111 | 2020-04-20 | Tulare | California | 6107 | 422 | 18 |
75887 | 75887 | 2020-04-21 | Tulare | California | 6107 | 436 | 22 |
78671 | 78671 | 2020-04-22 | Tulare | California | 6107 | 441 | 25 |
81465 | 81465 | 2020-04-23 | Tulare | California | 6107 | 453 | 25 |
84265 | 84265 | 2020-04-24 | Tulare | California | 6107 | 472 | 28 |
87073 | 87073 | 2020-04-25 | Tulare | California | 6107 | 491 | 32 |
89890 | 89890 | 2020-04-26 | Tulare | California | 6107 | 504 | 32 |
92708 | 92708 | 2020-04-27 | Tulare | California | 6107 | 532 | 32 |
95540 | 95540 | 2020-04-28 | Tulare | California | 6107 | 578 | 35 |
98385 | 98385 | 2020-04-29 | Tulare | California | 6107 | 626 | 36 |
101235 | 101235 | 2020-04-30 | Tulare | California | 6107 | 640 | 40 |
104090 | 104090 | 2020-05-01 | Tulare | California | 6107 | 680 | 40 |
106955 | 106955 | 2020-05-02 | Tulare | California | 6107 | 720 | 40 |
109824 | 109824 | 2020-05-03 | Tulare | California | 6107 | 743 | 40 |
112699 | 112699 | 2020-05-04 | Tulare | California | 6107 | 757 | 40 |
115582 | 115582 | 2020-05-05 | Tulare | California | 6107 | 858 | 40 |
118541 | 118541 | 2020-05-06 | Tulare | California | 6107 | 916 | 41 |
121508 | 121508 | 2020-05-07 | Tulare | California | 6107 | 969 | 43 |
124488 | 124488 | 2020-05-08 | Tulare | California | 6107 | 1013 | 44 |
127473 | 127473 | 2020-05-09 | Tulare | California | 6107 | 1079 | 46 |
130464 | 130464 | 2020-05-10 | Tulare | California | 6107 | 1140 | 48 |
133454 | 133454 | 2020-05-11 | Tulare | California | 6107 | 1159 | 50 |
136444 | 136444 | 2020-05-12 | Tulare | California | 6107 | 1241 | 52 |
139435 | 139435 | 2020-05-13 | Tulare | California | 6107 | 1268 | 54 |
142431 | 142431 | 2020-05-14 | Tulare | California | 6107 | 1295 | 54 |
145430 | 145430 | 2020-05-15 | Tulare | California | 6107 | 1338 | 64 |
148434 | 148434 | 2020-05-16 | Tulare | California | 6107 | 1426 | 67 |
151443 | 151443 | 2020-05-17 | Tulare | California | 6107 | 1430 | 67 |
154455 | 154455 | 2020-05-18 | Tulare | California | 6107 | 1436 | 67 |
157471 | 157471 | 2020-05-19 | Tulare | California | 6107 | 1539 | 71 |
160497 | 160497 | 2020-05-20 | Tulare | California | 6107 | 1552 | 73 |
163525 | 163525 | 2020-05-21 | Tulare | California | 6107 | 1603 | 74 |
166558 | 166558 | 2020-05-22 | Tulare | California | 6107 | 1641 | 75 |
169595 | 169595 | 2020-05-23 | Tulare | California | 6107 | 1662 | 75 |
172636 | 172636 | 2020-05-24 | Tulare | California | 6107 | 1682 | 75 |
175680 | 175680 | 2020-05-25 | Tulare | California | 6107 | 1684 | 75 |
178724 | 178724 | 2020-05-26 | Tulare | California | 6107 | 1771 | 79 |
181768 | 181768 | 2020-05-27 | Tulare | California | 6107 | 1796 | 79 |
184822 | 184822 | 2020-05-28 | Tulare | California | 6107 | 1835 | 80 |
187878 | 187878 | 2020-05-29 | Tulare | California | 6107 | 1844 | 84 |
190943 | 190943 | 2020-05-30 | Tulare | California | 6107 | 1852 | 84 |
194010 | 194010 | 2020-05-31 | Tulare | California | 6107 | 1879 | 84 |
197080 | 197080 | 2020-06-01 | Tulare | California | 6107 | 1897 | 89 |
200153 | 200153 | 2020-06-02 | Tulare | California | 6107 | 2004 | 89 |
203229 | 203229 | 2020-06-03 | Tulare | California | 6107 | 2026 | 90 |
206309 | 206309 | 2020-06-04 | Tulare | California | 6107 | 2083 | 92 |
209390 | 209390 | 2020-06-05 | Tulare | California | 6107 | 2116 | 92 |
212475 | 212475 | 2020-06-06 | Tulare | California | 6107 | 2180 | 92 |
215562 | 215562 | 2020-06-07 | Tulare | California | 6107 | 2213 | 92 |
218653 | 218653 | 2020-06-08 | Tulare | California | 6107 | 2220 | 94 |
221748 | 221748 | 2020-06-09 | Tulare | California | 6107 | 2381 | 94 |
224843 | 224843 | 2020-06-10 | Tulare | California | 6107 | 2432 | 96 |
227945 | 227945 | 2020-06-11 | Tulare | California | 6107 | 2475 | 98 |
231048 | 231048 | 2020-06-12 | Tulare | California | 6107 | 2564 | 98 |
234154 | 234154 | 2020-06-13 | Tulare | California | 6107 | 2564 | 98 |
237261 | 237261 | 2020-06-14 | Tulare | California | 6107 | 2626 | 98 |
240369 | 240369 | 2020-06-15 | Tulare | California | 6107 | 2664 | 98 |
243480 | 243480 | 2020-06-16 | Tulare | California | 6107 | 2798 | 98 |
246593 | 246593 | 2020-06-17 | Tulare | California | 6107 | 2881 | 106 |
249705 | 249705 | 2020-06-18 | Tulare | California | 6107 | 3004 | 107 |
252820 | 252820 | 2020-06-19 | Tulare | California | 6107 | 3046 | 111 |
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);