home / civic

Menu
  • Log in

lofin365_portal_raw

Data license: 비공개

6 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: collected_at (date)

id ▼ api_code api_name laf_cd inq_yr rn row_data collected_at
1 SIHHC 세입현황 30 2024 0 {"nextSnum": 0, "bfSnum": 0, "amt1": 0, "amt2": 0, "amt3": 0, "amt4": 0, "amt5": 0, "amt6": 0, "amt7": 0, "amt8": 0, "amt9": 0, "amt10": 0, "amt11": 0, "amt12": 0, "amt13": 0, "amt14": 0, "amt15": 0, "amt16": 0, "amt17": 0, "amt18": 0, "amt19": 0, "amt20": 0, "amtGrp": 0, "showDepth": "", "lafCd": "", "lupOrd": 0, "code": "", "code2": "", "code3": "", "code4": "", "codeNm": "", "codeNm2": "", "codeNm3": "", "codeNm4": "", "codeNm5": "", "codeNm6": "", "comDtsCd": "3000000", "comDtsCdNm": "대전본청", "rclyYmd": "", "fldCd": ""} 2026-06-25 00:39:59
2 SIHHC 세입현황 30 2024 1 {"nextSnum": 0, "bfSnum": 0, "amt1": 0, "amt2": 0, "amt3": 0, "amt4": 0, "amt5": 0, "amt6": 0, "amt7": 0, "amt8": 0, "amt9": 0, "amt10": 0, "amt11": 0, "amt12": 0, "amt13": 0, "amt14": 0, "amt15": 0, "amt16": 0, "amt17": 0, "amt18": 0, "amt19": 0, "amt20": 0, "amtGrp": 0, "showDepth": "", "lafCd": "", "lupOrd": 0, "code": "", "code2": "", "code3": "", "code4": "", "codeNm": "", "codeNm2": "", "codeNm3": "", "codeNm4": "", "codeNm5": "", "codeNm6": "", "comDtsCd": "3011000", "comDtsCdNm": "대전동구", "rclyYmd": "", "fldCd": ""} 2026-06-25 00:39:59
3 SIHHC 세입현황 30 2024 2 {"nextSnum": 0, "bfSnum": 0, "amt1": 0, "amt2": 0, "amt3": 0, "amt4": 0, "amt5": 0, "amt6": 0, "amt7": 0, "amt8": 0, "amt9": 0, "amt10": 0, "amt11": 0, "amt12": 0, "amt13": 0, "amt14": 0, "amt15": 0, "amt16": 0, "amt17": 0, "amt18": 0, "amt19": 0, "amt20": 0, "amtGrp": 0, "showDepth": "", "lafCd": "", "lupOrd": 0, "code": "", "code2": "", "code3": "", "code4": "", "codeNm": "", "codeNm2": "", "codeNm3": "", "codeNm4": "", "codeNm5": "", "codeNm6": "", "comDtsCd": "3012000", "comDtsCdNm": "대전중구", "rclyYmd": "", "fldCd": ""} 2026-06-25 00:39:59
4 SIHHC 세입현황 30 2024 3 {"nextSnum": 0, "bfSnum": 0, "amt1": 0, "amt2": 0, "amt3": 0, "amt4": 0, "amt5": 0, "amt6": 0, "amt7": 0, "amt8": 0, "amt9": 0, "amt10": 0, "amt11": 0, "amt12": 0, "amt13": 0, "amt14": 0, "amt15": 0, "amt16": 0, "amt17": 0, "amt18": 0, "amt19": 0, "amt20": 0, "amtGrp": 0, "showDepth": "", "lafCd": "", "lupOrd": 0, "code": "", "code2": "", "code3": "", "code4": "", "codeNm": "", "codeNm2": "", "codeNm3": "", "codeNm4": "", "codeNm5": "", "codeNm6": "", "comDtsCd": "3013000", "comDtsCdNm": "대전서구", "rclyYmd": "", "fldCd": ""} 2026-06-25 00:39:59
5 SIHHC 세입현황 30 2024 4 {"nextSnum": 0, "bfSnum": 0, "amt1": 0, "amt2": 0, "amt3": 0, "amt4": 0, "amt5": 0, "amt6": 0, "amt7": 0, "amt8": 0, "amt9": 0, "amt10": 0, "amt11": 0, "amt12": 0, "amt13": 0, "amt14": 0, "amt15": 0, "amt16": 0, "amt17": 0, "amt18": 0, "amt19": 0, "amt20": 0, "amtGrp": 0, "showDepth": "", "lafCd": "", "lupOrd": 0, "code": "", "code2": "", "code3": "", "code4": "", "codeNm": "", "codeNm2": "", "codeNm3": "", "codeNm4": "", "codeNm5": "", "codeNm6": "", "comDtsCd": "3014000", "comDtsCdNm": "대전유성구", "rclyYmd": "", "fldCd": ""} 2026-06-25 00:39:59
6 SIHHC 세입현황 30 2024 5 {"nextSnum": 0, "bfSnum": 0, "amt1": 0, "amt2": 0, "amt3": 0, "amt4": 0, "amt5": 0, "amt6": 0, "amt7": 0, "amt8": 0, "amt9": 0, "amt10": 0, "amt11": 0, "amt12": 0, "amt13": 0, "amt14": 0, "amt15": 0, "amt16": 0, "amt17": 0, "amt18": 0, "amt19": 0, "amt20": 0, "amtGrp": 0, "showDepth": "", "lafCd": "", "lupOrd": 0, "code": "", "code2": "", "code3": "", "code4": "", "codeNm": "", "codeNm2": "", "codeNm3": "", "codeNm4": "", "codeNm5": "", "codeNm6": "", "comDtsCd": "3015000", "comDtsCdNm": "대전대덕구", "rclyYmd": "", "fldCd": ""} 2026-06-25 00:39:59

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE lofin365_portal_raw (
            id           INTEGER PRIMARY KEY AUTOINCREMENT,
            api_code     TEXT NOT NULL,
            api_name     TEXT NOT NULL,
            laf_cd       TEXT NOT NULL,
            inq_yr       TEXT NOT NULL,
            rn           INTEGER NOT NULL DEFAULT 0,
            row_data     TEXT NOT NULL,
            collected_at TEXT NOT NULL,
            UNIQUE(api_code, laf_cd, inq_yr, rn)
        );
CREATE INDEX idx_lofin_portal_api_yr ON lofin365_portal_raw(api_code, inq_yr);
Powered by Datasette · Queries took 23.662ms · Data license: 비공개