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

8,353 rows where station_code = "ES000C" 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
8666105 8666105 20251201043809_W1NKj ES000C 2025-12-02T14:25:14.719Z 2025-12-06T14:42:11.787Z
8647717 8647717 20251129051407_grcaJ ES000C 2025-11-30T14:28:48.544Z 2025-12-06T14:56:45.030Z
8647533 8647533 20251129044809_V0rSe ES000C 2025-11-30T14:28:33.476Z 2025-12-06T14:56:40.677Z
8647400 8647400 20251129043124_kEnQu ES000C 2025-11-30T14:28:06.360Z 2025-12-06T14:56:38.157Z
8646924 8646924 20251129031233_kIRYK ES000C 2025-11-30T14:27:08.374Z 2025-12-06T14:56:28.028Z
8646909 8646909 20251129031048_8HRgL ES000C 2025-11-30T14:27:06.841Z 2025-12-06T14:56:27.725Z
8646660 8646660 20251129023728_jaPoX ES000C 2025-11-30T14:26:37.752Z 2025-12-06T14:56:22.844Z
8636881 8636881 20251128043234_FGAui ES000C 2025-11-29T14:26:17.837Z 2025-12-06T15:03:47.728Z
8624431 8624431 20251127045150_gxNcP ES000C 2025-11-28T14:24:40.711Z 2025-12-05T15:05:04.987Z
8624410 8624410 20251127043922_jF6jA ES000C 2025-11-28T14:24:37.896Z 2025-12-05T15:05:04.395Z
8624342 8624342 20251127041917_r3Vuo ES000C 2025-11-28T14:24:30.075Z 2025-12-05T15:04:59.611Z
8624217 8624217 20251127034153_3CgVb ES000C 2025-11-28T14:24:02.215Z 2025-12-05T15:04:55.174Z
8624186 8624186 20251127033423_ToJNx ES000C 2025-11-28T14:23:57.719Z 2025-12-05T15:04:54.189Z
8623859 8623859 20251127021650_6HQP0 ES000C 2025-11-28T14:23:00.698Z 2025-12-05T15:04:23.278Z
8623819 8623819 20251127021026_34xKz ES000C 2025-11-28T14:22:56.942Z 2025-12-05T15:04:18.430Z
8623758 8623758 20251127015507_yeNqg ES000C 2025-11-28T14:22:49.510Z 2025-12-05T15:04:15.082Z
8623387 8623387 20251127001949_fEL8g ES000C 2025-11-28T14:21:37.788Z 2025-12-05T15:03:48.419Z
8623255 8623255 20251126233640_icXtJ ES000C 2025-11-28T14:21:24.314Z 2025-12-05T15:03:40.985Z
8623137 8623137 20251126225835_PwCc2 ES000C 2025-11-28T14:20:56.401Z 2025-12-05T15:03:30.925Z
8614951 8614951 20251126043835_uIugO ES000C 2025-11-27T14:28:45.376Z 2025-12-04T15:11:23.097Z
8613555 8613555 20251126032344_uypsA ES000C 2025-11-27T14:26:13.148Z 2025-12-04T15:09:48.871Z
8612991 8612991 20251126025807_KHeii ES000C 2025-11-27T14:25:04.424Z 2025-12-04T15:09:36.346Z
8611409 8611409 20251126014037_u33T8 ES000C 2025-11-27T14:22:06.279Z 2025-12-04T15:09:11.707Z
8610099 8610099 20251126002131_sA8gp ES000C 2025-11-27T14:19:26.338Z 2025-12-04T15:08:02.012Z
8602528 8602528 20251125050111_26dPa ES000C 2025-11-26T14:26:05.445Z 2025-12-02T15:09:31.344Z
8583075 8583075 20251121045431_8VUwx ES000C 2025-11-24T14:41:22.064Z 2025-11-29T14:54:45.734Z
8583067 8583067 20251121012844_moG51 ES000C 2025-11-24T14:39:59.676Z 2025-11-29T14:54:31.420Z
8583057 8583057 20251120210202_5Ki40 ES000C 2025-11-24T14:38:41.427Z 2025-11-29T14:54:22.847Z
8580750 8580750 20251122052922_ovtQm ES000C 2025-11-24T14:28:11.955Z 2025-11-30T15:07:02.741Z
8580748 8580748 20251122050347_WUeIk ES000C 2025-11-24T14:27:41.713Z 2025-11-30T15:06:56.373Z
8580726 8580726 20251122021821_yyR2K ES000C 2025-11-24T14:24:57.721Z 2025-11-30T15:06:08.632Z
8573987 8573987 20251122045513_jB38F ES000C 2025-11-23T14:42:10.685Z 2025-11-30T15:06:54.843Z
8535561 8535561 20251120021837_mqB09 ES000C 2025-11-21T14:16:24.796Z 2025-11-28T14:56:47.290Z
8535137 8535137 20251120011902_5jDrw ES000C 2025-11-21T14:15:20.818Z 2025-11-28T14:56:18.586Z
8525154 8525154 20251119053813_KZlex ES000C 2025-11-20T14:22:23.619Z 2025-11-27T15:13:17.937Z
8523770 8523770 20251119024144_P2mNx ES000C 2025-11-20T14:19:17.339Z 2025-11-27T15:12:27.351Z
8523541 8523541 20251119021747_JnO7a ES000C 2025-11-20T14:18:44.721Z 2025-11-27T15:12:22.363Z
8523470 8523470 20251119021043_O9Kxh ES000C 2025-11-20T14:18:24.185Z 2025-11-27T15:12:21.238Z
8522311 8522311 20251118235421_rBg2q ES000C 2025-11-20T14:15:12.207Z 2025-11-27T15:12:00.063Z
8522301 8522301 20251118235229_lVEcd ES000C 2025-11-20T14:15:11.006Z 2025-11-27T15:11:59.881Z
8520845 8520845 20251118200906_xOxD5 ES000C 2025-11-20T14:11:07.690Z 2025-11-27T15:11:35.846Z
8519987 8519987 20251118183431_2GlG2 ES000C 2025-11-20T14:08:35.675Z 2025-11-27T15:11:30.368Z
8510434 8510434 20251118044447_K13Nj ES000C 2025-11-19T14:22:01.167Z 2025-11-26T15:08:01.963Z
8510320 8510320 20251118042800_k5kxG ES000C 2025-11-19T14:21:36.645Z 2025-11-26T15:08:01.192Z
8510036 8510036 20251118035505_QjEZP ES000C 2025-11-19T14:20:58.784Z 2025-11-26T15:07:59.522Z
8509786 8509786 20251118032936_JLi5j ES000C 2025-11-19T14:20:31.036Z 2025-11-26T15:07:58.089Z
8509661 8509661 20251118031549_Nn2RJ ES000C 2025-11-19T14:20:06.467Z 2025-11-26T15:07:57.492Z
8509368 8509368 20251118023811_mHaA8 ES000C 2025-11-19T14:19:24.868Z 2025-11-26T15:07:55.345Z
8509350 8509350 20251118023432_02jEs ES000C 2025-11-19T14:19:23.064Z 2025-11-26T15:07:55.138Z
8509092 8509092 20251118020615_9bp4a ES000C 2025-11-19T14:18:49.973Z 2025-11-26T15:07:53.857Z
8508213 8508213 20251118004237_amou2 ES000C 2025-11-19T14:17:12.079Z 2025-11-26T15:07:49.827Z
8506544 8506544 20251117214346_aXtaC ES000C 2025-11-19T14:13:08.860Z 2025-11-26T15:07:42.343Z
8506344 8506344 20251117212452_447Xs ES000C 2025-11-19T14:12:40.766Z 2025-11-26T15:07:41.545Z
8495325 8495325 20251117034008_NZSYU ES000C 2025-11-18T14:26:04.237Z 2025-11-25T15:09:49.936Z
8491779 8491779 20251116231107_emi6f ES000C 2025-11-18T14:18:19.054Z 2025-11-25T15:08:42.018Z
8491571 8491571 20251116224738_V3Lq0 ES000C 2025-11-18T14:17:45.695Z 2025-11-25T15:08:40.127Z
8450406 8450406 20251113042618_8JV17 ES000C 2025-11-14T14:23:22.676Z 2025-11-21T15:12:38.086Z
8437662 8437662 20251112003256_2MEui ES000C 2025-11-13T14:21:45.825Z 2025-11-20T15:23:49.861Z
8426733 8426733 20251111033737_2ZG3p ES000C 2025-11-12T14:26:15.087Z 2025-11-19T15:17:25.192Z
8425644 8425644 20251111020253_38BHw ES000C 2025-11-12T14:23:24.916Z 2025-11-19T15:16:44.800Z
8425264 8425264 20251111012708_WXGZp ES000C 2025-11-12T14:22:19.840Z 2025-11-19T15:16:36.773Z
8423261 8423261 20251110230413_X29eG ES000C 2025-11-12T14:18:12.383Z 2025-11-19T15:15:49.679Z
8421634 8421634 20251110205605_ML4NK ES000C 2025-11-12T14:14:24.854Z 2025-11-19T15:14:40.631Z
8405552 8405552 20251109034706_Hprka ES000C 2025-11-10T14:14:34.038Z 2025-11-17T14:59:00.647Z
8404827 8404827 20251109022817_B4jhV ES000C 2025-11-10T14:12:43.972Z 2025-11-17T14:58:51.245Z
8403696 8403696 20251109000016_gepgw ES000C 2025-11-10T14:09:41.798Z 2025-11-17T14:58:38.189Z
8402950 8402950 20251108215344_1tm9r ES000C 2025-11-10T14:08:02.292Z 2025-11-17T14:58:29.712Z
8402816 8402816 20251108212553_l6A9E ES000C 2025-11-10T14:07:42.448Z 2025-11-17T14:58:28.518Z
8392262 8392262 20251107050510_E2iYW ES000C 2025-11-08T14:17:40.253Z 2025-11-15T15:00:43.625Z
8371700 8371700 20251104051931_s3hw2 ES000C 2025-11-05T14:15:56.819Z 2025-11-12T15:11:05.396Z
8371657 8371657 20251104045246_Ma9Tp ES000C 2025-11-05T14:15:50.378Z 2025-11-12T15:11:04.749Z
8334119 8334119 20251031012415_cDThg ES000C 2025-11-02T14:24:25.650Z 2025-11-08T15:13:09.985Z
8322975 8322975 20251030043422_roeL4 ES000C 2025-11-01T12:30:17.650Z 2025-11-07T15:15:51.402Z
8317144 8317144 20251030191110_4MnXB ES000C 2025-11-01T12:08:48.424Z 2025-11-08T15:11:31.487Z
8284601 8284601 20251028045903_abCFg ES000C 2025-10-29T12:46:07.307Z 2025-11-05T15:22:52.664Z
8284340 8284340 20251028043622_eZJXS ES000C 2025-10-29T12:45:29.979Z 2025-11-05T15:22:44.675Z
8284059 8284059 20251028041901_12tdu ES000C 2025-10-29T12:45:17.850Z 2025-11-05T15:22:39.663Z
8284050 8284050 20251028041809_q1jWZ ES000C 2025-10-29T12:45:17.419Z 2025-11-05T15:22:39.594Z
8283854 8283854 20251028040513_ndt1H ES000C 2025-10-29T12:45:10.875Z 2025-11-05T15:22:34.467Z
8283800 8283800 20251028040216_YG2ak ES000C 2025-10-29T12:45:08.833Z 2025-11-05T15:22:33.050Z
8283625 8283625 20251028035138_Q1egn ES000C 2025-10-29T12:45:00.520Z 2025-11-05T15:22:25.617Z
8282532 8282532 20251028022942_pyhmw ES000C 2025-10-29T12:43:18.195Z 2025-10-29T12:43:18.195Z
8282472 8282472 20251028022650_gzySr ES000C 2025-10-29T12:43:07.130Z 2025-11-05T15:21:43.612Z
8280681 8280681 20251028000011_2udJL ES000C 2025-10-29T12:39:55.540Z 2025-11-05T15:21:10.570Z
8279979 8279979 20251027224335_PltV7 ES000C 2025-10-29T12:38:23.279Z 2025-11-05T15:20:53.979Z
8279788 8279788 20251027221851_Ls4gm ES000C 2025-10-29T12:38:07.352Z 2025-11-05T15:20:49.494Z
8274128 8274128 20251027050148_o7byj ES000C 2025-10-29T12:25:16.228Z 2025-11-04T15:45:08.935Z
8273919 8273919 20251027045007_78fB4 ES000C 2025-10-29T12:24:55.317Z 2025-11-04T15:45:05.356Z
8254666 8254666 20251027041254_aHdWy ES000C 2025-10-28T12:20:13.760Z 2025-11-04T15:44:52.657Z
8254502 8254502 20251027040354_OY4Hz ES000C 2025-10-28T12:20:00.983Z 2025-11-04T15:44:28.172Z
8254012 8254012 20251027033931_R9TvR ES000C 2025-10-28T12:19:11.839Z 2025-11-04T15:44:17.267Z
8252646 8252646 20251027012128_cyYMn ES000C 2025-10-28T12:15:41.748Z 2025-11-04T15:42:51.289Z
8252410 8252410 20251027004532_rATIK ES000C 2025-10-28T12:14:57.993Z 2025-11-04T15:42:45.441Z
8251080 8251080 20251026201344_Ei00P ES000C 2025-10-28T12:10:36.213Z 2025-11-04T15:41:13.457Z
8216274 8216274 20251024020056_Oqt47 ES000C 2025-10-26T12:31:56.240Z 2025-11-01T13:10:31.656Z
8212016 8212016 20251023222559_LdDh5 ES000C 2025-10-26T12:25:05.665Z 2025-11-01T13:10:11.121Z
8211010 8211010 20251023202022_wVsnc ES000C 2025-10-26T12:22:47.398Z 2025-11-01T13:10:00.723Z
8193318 8193318 20251022040137_TGHv5 ES000C 2025-10-24T12:27:54.666Z 2025-10-30T13:13:29.190Z
8193194 8193194 20251022035401_erx4Z ES000C 2025-10-24T12:27:31.267Z 2025-10-30T13:13:28.999Z
8193183 8193183 20251022035322_r8FeT ES000C 2025-10-24T12:27:30.281Z 2025-10-30T13:13:28.977Z

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