home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

647 rows where station_code = "IT0006" sorted by created_at descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

Link rowid meteor_unique_trajectory_identifier station_code created_at ▲ updated_at
2884044 2884044 20230823030134_nNRQV IT0006 2024-01-06T00:01:10.173Z 2024-01-06T00:01:10.173Z
2883804 2883804 20230823024356_P3gfW IT0006 2024-01-06T00:01:10.149Z 2024-01-06T00:01:10.149Z
2880890 2880890 20230822232849_p27Iq IT0006 2024-01-06T00:01:09.868Z 2024-01-06T00:01:09.868Z
2880679 2880679 20230822230900_YHBSP IT0006 2024-01-06T00:01:09.843Z 2024-01-06T00:01:09.843Z
2880426 2880426 20230822224610_GkQHK IT0006 2024-01-06T00:01:09.818Z 2024-01-06T00:01:09.818Z
2879741 2879741 20230822214732_qubZx IT0006 2024-01-06T00:01:09.757Z 2024-01-06T00:01:09.757Z
2879619 2879619 20230822213355_iRk50 IT0006 2024-01-06T00:01:09.747Z 2024-01-06T00:01:09.747Z
2879000 2879000 20230822193613_1sJhP IT0006 2024-01-06T00:01:09.683Z 2024-01-06T00:01:09.683Z
2860821 2860821 20230820030801_Maqki IT0006 2024-01-06T00:01:03.879Z 2024-01-06T00:01:03.879Z
2860785 2860785 20230820030459_4R06d IT0006 2024-01-06T00:01:03.874Z 2024-01-06T00:01:03.874Z
2860336 2860336 20230820023527_wo3rt IT0006 2024-01-06T00:01:03.834Z 2024-01-06T00:01:03.834Z
2859609 2859609 20230820015519_9T4V7 IT0006 2024-01-06T00:01:03.772Z 2024-01-06T00:01:03.772Z
2859388 2859388 20230820014406_nlaJ4 IT0006 2024-01-06T00:01:03.753Z 2024-01-06T00:01:03.753Z
2858848 2858848 20230820011605_CrFw8 IT0006 2024-01-06T00:01:03.708Z 2024-01-06T00:01:03.708Z
2855199 2855199 20230819204911_LTZFz IT0006 2024-01-06T00:01:03.409Z 2024-01-06T00:01:03.409Z
2763557 2763557 20230812025530_o1Edz IT0006 2024-01-06T00:00:34.875Z 2024-01-06T00:00:34.875Z
2763448 2763448 20230812025139_siNMP IT0006 2024-01-06T00:00:34.864Z 2024-01-06T00:00:34.864Z
2763414 2763414 20230812025037_FAUcw IT0006 2024-01-06T00:00:34.861Z 2024-01-06T00:00:34.861Z
2763310 2763310 20230812024709_8zmys IT0006 2024-01-06T00:00:34.850Z 2024-01-06T00:00:34.850Z
2763314 2763314 20230812024724_BEYtg IT0006 2024-01-06T00:00:34.850Z 2024-01-06T00:00:34.850Z
2762955 2762955 20230812023235_GMzxN IT0006 2024-01-06T00:00:34.817Z 2024-01-06T00:00:34.817Z
2762754 2762754 20230812022559_aHwcS IT0006 2024-01-06T00:00:34.797Z 2024-01-06T00:00:34.797Z
2762523 2762523 20230812021907_kCdov IT0006 2024-01-06T00:00:34.771Z 2024-01-06T00:00:34.771Z
2762321 2762321 20230812021254_3tziw IT0006 2024-01-06T00:00:34.750Z 2024-01-06T00:00:34.750Z
2762097 2762097 20230812020639_upszs IT0006 2024-01-06T00:00:34.729Z 2024-01-06T00:00:34.729Z
2761893 2761893 20230812015949_C6Z2P IT0006 2024-01-06T00:00:34.707Z 2024-01-06T00:00:34.707Z
2761828 2761828 20230812015703_TBj6I IT0006 2024-01-06T00:00:34.699Z 2024-01-06T00:00:34.699Z
2761783 2761783 20230812015436_sxN5s IT0006 2024-01-06T00:00:34.694Z 2024-01-06T00:00:34.694Z
2761319 2761319 20230812013824_utktJ IT0006 2024-01-06T00:00:34.645Z 2024-01-06T00:00:34.645Z
2761218 2761218 20230812013447_oPtTj IT0006 2024-01-06T00:00:34.633Z 2024-01-06T00:00:34.633Z
2760325 2760325 20230812010646_V78Qe IT0006 2024-01-06T00:00:34.534Z 2024-01-06T00:00:34.534Z
2760287 2760287 20230812010601_jTNJK IT0006 2024-01-06T00:00:34.530Z 2024-01-06T00:00:34.530Z
2760185 2760185 20230812010242_Neg7O IT0006 2024-01-06T00:00:34.518Z 2024-01-06T00:00:34.518Z
2759830 2759830 20230812004753_GSB0P IT0006 2024-01-06T00:00:34.478Z 2024-01-06T00:00:34.478Z
2759819 2759819 20230812004731_UIoUe IT0006 2024-01-06T00:00:34.477Z 2024-01-06T00:00:34.477Z
2759564 2759564 20230812003844_kWza0 IT0006 2024-01-06T00:00:34.447Z 2024-01-06T00:00:34.447Z
2759537 2759537 20230812003753_klfcq IT0006 2024-01-06T00:00:34.444Z 2024-01-06T00:00:34.444Z
2759315 2759315 20230812002913_tLACz IT0006 2024-01-06T00:00:34.417Z 2024-01-06T00:00:34.417Z
2758619 2758619 20230812000319_7aufw IT0006 2024-01-06T00:00:34.341Z 2024-01-06T00:00:34.341Z
2758498 2758498 20230811235926_9dFGX IT0006 2024-01-06T00:00:34.329Z 2024-01-06T00:00:34.329Z
2758143 2758143 20230811234747_3bNc3 IT0006 2024-01-06T00:00:34.296Z 2024-01-06T00:00:34.296Z
1587661 1587661 20220823030245_oS22C IT0006 2024-01-05T23:49:22.663Z 2024-01-05T23:49:22.663Z
1587591 1587591 20220823023644_wvk6n IT0006 2024-01-05T23:49:22.654Z 2024-01-05T23:49:22.654Z
1586544 1586544 20220822192211_4kXd9 IT0006 2024-01-05T23:49:22.506Z 2024-01-05T23:49:22.506Z
1585139 1585139 20220822013516_VsLTp IT0006 2024-01-05T23:49:20.577Z 2024-01-05T23:49:20.577Z
1585102 1585102 20220822012650_1Mesi IT0006 2024-01-05T23:49:20.573Z 2024-01-05T23:49:20.573Z
1584915 1584915 20220822004742_2N3BL IT0006 2024-01-05T23:49:20.555Z 2024-01-05T23:49:20.555Z
1584869 1584869 20220822003819_CJ32C IT0006 2024-01-05T23:49:20.549Z 2024-01-05T23:49:20.549Z
1584841 1584841 20220822003111_Sl9th IT0006 2024-01-05T23:49:20.546Z 2024-01-05T23:49:20.546Z
1584832 1584832 20220822002758_NeXZv IT0006 2024-01-05T23:49:20.545Z 2024-01-05T23:49:20.545Z
1583052 1583052 20220821031151_U3SWU IT0006 2024-01-05T23:49:18.660Z 2024-01-05T23:49:18.660Z
1582684 1582684 20220821022646_TeJPI IT0006 2024-01-05T23:49:18.608Z 2024-01-05T23:49:18.608Z
1582241 1582241 20220821013512_AWDyZ IT0006 2024-01-05T23:49:18.555Z 2024-01-05T23:49:18.555Z
1580260 1580260 20220820215133_my65H IT0006 2024-01-05T23:49:18.375Z 2024-01-05T23:49:18.375Z
1579840 1579840 20220820203021_4SfUY IT0006 2024-01-05T23:49:18.331Z 2024-01-05T23:49:18.331Z
1579786 1579786 20220820201115_UnK28 IT0006 2024-01-05T23:49:18.324Z 2024-01-05T23:49:18.324Z
1578369 1578369 20220820023149_avQHz IT0006 2024-01-05T23:49:16.451Z 2024-01-05T23:49:16.451Z
1578239 1578239 20220820021430_Tuh91 IT0006 2024-01-05T23:49:16.439Z 2024-01-05T23:49:16.439Z
1578209 1578209 20220820020949_I3qZw IT0006 2024-01-05T23:49:16.434Z 2024-01-05T23:49:16.434Z
1577986 1577986 20220820014301_52Xds IT0006 2024-01-05T23:49:16.411Z 2024-01-05T23:49:16.411Z
1577092 1577092 20220820000856_bNEDn IT0006 2024-01-05T23:49:16.329Z 2024-01-05T23:49:16.329Z
1576897 1576897 20220819233130_epegO IT0006 2024-01-05T23:49:16.311Z 2024-01-05T23:49:16.311Z
1564373 1564373 20220814202931_L1bWd IT0006 2024-01-05T23:49:08.463Z 2024-01-05T23:49:08.463Z
1562142 1562142 20220814030318_witai IT0006 2024-01-05T23:49:08.198Z 2024-01-05T23:49:08.198Z
1562098 1562098 20220814030035_X8R2C IT0006 2024-01-05T23:49:08.194Z 2024-01-05T23:49:08.194Z
1562054 1562054 20220814025756_dd3zK IT0006 2024-01-05T23:49:08.191Z 2024-01-05T23:49:08.191Z
1562029 1562029 20220814025701_WOJ2C IT0006 2024-01-05T23:49:08.188Z 2024-01-05T23:49:08.188Z
1561622 1561622 20220814023229_e3Zo1 IT0006 2024-01-05T23:49:08.147Z 2024-01-05T23:49:08.147Z
1561313 1561313 20220814021854_aD7XH IT0006 2024-01-05T23:49:06.850Z 2024-01-05T23:49:06.850Z
1561276 1561276 20220814021659_1aC7d IT0006 2024-01-05T23:49:06.845Z 2024-01-05T23:49:06.845Z
1561205 1561205 20220814021152_i88Hi IT0006 2024-01-05T23:49:06.836Z 2024-01-05T23:49:06.836Z
1561192 1561192 20220814021058_lm7X5 IT0006 2024-01-05T23:49:06.835Z 2024-01-05T23:49:06.835Z
1561129 1561129 20220814020742_KNjMr IT0006 2024-01-05T23:49:06.827Z 2024-01-05T23:49:06.827Z
1561069 1561069 20220814020455_f3cZd IT0006 2024-01-05T23:49:06.820Z 2024-01-05T23:49:06.820Z
1561019 1561019 20220814020316_2AKQz IT0006 2024-01-05T23:49:06.815Z 2024-01-05T23:49:06.815Z
1560793 1560793 20220814015509_OAZ8z IT0006 2024-01-05T23:49:06.791Z 2024-01-05T23:49:06.791Z
1560367 1560367 20220814013357_U4Pmq IT0006 2024-01-05T23:49:06.742Z 2024-01-05T23:49:06.742Z
1560356 1560356 20220814013259_tpBXQ IT0006 2024-01-05T23:49:06.740Z 2024-01-05T23:49:06.740Z
1560323 1560323 20220814013216_iL3YJ IT0006 2024-01-05T23:49:06.737Z 2024-01-05T23:49:06.737Z
1560259 1560259 20220814012741_PcpS6 IT0006 2024-01-05T23:49:06.728Z 2024-01-05T23:49:06.728Z
1560060 1560060 20220814011520_oi2QL IT0006 2024-01-05T23:49:06.703Z 2024-01-05T23:49:06.703Z
1560033 1560033 20220814011335_ZtakZ IT0006 2024-01-05T23:49:06.699Z 2024-01-05T23:49:06.699Z
1559609 1559609 20220814005329_Eiqag IT0006 2024-01-05T23:49:06.650Z 2024-01-05T23:49:06.650Z
1559534 1559534 20220814005049_vJwf3 IT0006 2024-01-05T23:49:06.641Z 2024-01-05T23:49:06.641Z
1559482 1559482 20220814004848_ZYzEi IT0006 2024-01-05T23:49:06.637Z 2024-01-05T23:49:06.637Z
1558968 1558968 20220814002240_Qc3pm IT0006 2024-01-05T23:49:06.582Z 2024-01-05T23:49:06.582Z
1555849 1555849 20220813213106_WopIk IT0006 2024-01-05T23:49:06.209Z 2024-01-05T23:49:06.209Z
1554865 1554865 20220813200816_5wl4o IT0006 2024-01-05T23:49:06.093Z 2024-01-05T23:49:06.093Z
1554845 1554845 20220813195458_fAJmF IT0006 2024-01-05T23:49:06.089Z 2024-01-05T23:49:06.089Z
1554829 1554829 20220813194409_9eQvj IT0006 2024-01-05T23:49:06.087Z 2024-01-05T23:49:06.087Z
1421140 1421140 20220716215031_LKVyr IT0006 2024-01-05T23:47:56.086Z 2024-01-05T23:47:56.086Z
1414624 1414624 20220711021807_7lZE0 IT0006 2024-01-05T23:47:45.629Z 2024-01-05T23:47:45.629Z
1414578 1414578 20220711020744_3oQCd IT0006 2024-01-05T23:47:45.619Z 2024-01-05T23:47:45.619Z
1413244 1413244 20220710233835_lLuIq IT0006 2024-01-05T23:47:45.340Z 2024-01-05T23:47:45.340Z
1413204 1413204 20220710233212_t3z30 IT0006 2024-01-05T23:47:45.331Z 2024-01-05T23:47:45.331Z
1413045 1413045 20220710230112_gxi7Y IT0006 2024-01-05T23:47:45.296Z 2024-01-05T23:47:45.296Z
1412870 1412870 20220710215127_Ff4OC IT0006 2024-01-05T23:47:45.256Z 2024-01-05T23:47:45.256Z
1411275 1411275 20220710011008_nzfcq IT0006 2024-01-05T23:47:43.064Z 2024-01-05T23:47:43.064Z
1411087 1411087 20220710005417_rPs7n IT0006 2024-01-05T23:47:43.013Z 2024-01-05T23:47:43.013Z
1410725 1410725 20220710001157_jv61E IT0006 2024-01-05T23:47:42.902Z 2024-01-05T23:47:42.902Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE participating_station
(
    meteor_unique_trajectory_identifier text     NOT NULL,
    station_code                        text     NOT NULL,
    created_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    updated_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier),
    FOREIGN KEY (station_code) REFERENCES station (code),
    UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE
);
CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier);
CREATE INDEX participating_station_created_at_index ON participating_station (created_at);
CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network