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

1,010 rows where station_code = "ES001D" 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
8647718 8647718 20251129051407_grcaJ ES001D 2025-11-30T14:28:48.544Z 2025-12-06T14:56:45.030Z
8647534 8647534 20251129044809_V0rSe ES001D 2025-11-30T14:28:33.476Z 2025-12-06T14:56:40.677Z
8647401 8647401 20251129043124_kEnQu ES001D 2025-11-30T14:28:06.360Z 2025-12-06T14:56:38.157Z
8646910 8646910 20251129031048_8HRgL ES001D 2025-11-30T14:27:06.841Z 2025-12-06T14:56:27.725Z
8646787 8646787 20251129025355_LanTn ES001D 2025-11-30T14:26:57.812Z 2025-12-06T14:56:25.186Z
8646661 8646661 20251129023728_jaPoX ES001D 2025-11-30T14:26:37.768Z 2025-12-06T14:56:22.844Z
8637125 8637125 20251128050241_ecHwi ES001D 2025-11-29T14:26:52.036Z 2025-12-06T15:03:56.684Z
8636882 8636882 20251128043234_FGAui ES001D 2025-11-29T14:26:17.837Z 2025-12-06T15:03:47.728Z
8636120 8636120 20251128031801_Z29CP ES001D 2025-11-29T14:24:55.708Z 2025-12-06T15:02:56.344Z
8635811 8635811 20251128024955_oitRL ES001D 2025-11-29T14:24:11.449Z 2025-12-06T15:02:52.415Z
8624432 8624432 20251127045150_gxNcP ES001D 2025-11-28T14:24:40.711Z 2025-12-05T15:05:04.987Z
8624411 8624411 20251127043922_jF6jA ES001D 2025-11-28T14:24:37.896Z 2025-12-05T15:05:04.395Z
8624343 8624343 20251127041917_r3Vuo ES001D 2025-11-28T14:24:30.075Z 2025-12-05T15:04:59.611Z
8624218 8624218 20251127034153_3CgVb ES001D 2025-11-28T14:24:02.215Z 2025-12-05T15:04:55.174Z
8624187 8624187 20251127033423_ToJNx ES001D 2025-11-28T14:23:57.719Z 2025-12-05T15:04:54.190Z
8623860 8623860 20251127021650_6HQP0 ES001D 2025-11-28T14:23:00.698Z 2025-12-05T15:04:23.278Z
8623820 8623820 20251127021026_34xKz ES001D 2025-11-28T14:22:56.942Z 2025-12-05T15:04:18.430Z
8623759 8623759 20251127015507_yeNqg ES001D 2025-11-28T14:22:49.511Z 2025-12-05T15:04:15.082Z
8623388 8623388 20251127001949_fEL8g ES001D 2025-11-28T14:21:37.788Z 2025-12-05T15:03:48.419Z
8623256 8623256 20251126233640_icXtJ ES001D 2025-11-28T14:21:24.314Z 2025-12-05T15:03:40.985Z
8623138 8623138 20251126225835_PwCc2 ES001D 2025-11-28T14:20:56.412Z 2025-12-05T15:03:30.925Z
8622769 8622769 20251126211725_3Uidy ES001D 2025-11-28T14:19:51.665Z 2025-12-05T15:03:06.204Z
8614952 8614952 20251126043835_uIugO ES001D 2025-11-27T14:28:45.376Z 2025-12-04T15:11:23.097Z
8612992 8612992 20251126025807_KHeii ES001D 2025-11-27T14:25:04.424Z 2025-12-04T15:09:36.346Z
8610100 8610100 20251126002131_sA8gp ES001D 2025-11-27T14:19:26.357Z 2025-12-04T15:08:02.012Z
8583076 8583076 20251121045431_8VUwx ES001D 2025-11-24T14:41:22.064Z 2025-11-29T14:54:45.734Z
8583074 8583074 20251121042741_Gg6NC ES001D 2025-11-24T14:40:58.755Z 2025-11-29T14:54:44.374Z
8583068 8583068 20251121012844_moG51 ES001D 2025-11-24T14:39:59.676Z 2025-11-29T14:54:31.421Z
8583060 8583060 20251120231810_xaPan ES001D 2025-11-24T14:39:16.713Z 2025-11-29T14:54:26.182Z
8583058 8583058 20251120210202_5Ki40 ES001D 2025-11-24T14:38:41.427Z 2025-11-29T14:54:22.847Z
8580753 8580753 20251122054757_iCIn3 ES001D 2025-11-24T14:28:22.562Z 2025-11-30T15:07:04.764Z
8580751 8580751 20251122052922_ovtQm ES001D 2025-11-24T14:28:11.955Z 2025-11-30T15:07:02.741Z
8580749 8580749 20251122050347_WUeIk ES001D 2025-11-24T14:27:41.713Z 2025-11-30T15:06:56.373Z
8580741 8580741 20251122042048_lc9wn ES001D 2025-11-24T14:27:04.849Z 2025-11-30T15:06:41.827Z
8580739 8580739 20251122035916_Fg3LG ES001D 2025-11-24T14:26:48.212Z 2025-11-30T15:06:36.443Z
8580727 8580727 20251122021821_yyR2K ES001D 2025-11-24T14:24:57.767Z 2025-11-30T15:06:08.632Z
8535562 8535562 20251120021837_mqB09 ES001D 2025-11-21T14:16:24.796Z 2025-11-28T14:56:47.290Z
8535138 8535138 20251120011902_5jDrw ES001D 2025-11-21T14:15:20.866Z 2025-11-28T14:56:18.586Z
8525155 8525155 20251119053813_KZlex ES001D 2025-11-20T14:22:23.619Z 2025-11-27T15:13:17.938Z
8523542 8523542 20251119021747_JnO7a ES001D 2025-11-20T14:18:44.721Z 2025-11-27T15:12:22.363Z
8523471 8523471 20251119021043_O9Kxh ES001D 2025-11-20T14:18:24.186Z 2025-11-27T15:12:21.239Z
8522312 8522312 20251118235421_rBg2q ES001D 2025-11-20T14:15:12.207Z 2025-11-27T15:12:00.063Z
8522302 8522302 20251118235229_lVEcd ES001D 2025-11-20T14:15:11.007Z 2025-11-27T15:11:59.881Z
8519988 8519988 20251118183431_2GlG2 ES001D 2025-11-20T14:08:35.681Z 2025-11-27T15:11:30.368Z
8510435 8510435 20251118044447_K13Nj ES001D 2025-11-19T14:22:01.167Z 2025-11-26T15:08:01.963Z
8510321 8510321 20251118042800_k5kxG ES001D 2025-11-19T14:21:36.645Z 2025-11-26T15:08:01.192Z
8510037 8510037 20251118035505_QjEZP ES001D 2025-11-19T14:20:58.784Z 2025-11-26T15:07:59.522Z
8509787 8509787 20251118032936_JLi5j ES001D 2025-11-19T14:20:31.036Z 2025-11-26T15:07:58.090Z
8509662 8509662 20251118031549_Nn2RJ ES001D 2025-11-19T14:20:06.467Z 2025-11-26T15:07:57.492Z
8509369 8509369 20251118023811_mHaA8 ES001D 2025-11-19T14:19:24.868Z 2025-11-26T15:07:55.345Z
8509351 8509351 20251118023432_02jEs ES001D 2025-11-19T14:19:23.064Z 2025-11-26T15:07:55.138Z
8509093 8509093 20251118020615_9bp4a ES001D 2025-11-19T14:18:49.973Z 2025-11-26T15:07:53.857Z
8508214 8508214 20251118004237_amou2 ES001D 2025-11-19T14:17:12.079Z 2025-11-26T15:07:49.827Z
8506545 8506545 20251117214346_aXtaC ES001D 2025-11-19T14:13:08.860Z 2025-11-26T15:07:42.343Z
8506345 8506345 20251117212452_447Xs ES001D 2025-11-19T14:12:40.795Z 2025-11-26T15:07:41.545Z
8495326 8495326 20251117034008_NZSYU ES001D 2025-11-18T14:26:04.237Z 2025-11-25T15:09:49.936Z
8491780 8491780 20251116231107_emi6f ES001D 2025-11-18T14:18:19.054Z 2025-11-25T15:08:42.018Z
8491572 8491572 20251116224738_V3Lq0 ES001D 2025-11-18T14:17:45.707Z 2025-11-25T15:08:40.127Z
8469200 8469200 20251115021433_tkAR9 ES001D 2025-11-16T14:19:34.490Z 2025-11-23T15:17:37.398Z
8452762 8452762 20251111194715_tZnrT ES001D 2025-11-14T14:34:40.187Z 2025-11-20T15:22:22.747Z
8450407 8450407 20251113042618_8JV17 ES001D 2025-11-14T14:23:22.698Z 2025-11-21T15:12:38.086Z
8437663 8437663 20251112003256_2MEui ES001D 2025-11-13T14:21:45.825Z 2025-11-20T15:23:49.861Z
8427899 8427899 20251111052250_IjXAW ES001D 2025-11-12T14:29:23.476Z 2025-11-19T15:18:06.851Z
8426734 8426734 20251111033737_2ZG3p ES001D 2025-11-12T14:26:15.087Z 2025-11-19T15:17:25.192Z
8425645 8425645 20251111020253_38BHw ES001D 2025-11-12T14:23:24.916Z 2025-11-19T15:16:44.800Z
8425265 8425265 20251111012708_WXGZp ES001D 2025-11-12T14:22:19.840Z 2025-11-19T15:16:36.773Z
8423262 8423262 20251110230413_X29eG ES001D 2025-11-12T14:18:12.383Z 2025-11-19T15:15:49.680Z
8421635 8421635 20251110205605_ML4NK ES001D 2025-11-12T14:14:24.868Z 2025-11-19T15:14:40.631Z
8405553 8405553 20251109034706_Hprka ES001D 2025-11-10T14:14:34.038Z 2025-11-17T14:59:00.647Z
8404828 8404828 20251109022817_B4jhV ES001D 2025-11-10T14:12:43.972Z 2025-11-17T14:58:51.245Z
8402951 8402951 20251108215344_1tm9r ES001D 2025-11-10T14:08:02.292Z 2025-11-17T14:58:29.712Z
8402819 8402819 20251108212657_iahGh ES001D 2025-11-10T14:07:42.945Z 2025-11-17T14:58:28.542Z
8402817 8402817 20251108212553_l6A9E ES001D 2025-11-10T14:07:42.448Z 2025-11-17T14:58:28.518Z
8392263 8392263 20251107050510_E2iYW ES001D 2025-11-08T14:17:40.270Z 2025-11-15T15:00:43.625Z
8371701 8371701 20251104051931_s3hw2 ES001D 2025-11-05T14:15:56.819Z 2025-11-12T15:11:05.396Z
8371658 8371658 20251104045246_Ma9Tp ES001D 2025-11-05T14:15:50.392Z 2025-11-12T15:11:04.749Z
8334120 8334120 20251031012415_cDThg ES001D 2025-11-02T14:24:25.669Z 2025-11-08T15:13:09.985Z
8322976 8322976 20251030043422_roeL4 ES001D 2025-11-01T12:30:17.650Z 2025-11-07T15:15:51.402Z
8321255 8321255 20251030032954_7oV7W ES001D 2025-11-01T12:27:36.861Z 2025-11-07T15:15:20.562Z
8317145 8317145 20251030191110_4MnXB ES001D 2025-11-01T12:08:48.424Z 2025-11-08T15:11:31.487Z
8284602 8284602 20251028045903_abCFg ES001D 2025-10-29T12:46:07.307Z 2025-11-05T15:22:52.664Z
8284341 8284341 20251028043622_eZJXS ES001D 2025-10-29T12:45:29.979Z 2025-11-05T15:22:44.675Z
8284060 8284060 20251028041901_12tdu ES001D 2025-10-29T12:45:17.850Z 2025-11-05T15:22:39.663Z
8284051 8284051 20251028041809_q1jWZ ES001D 2025-10-29T12:45:17.419Z 2025-11-05T15:22:39.594Z
8283855 8283855 20251028040513_ndt1H ES001D 2025-10-29T12:45:10.875Z 2025-11-05T15:22:34.468Z
8283801 8283801 20251028040216_YG2ak ES001D 2025-10-29T12:45:08.833Z 2025-11-05T15:22:33.050Z
8282533 8282533 20251028022942_pyhmw ES001D 2025-10-29T12:43:18.195Z 2025-10-29T12:43:18.195Z
8282412 8282412 20251028022325_sz5Z3 ES001D 2025-10-29T12:43:03.256Z 2025-11-05T15:21:43.288Z
8282281 8282281 20251028021455_vFAm4 ES001D 2025-10-29T12:42:41.151Z 2025-11-05T15:21:42.147Z
8281176 8281176 20251028005703_nq1uf ES001D 2025-10-29T12:40:33.825Z 2025-11-05T15:21:18.887Z
8281043 8281043 20251028004511_kth98 ES001D 2025-10-29T12:40:25.219Z 2025-11-05T15:21:17.467Z
8280682 8280682 20251028000011_2udJL ES001D 2025-10-29T12:39:55.540Z 2025-11-05T15:21:10.570Z
8279980 8279980 20251027224335_PltV7 ES001D 2025-10-29T12:38:23.279Z 2025-11-05T15:20:53.979Z
8279789 8279789 20251027221851_Ls4gm ES001D 2025-10-29T12:38:07.353Z 2025-11-05T15:20:49.494Z
8274129 8274129 20251027050148_o7byj ES001D 2025-10-29T12:25:16.228Z 2025-11-04T15:45:08.935Z
8273920 8273920 20251027045007_78fB4 ES001D 2025-10-29T12:24:55.317Z 2025-11-04T15:45:05.356Z
8254503 8254503 20251027040354_OY4Hz ES001D 2025-10-28T12:20:00.983Z 2025-11-04T15:44:28.172Z
8254013 8254013 20251027033931_R9TvR ES001D 2025-10-28T12:19:11.839Z 2025-11-04T15:44:17.267Z
8252411 8252411 20251027004532_rATIK ES001D 2025-10-28T12:14:57.993Z 2025-11-04T15:42:45.441Z
8252027 8252027 20251026234737_0F13F ES001D 2025-10-28T12:13:39.219Z 2025-11-04T15:42:22.309Z

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