search

ExpDev07 / coronavirus-tracker-api

🦠 A simple and fast (< 200ms) API for tracking the global coronavirus (COVID-19, SARS-CoV-2) outbreak. It's written in python using the 🔥 FastAPI framework. Supports multiple sources!
https://coronavirus-tracker-api.herokuapp.com
GNU General Public License v3.0
1.59k stars 323 forks source link

[CSBS] New Jersey showing 0 deaths #241

Open nguyandy opened 4 years ago

nguyandy commented 4 years ago

At the time of posting, it's at 198.

It looks like on CSBS - map (https://www.csbs.org/information-covid-19-coronavirus), the death is at 198. However, it's under the state "New Jersey", county "Unassigned"

Actually, it looks like the "Unassigned" numbers are no being included at all from the https://coronavirus-tracker-api.herokuapp.com/v2/locations?source=csbs endpoint. (ex, New York has an "Unassigned" count at 278 deaths.

Kilo59 commented 4 years ago

I'm not seeing any "Unassigned" county. The next time you encounter this, it's helpful if you capture your exact HTTP request and response. With httpie you can add the -v flag to your commands.

λ http GET https://coronavirus-tracker-api.herokuapp.com/v2/locations source==csbs province=="New Jersey" -v
GET /v2/locations?source=csbs&province=New+Jersey HTTP/1.1
Accept: */*
Accept-Encoding: gzip, deflate
Connection: keep-alive
Host: coronavirus-tracker-api.herokuapp.com
User-Agent: HTTPie/2.0.0

HTTP/1.1 200 OK
Connection: keep-alive
Content-Length: 5847
Content-Type: application/json
Date: Tue, 31 Mar 2020 21:58:01 GMT
Server: uvicorn
Via: 1.1 vegur
{
    "latest": {
        "confirmed": 15010,
        "deaths": 20,
        "recovered": 0
    },
    "locations": [
        {
            "coordinates": {
                "latitude": "40.95949149",
                "longitude": "-74.074442"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Bergen",
            "id": 56,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 2909,
                "deaths": 4,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.78779259",
                "longitude": "-74.24760059"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Essex",
            "id": 57,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1900,
                "deaths": 4,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.74034231",
                "longitude": "-74.07410970000002"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Hudson",
            "id": 58,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1606,
                "deaths": 2,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.69635",
                "longitude": "-74.26957"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Union",
            "id": 59,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1418,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.86034",
                "longitude": "-74.12374"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Passaic",
            "id": 60,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1294,
                "deaths": 1,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.57936",
                "longitude": "-74.50067"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Middlesex",
            "id": 61,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1277,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.2600411",
                "longitude": "-74.22194634"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Monmouth",
            "id": 62,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1140,
                "deaths": 2,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "39.90927434",
                "longitude": "-74.2969653"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Ocean",
            "id": 63,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1022,
                "deaths": 1,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.86201902",
                "longitude": "-74.5442741"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Morris",
            "id": 64,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 841,
                "deaths": 1,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.49859",
                "longitude": "-74.52249"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Somerset",
            "id": 65,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 413,
                "deaths": 1,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.28331911",
                "longitude": "-74.70157374"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Mercer",
            "id": 66,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 268,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "39.94525",
                "longitude": "-75.11913"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Camden",
            "id": 67,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 228,
                "deaths": 3,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.07687",
                "longitude": "-74.85775"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Burlington",
            "id": 68,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 202,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "41.13934496",
                "longitude": "-74.69067762"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Sussex",
            "id": 69,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 132,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "39.71720107",
                "longitude": "-75.14164366"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Gloucester",
            "id": 70,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 114,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.56725317",
                "longitude": "-74.91217921"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Hunterdon",
            "id": 71,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 97,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.85732358",
                "longitude": "-74.997063"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Warren",
            "id": 72,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 76,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "39.4806564",
                "longitude": "-74.67264306"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Atlantic",
            "id": 73,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 31,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "39.37311491",
                "longitude": "-75.11061925"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Cumberland",
            "id": 74,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 18,
                "deaths": 1,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "38.93547",
                "longitude": "-74.92137"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Cape May",
            "id": 75,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 12,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "39.57661332",
                "longitude": "-75.35810746"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Salem",
            "id": 76,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 12,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        }
    ]
}
nguyandy commented 4 years ago

I'm not seeing any "Unassigned" county. The next time you encounter this, it's helpful if you capture your exact HTTP request and response.

Sorry I wasn't clear. This is from CSBS. image

and from 1point3acres (where CSBS is getting their data from) https://coronavirus.1point3acres.com/en image

Because the "Unassigned" data isn't being accounted for, the states data is off/incomplete

With the current API, this is the numbers I get for New Jersey image Which is 15311, however the NJ total should be 18997. If we had the numbers from "Unassigned", it would be 15311 + 3686 = 18997 172 + 95 = 267

I imagine this applies to all the states with "Unassigned" data. Hope that makes more sense.