Food Claim

Running SQL on Pandas

@kaggle.vyhn00_food_claim

Table List

1 table(54.59 KB)

Food Claims 2212

@kaggle.vyhn00_food_claim.food_claims_2212

54.59 KB
2000 rows
8 columns

claim_id Claim Id	time_to_close Time To Close	claim_amount Claim Amount	amount_paid Amount Paid	location Location	individuals_on_claim Individuals On Claim	linked_cases Linked Cases	cause Cause
1	317	R$ 74474.55	51231.37	RECIFE	15	False	unknown
2	195	R$ 52137.83	42111.3	FORTALEZA	12	True	unknown
3	183	R$ 24447.2	23986.3	SAO LUIS	10	True	meat
4	186	R$ 29006.28	27942.72	FORTALEZA	11	False	meat
5	138	R$ 19520.6	16251.06	RECIFE	11	False	vegetable
6	183	R$ 47529.14	38011.98	NATAL	11	False	unknown
7	190	R$ 39073.26	29826.04	SAO LUIS	12	False	meat
8	183	R$ 29870.56	29727.52	SAO LUIS	8	True	unknown
9	149	R$ 26644.46	23362.14	RECIFE	9	False	meat
10	149	R$ 11544.68	9680.82	NATAL	6	False	vegetable


CREATE TABLE food_claims_2212 (
  "claim_id" BIGINT,
  "time_to_close" BIGINT,
  "claim_amount" VARCHAR,
  "amount_paid" DOUBLE,
  "location" VARCHAR,
  "individuals_on_claim" BIGINT,
  "linked_cases" VARCHAR,
  "cause" VARCHAR
);