goamines

Queries

Tables schema

closing_stock

id, as_of_date, ore_stream, location_raw, balance_mt, stock_type, source_file

216 rows

ore_stream, location, location_type, has_2024_baseline, opening_2024, trips_in, tons_in, trips_out, tons_out, net_all, min_running_balance, min_balance_dt, reconstructed_2025, reported_2025, recon_diff, goes_negative

166 rows

location_flows

location, ore_stream, trips_in, tonnage_in, trips_out, tonnage_out, net_tonnage

59 rows

location_map

location, location_type, state, country, latitude, longitude, geocode_source, tonnage_in, tonnage_out

46 rows

locations

canonical_name, location_type, state, country, lat, lon, geocode_source, geocode_note, notes

244 rows

monthly

month, ore_stream, trips, tonnage

49 rows

permits

id, permit_no, software_era, ore_stream, category, is_superseded, permit_type, issue_date, validity_date, application_date, status, financial_year, org_code, org_name, mineral_type, ore_type, ore_category, grade_slab, exact_grade, permit_qty, used_qty, balance_qty, source_location_raw, dest_location_raw, transport_mode, state, country, district, tehsil, vessel_name, buyer_name, trader_name, trader_code, export_sale_permit_no, export_permit_date, challan_no, imp_exp_type, imp_exp_address, imp_exp_party, source_file, source_sheet

>10,000 rows

routes

source, destination, ore_stream, trips, tonnage, tonnage_src, delta, first_trip, last_trip

68 rows

trips

id, permit_no, ore_stream, vehicle_or_barge, source_location_raw, dest_location_raw, start_dt, end_dt, qty_source, qty_dest, qty_delta, source_file, source_sheet