coronavirus-tracker-api icon indicating copy to clipboard operation
coronavirus-tracker-api copied to clipboard

[CSBS] New Jersey showing 0 deaths

Open nguyandy opened this issue 5 years ago • 2 comments

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.

nguyandy avatar Mar 31 '20 04:03 nguyandy

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"
        }
    ]
}

Kilo59 avatar Mar 31 '20 22:03 Kilo59

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.

nguyandy avatar Apr 01 '20 16:04 nguyandy