Data on State-guaranteed loans during the COVID-19 epidemic - FranceDonnées relatives aux prêts garantis par l’État dans le cadre de l’épidémie de COVID-19 - France

Name: Data on State-guaranteed loans during the COVID-19 epidemic - France
Creator: opendatasoft

Données relatives aux prêts garantis par l’État dans le cadre de l’épidémie de COVID-19 - FranceData on State-guaranteed loans during the COVID-19 epidemic - France

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

Website Docs

This dataset provides data on State-guaranteed loans (prêts garantis par l'État, PGE) granted during the COVID-19 crisis in France. As part of an exceptional support scheme, the French Government guaranteed bank financing for companies of any size, sector or legal form, up to a total of 300 billion euros. The dataset covers loans granted until the scheme's deadline of 31 December, and can be used to analyze the geographic and sectoral distribution of guaranteed loans across French departments during the pandemic.Les prêts garantis par l'Etat durant la crise du COVID-19 Le Gouvernement met en œuvre un dispositif exceptionnel de garanties permettant de soutenir le financement bancaire des entreprises, à hauteur de 300 milliards d’euros. Jusqu’au 31 décembre prochain, les entreprises de toute taille, quelle...

⬇ Export CSV List records Select & filter Run verified request Read the docs

Trust score

How is this computed?

fair

Weighted across five axes. Tap a ring for what it measures.

Data schema (14 fields)

Filterable via the API (12)

dispositifpge_numtotalreg_codereg_namedep_codedep_namenaf_section_codenaf_section_namedate_majiso3_codetotal_meuros

Click a field to see example values.

Fill	Field	Type	Description
100%	dispositif	text	—
100%	pge_numNombre Prêts garantis par l’État	double	—
100%	totalMontant total	int	—
99.6%	reg_codeCode Région	int	—
99.6%	reg_nameNom Région	text	—
100%	dep_codeCode Département	text	—
99.6%	dep_nameNom Département	text	—
100%	naf_section_codeCode Section NAF	text	—
100%	naf_section_nameNom Section NAF	text	—
100%	date_majDate maj	date	—
—	iso3_codeCode ISO 3166 Zone	text	—
—	geomGeo Shape	geo_shape	—
—	centroidCentroide	geo_point_2d	—
—	total_meurosMontant total en M€	double	—

Schema captured from opendatasoft 7 days ago.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

Where=

Sort by

Sample data (5 records)

Record 1geom: [large value omitted] · total: 1163700

{
  "geom": "[large value omitted]",
  "total": 1163700,
  "pge_num": 6,
  "centroid": {
    "lat": 47.840516437,
    "lon": 3.563318545
  },
  "date_maj": "2021-12-31",
  "dep_code": "89",
  "dep_name": "Yonne",
  "reg_code": 27,
  "reg_name": "Bourgogne-Franche-Comté",
  "iso3_code": "FXX",
  "dispositif": "Prêts garantis par l'Etat",
  "total_meuros": 1.1637,
  "naf_section_code": "Z",
  "naf_section_name": "Non connu"
}

Record 2geom: {"type":"Feature","geometry":{"type":"Mu · total: 77576430

{
  "geom": {
    "type": "Feature",
    "geometry": {
      "type": "MultiPolygon",
      "coordinates": [
        [
          [
            [
              2.290973573,
              48.950966788
            ],
            [
              2.288332344,
              48.958388156
            ],
            [
              2.298877267,
              48.96630989
            ],
            [
              2.322688565,
              48.957526005
            ],
            [
              2.336355321,
              48.957737316
            ],
            [
              2.343867714,
              48.968425947
            ],
            [
              2.353926334,
              48.965755798
            ],
            [
              2.365748762,
              48.974029116
            ],
            [
              2.384155895,
              48.971130527
            ],
            [
              2.407356852,
              48.956094917
            ],
            [
              2.417437001,
              48.959525541
            ],
            [
              2.437251405,
              48.955807305
            ],
            [
              2.456751766,
              48.955735375
            ],
            [
              2.467342283,
              48.964307838
            ],
            [
              2.514716274,
              48.982232948
            ],
            [
              2.532187854,
              49.005241527
            ],
            [
              2.553454258,
              49.010142297
            ],
            [
              2.569137169,
              49.011287655
            ],
            [
              2.581438856,
              48.985964308
            ],
            [
              2.579060522,
              48.979337659
            ],
            [
              2.5622042,
              48.979142441
            ],
            [
              2.589260868,
              48.953987412
            ],
            [
              2.602721055,
              48.929383988
            ],
            [
              2.589333969,
              48.922252563
            ],
            [
              2.592327238,
              48.907712351
            ],
            [
              2.583890336,
              48.894796415
            ],
            [
              2.562765227,
              48.889712016
            ],
            [
              2.568046881,
              48.874451847
            ],
            [
              2.583223586,
              48.855412945
            ],
            [
              2.574176538,
              48.85344752
            ],
            [
              2.592427458,
              48.826962382
            ],
            [
              2.59632336,
              48.811101841
            ],
            [
              2.591778181,
              48.807246093
            ],
            [
              2.569763112,
              48.815227251
            ],
            [
              2.570996064,
              48.822615464
            ],
            [
              2.539517768,
              48.839811007
            ],
            [
              2.519032683,
              48.847968424
            ],
            [
              2.50548163,
              48.857212374
            ],
            [
              2.491026854,
              48.860794084
            ],
            [
              2.469450396,
              48.86077232
            ],
            [
              2.447144184,
              48.85116529
            ],
            [
              2.416339717,
              48.849238273
            ],
            [
              2.413653025,
              48.872437161
            ],
            [
              2.399257082,
              48.885361078
            ],
            [
              2.397663724,
              48.894607075
            ],
            [
              2.384535491,
              48.902148521
            ],
            [
              2.319884459,
              48.900458867
            ],
            [
              2.313771547,
              48.914048598
            ],
            [
              2.333628861,
              48.927533292
            ],
            [
              2.332113054,
              48.94355017
            ],
            [
              2.290973573,
              48.950966788
            ]
          ]
        ]
      ]
    },
    "properties": {}
  },
  "total": 77576430,
  "pge_num": 674,
  "centroid": {
    "lat": 48.917606924,
    "lon": 2.478544126
  },
  "date_maj": "2021-12-31",
  "dep_code": "93",
  "dep_name": "Seine-Saint-Denis",
  "reg_code": 11,
  "reg_name": "Île-de-France",
  "iso3_code": "FXX",
  "dispositif": "Prêts garantis par l'Etat",
  "total_meuros": 77.57643,
  "naf_section_code": "Q",
  "naf_section_name": "Santé humaine et action sociale"
}

Record 3geom: [large value omitted] · total: 5414404

{
  "geom": "[large value omitted]",
  "total": 5414404,
  "pge_num": 247,
  "centroid": {
    "lat": 45.892295014,
    "lon": 1.234824874
  },
  "date_maj": "2021-12-31",
  "dep_code": "87",
  "dep_name": "Haute-Vienne",
  "reg_code": 75,
  "reg_name": "Nouvelle-Aquitaine",
  "iso3_code": "FXX",
  "dispositif": "Prêts garantis par l'Etat",
  "total_meuros": 5.414404,
  "naf_section_code": "S",
  "naf_section_name": "Autres activités de services"
}

Record 4geom: [large value omitted] · total: 9056437

{
  "geom": "[large value omitted]",
  "total": 9056437,
  "pge_num": 46,
  "centroid": {
    "lat": 43.785707539,
    "lon": 2.165752251
  },
  "date_maj": "2021-12-31",
  "dep_code": "81",
  "dep_name": "Tarn",
  "reg_code": 76,
  "reg_name": "Occitanie",
  "iso3_code": "FXX",
  "dispositif": "Prêts garantis par l'Etat",
  "total_meuros": 9.056437,
  "naf_section_code": "K",
  "naf_section_name": "Activités financières et d'assurance"
}

Record 5geom: [large value omitted] · total: 141686005

{
  "geom": "[large value omitted]",
  "total": 141686005,
  "pge_num": 1175,
  "centroid": {
    "lat": 47.165957497,
    "lon": 6.362730616
  },
  "date_maj": "2021-12-31",
  "dep_code": "25",
  "dep_name": "Doubs",
  "reg_code": 27,
  "reg_name": "Bourgogne-Franche-Comté",
  "iso3_code": "FXX",
  "dispositif": "Prêts garantis par l'Etat",
  "total_meuros": 141.686005,
  "naf_section_code": "G",
  "naf_section_name": "Commerce"
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Configuration

Base URL: https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/donnees-dep-prets-garantis-par-l-etat-covid19-france

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/donnees-dep-prets-garantis-par-l-etat-covid19-france/records?limit=20' -H 'Accept: application/json'

First 20 records of the dataset as JSON.

Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.

Full API documentation ↗

Rate limits

10 000 000 req/day

per ipmeasured

observed 7 days ago

Dataset

Volume & freshness

Records

1.7k

1747

Update cadence

Weekly

declared upstream

Last upstream update

4 years ago

2023-01-03

Temporal coverage

2020 → ongoing

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.