ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Vermilion" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 157 ✖
- 223 48
- 1 39
- 119 32
- 195 31
- 70 25
- 126 21
- 3 20
- 193 19
- 110 18
- 125 17
- 5 15
- 222 14
- 6 13
- 116 13
- 85 11
- 127 11
- 189 11
- 124 10
- 2 9
- 4 9
- 71 9
- 196 9
- 107 8
- 187 8
- 202 8
- 61 7
- 68 7
- 103 7
- 105 7
- 106 7
- 129 7
- 148 7
- 183 7
- 12 6
- 153 6
- 162 6
- 50 5
- 75 5
- 82 5
- 95 5
- 101 5
- 109 5
- 111 5
- 176 5
- 179 5
- 191 5
- 214 5
- 216 5
- 224 5
- 9 4
- 17 4
- 28 4
- 32 4
- 74 4
- 76 4
- 87 4
- 89 4
- 91 4
- 97 4
- 99 4
- 133 4
- 143 4
- 170 4
- 205 4
- 210 4
- 7 3
- 24 3
- 44 3
- 46 3
- 55 3
- 57 3
- 66 3
- 79 3
- 139 3
- 184 3
- 190 3
- 199 3
- 209 3
- 212 3
- 219 3
- 0 2
- 8 2
- 14 2
- 15 2
- 30 2
- 38 2
- 48 2
- 53 2
- 56 2
- 63 2
- 65 2
- 67 2
- 77 2
- 78 2
- 80 2
- 90 2
- 112 2
- 121 2
- 122 2
- 137 2
- 142 2
- 173 2
- 180 2
- 192 2
- 194 2
- 215 2
- 16 1
- 19 1
- 20 1
- 22 1
- 26 1
- 27 1
- 31 1
- 35 1
- 40 1
- 41 1
- 47 1
- 58 1
- 59 1
- 60 1
- 62 1
- 69 1
- 73 1
- 81 1
- 83 1
- 84 1
- 88 1
- 92 1
- 100 1
- 108 1
- 118 1
- 130 1
- 131 1
- 132 1
- 136 1
- 138 1
- 141 1
- 144 1
- 147 1
- 158 1
- 167 1
- 168 1
- 169 1
- 174 1
- 178 1
- 182 1
- 185 1
- 186 1
- 188 1
- 197 1
- 198 1
- 201 1
- 204 1
- 213 1
- 217 1
- 218 1
- 221 1
state 1
- Louisiana · 779 ✖
fips 1
- 22113 779
county 1
- Vermilion · 779 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500756 | 2500756 | 2022-05-13 | Vermilion | Louisiana | 22113 | 15334 | 224 |
2497498 | 2497498 | 2022-05-12 | Vermilion | Louisiana | 22113 | 15328 | 224 |
2494240 | 2494240 | 2022-05-11 | Vermilion | Louisiana | 22113 | 15323 | 224 |
2490982 | 2490982 | 2022-05-10 | Vermilion | Louisiana | 22113 | 15320 | 224 |
2487725 | 2487725 | 2022-05-09 | Vermilion | Louisiana | 22113 | 15315 | 224 |
2484467 | 2484467 | 2022-05-08 | Vermilion | Louisiana | 22113 | 15312 | 223 |
2481209 | 2481209 | 2022-05-07 | Vermilion | Louisiana | 22113 | 15312 | 223 |
2477951 | 2477951 | 2022-05-06 | Vermilion | Louisiana | 22113 | 15312 | 223 |
2474693 | 2474693 | 2022-05-05 | Vermilion | Louisiana | 22113 | 15310 | 223 |
2471436 | 2471436 | 2022-05-04 | Vermilion | Louisiana | 22113 | 15305 | 223 |
2468180 | 2468180 | 2022-05-03 | Vermilion | Louisiana | 22113 | 15305 | 223 |
2464925 | 2464925 | 2022-05-02 | Vermilion | Louisiana | 22113 | 15303 | 223 |
2461669 | 2461669 | 2022-05-01 | Vermilion | Louisiana | 22113 | 15303 | 223 |
2458413 | 2458413 | 2022-04-30 | Vermilion | Louisiana | 22113 | 15303 | 223 |
2455157 | 2455157 | 2022-04-29 | Vermilion | Louisiana | 22113 | 15303 | 223 |
2451901 | 2451901 | 2022-04-28 | Vermilion | Louisiana | 22113 | 15302 | 223 |
2448645 | 2448645 | 2022-04-27 | Vermilion | Louisiana | 22113 | 15300 | 223 |
2445389 | 2445389 | 2022-04-26 | Vermilion | Louisiana | 22113 | 15298 | 223 |
2442133 | 2442133 | 2022-04-25 | Vermilion | Louisiana | 22113 | 15297 | 223 |
2438877 | 2438877 | 2022-04-24 | Vermilion | Louisiana | 22113 | 15297 | 223 |
2435621 | 2435621 | 2022-04-23 | Vermilion | Louisiana | 22113 | 15297 | 223 |
2432365 | 2432365 | 2022-04-22 | Vermilion | Louisiana | 22113 | 15297 | 223 |
2429109 | 2429109 | 2022-04-21 | Vermilion | Louisiana | 22113 | 15296 | 223 |
2425853 | 2425853 | 2022-04-20 | Vermilion | Louisiana | 22113 | 15296 | 223 |
2422597 | 2422597 | 2022-04-19 | Vermilion | Louisiana | 22113 | 15296 | 223 |
2419341 | 2419341 | 2022-04-18 | Vermilion | Louisiana | 22113 | 15295 | 223 |
2416085 | 2416085 | 2022-04-17 | Vermilion | Louisiana | 22113 | 15292 | 223 |
2412829 | 2412829 | 2022-04-16 | Vermilion | Louisiana | 22113 | 15292 | 223 |
2409573 | 2409573 | 2022-04-15 | Vermilion | Louisiana | 22113 | 15292 | 223 |
2406317 | 2406317 | 2022-04-14 | Vermilion | Louisiana | 22113 | 15292 | 223 |
2403061 | 2403061 | 2022-04-13 | Vermilion | Louisiana | 22113 | 15248 | 223 |
2399807 | 2399807 | 2022-04-12 | Vermilion | Louisiana | 22113 | 15248 | 223 |
2396551 | 2396551 | 2022-04-11 | Vermilion | Louisiana | 22113 | 15246 | 223 |
2393296 | 2393296 | 2022-04-10 | Vermilion | Louisiana | 22113 | 15244 | 223 |
2390040 | 2390040 | 2022-04-09 | Vermilion | Louisiana | 22113 | 15244 | 223 |
2386784 | 2386784 | 2022-04-08 | Vermilion | Louisiana | 22113 | 15244 | 223 |
2383529 | 2383529 | 2022-04-07 | Vermilion | Louisiana | 22113 | 15244 | 223 |
2380274 | 2380274 | 2022-04-06 | Vermilion | Louisiana | 22113 | 15243 | 223 |
2377019 | 2377019 | 2022-04-05 | Vermilion | Louisiana | 22113 | 15243 | 223 |
2373767 | 2373767 | 2022-04-04 | Vermilion | Louisiana | 22113 | 15242 | 223 |
2370514 | 2370514 | 2022-04-03 | Vermilion | Louisiana | 22113 | 15240 | 223 |
2367261 | 2367261 | 2022-04-02 | Vermilion | Louisiana | 22113 | 15240 | 223 |
2364008 | 2364008 | 2022-04-01 | Vermilion | Louisiana | 22113 | 15240 | 223 |
2360754 | 2360754 | 2022-03-31 | Vermilion | Louisiana | 22113 | 15239 | 223 |
2357500 | 2357500 | 2022-03-30 | Vermilion | Louisiana | 22113 | 15239 | 223 |
2354247 | 2354247 | 2022-03-29 | Vermilion | Louisiana | 22113 | 15239 | 223 |
2350995 | 2350995 | 2022-03-28 | Vermilion | Louisiana | 22113 | 15239 | 223 |
2347742 | 2347742 | 2022-03-27 | Vermilion | Louisiana | 22113 | 15238 | 223 |
2344489 | 2344489 | 2022-03-26 | Vermilion | Louisiana | 22113 | 15238 | 223 |
2341236 | 2341236 | 2022-03-25 | Vermilion | Louisiana | 22113 | 15238 | 223 |
2337983 | 2337983 | 2022-03-24 | Vermilion | Louisiana | 22113 | 15235 | 223 |
2334729 | 2334729 | 2022-03-23 | Vermilion | Louisiana | 22113 | 15234 | 223 |
2331475 | 2331475 | 2022-03-22 | Vermilion | Louisiana | 22113 | 15234 | 223 |
2328223 | 2328223 | 2022-03-21 | Vermilion | Louisiana | 22113 | 15233 | 222 |
2324970 | 2324970 | 2022-03-20 | Vermilion | Louisiana | 22113 | 15231 | 222 |
2321716 | 2321716 | 2022-03-19 | Vermilion | Louisiana | 22113 | 15231 | 222 |
2318462 | 2318462 | 2022-03-18 | Vermilion | Louisiana | 22113 | 15231 | 222 |
2315209 | 2315209 | 2022-03-17 | Vermilion | Louisiana | 22113 | 15230 | 222 |
2311956 | 2311956 | 2022-03-16 | Vermilion | Louisiana | 22113 | 15228 | 222 |
2308703 | 2308703 | 2022-03-15 | Vermilion | Louisiana | 22113 | 15226 | 222 |
2305452 | 2305452 | 2022-03-14 | Vermilion | Louisiana | 22113 | 15225 | 222 |
2302200 | 2302200 | 2022-03-13 | Vermilion | Louisiana | 22113 | 15224 | 222 |
2298948 | 2298948 | 2022-03-12 | Vermilion | Louisiana | 22113 | 15224 | 222 |
2295696 | 2295696 | 2022-03-11 | Vermilion | Louisiana | 22113 | 15224 | 222 |
2292444 | 2292444 | 2022-03-10 | Vermilion | Louisiana | 22113 | 15221 | 222 |
2289192 | 2289192 | 2022-03-09 | Vermilion | Louisiana | 22113 | 15219 | 222 |
2285941 | 2285941 | 2022-03-08 | Vermilion | Louisiana | 22113 | 15214 | 222 |
2282689 | 2282689 | 2022-03-07 | Vermilion | Louisiana | 22113 | 15212 | 221 |
2279436 | 2279436 | 2022-03-06 | Vermilion | Louisiana | 22113 | 15207 | 219 |
2276183 | 2276183 | 2022-03-05 | Vermilion | Louisiana | 22113 | 15207 | 219 |
2272930 | 2272930 | 2022-03-04 | Vermilion | Louisiana | 22113 | 15207 | 219 |
2269678 | 2269678 | 2022-03-03 | Vermilion | Louisiana | 22113 | 15200 | 218 |
2266425 | 2266425 | 2022-03-02 | Vermilion | Louisiana | 22113 | 15197 | 217 |
2263174 | 2263174 | 2022-03-01 | Vermilion | Louisiana | 22113 | 15169 | 216 |
2259923 | 2259923 | 2022-02-28 | Vermilion | Louisiana | 22113 | 15169 | 216 |
2256672 | 2256672 | 2022-02-27 | Vermilion | Louisiana | 22113 | 15169 | 216 |
2253421 | 2253421 | 2022-02-26 | Vermilion | Louisiana | 22113 | 15169 | 216 |
2250170 | 2250170 | 2022-02-25 | Vermilion | Louisiana | 22113 | 15169 | 216 |
2246919 | 2246919 | 2022-02-24 | Vermilion | Louisiana | 22113 | 15158 | 215 |
2243668 | 2243668 | 2022-02-23 | Vermilion | Louisiana | 22113 | 15150 | 215 |
2240417 | 2240417 | 2022-02-22 | Vermilion | Louisiana | 22113 | 15131 | 214 |
2237166 | 2237166 | 2022-02-21 | Vermilion | Louisiana | 22113 | 15120 | 214 |
2233915 | 2233915 | 2022-02-20 | Vermilion | Louisiana | 22113 | 15085 | 214 |
2230664 | 2230664 | 2022-02-19 | Vermilion | Louisiana | 22113 | 15085 | 214 |
2227413 | 2227413 | 2022-02-18 | Vermilion | Louisiana | 22113 | 15085 | 214 |
2224162 | 2224162 | 2022-02-17 | Vermilion | Louisiana | 22113 | 15072 | 213 |
2220911 | 2220911 | 2022-02-16 | Vermilion | Louisiana | 22113 | 15051 | 212 |
2217660 | 2217660 | 2022-02-15 | Vermilion | Louisiana | 22113 | 15027 | 212 |
2214409 | 2214409 | 2022-02-14 | Vermilion | Louisiana | 22113 | 14997 | 212 |
2211157 | 2211157 | 2022-02-13 | Vermilion | Louisiana | 22113 | 14953 | 210 |
2207904 | 2207904 | 2022-02-12 | Vermilion | Louisiana | 22113 | 14953 | 210 |
2204651 | 2204651 | 2022-02-11 | Vermilion | Louisiana | 22113 | 14953 | 210 |
2201398 | 2201398 | 2022-02-10 | Vermilion | Louisiana | 22113 | 14905 | 210 |
2198144 | 2198144 | 2022-02-09 | Vermilion | Louisiana | 22113 | 14881 | 209 |
2194890 | 2194890 | 2022-02-08 | Vermilion | Louisiana | 22113 | 14834 | 209 |
2191636 | 2191636 | 2022-02-07 | Vermilion | Louisiana | 22113 | 14788 | 209 |
2188383 | 2188383 | 2022-02-06 | Vermilion | Louisiana | 22113 | 14669 | 205 |
2185130 | 2185130 | 2022-02-05 | Vermilion | Louisiana | 22113 | 14669 | 205 |
2181878 | 2181878 | 2022-02-04 | Vermilion | Louisiana | 22113 | 14669 | 205 |
2178627 | 2178627 | 2022-02-03 | Vermilion | Louisiana | 22113 | 14610 | 205 |
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);