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

>10,000 rows count all where station_code = "AU001L" 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
8705054 8705054 20251208174816_Fgmev AU001L 2025-12-09T14:15:58.092Z 2025-12-10T14:17:08.393Z
8704976 8704976 20251208173426_eecvH AU001L 2025-12-09T14:15:51.531Z 2025-12-10T14:17:08.340Z
8704916 8704916 20251208172826_AtMzD AU001L 2025-12-09T14:15:48.711Z 2025-12-10T14:17:08.326Z
8704905 8704905 20251208172402_RXVW2 AU001L 2025-12-09T14:15:47.955Z 2025-12-10T14:17:08.323Z
8704864 8704864 20251208171703_hXZyJ AU001L 2025-12-09T14:15:42.091Z 2025-12-10T14:17:08.297Z
8704856 8704856 20251208171427_EE6BA AU001L 2025-12-09T14:15:41.518Z 2025-12-10T14:17:08.290Z
8704850 8704850 20251208171242_n83w9 AU001L 2025-12-09T14:15:40.910Z 2025-12-10T14:17:08.278Z
8704847 8704847 20251208171127_25Mvl AU001L 2025-12-09T14:15:40.418Z 2025-12-10T14:17:08.273Z
8704745 8704745 20251208164854_4ifBl AU001L 2025-12-09T14:15:18.619Z 2025-12-10T14:17:08.172Z
8704657 8704657 20251208162850_oogr9 AU001L 2025-12-09T14:15:10.516Z 2025-12-10T14:17:08.127Z
8704634 8704634 20251208162129_X3WoU AU001L 2025-12-09T14:15:07.829Z 2025-12-10T14:17:08.105Z
8704626 8704626 20251208161935_3J2sW AU001L 2025-12-09T14:15:06.883Z 2025-12-10T14:17:08.102Z
8704590 8704590 20251208160933_hW0IY AU001L 2025-12-09T14:15:03.363Z 2025-12-10T14:17:08.045Z
8704537 8704537 20251208155917_CxHGl AU001L 2025-12-09T14:14:44.501Z 2025-12-10T14:17:08.013Z
8704520 8704520 20251208155233_CEoVz AU001L 2025-12-09T14:14:43.163Z 2025-12-10T14:17:08.006Z
8704509 8704509 20251208154934_fPg0S AU001L 2025-12-09T14:14:42.274Z 2025-12-10T14:17:07.994Z
8704505 8704505 20251208154836_PEKfo AU001L 2025-12-09T14:14:41.205Z 2025-12-10T14:17:07.980Z
8704501 8704501 20251208154810_adpFX AU001L 2025-12-09T14:14:40.507Z 2025-12-10T14:17:07.978Z
8704475 8704475 20251208154541_PfSt4 AU001L 2025-12-09T14:14:35.319Z 2025-12-10T14:17:07.940Z
8704446 8704446 20251208154032_wbLLH AU001L 2025-12-09T14:14:32.514Z 2025-12-10T14:17:07.929Z
8704364 8704364 20251208152840_XP9dP AU001L 2025-12-09T14:14:23.551Z 2025-12-10T14:17:07.869Z
8704338 8704338 20251208152342_eMMZd AU001L 2025-12-09T14:14:20.162Z 2025-12-10T14:17:07.391Z
8704272 8704272 20251208151550_QhZ7Z AU001L 2025-12-09T14:14:05.523Z 2025-12-10T14:17:07.357Z
8704164 8704164 20251208145924_YEWdW AU001L 2025-12-09T14:13:54.492Z 2025-12-10T14:17:07.024Z
8704155 8704155 20251208145830_xvH2v AU001L 2025-12-09T14:13:53.770Z 2025-12-10T14:17:07.021Z
8704045 8704045 20251208144449_ulswg AU001L 2025-12-09T14:13:29.684Z 2025-12-10T14:17:06.902Z
8704036 8704036 20251208144354_EDYfs AU001L 2025-12-09T14:13:24.971Z 2025-12-10T14:17:06.881Z
8704034 8704034 20251208144321_EjzG6 AU001L 2025-12-09T14:13:23.306Z 2025-12-10T14:17:06.880Z
8704015 8704015 20251208144135_L8HUr AU001L 2025-12-09T14:13:21.177Z 2025-12-10T14:17:06.844Z
8703957 8703957 20251208143423_FLnPR AU001L 2025-12-09T14:13:13.718Z 2025-12-10T14:17:06.807Z
8703918 8703918 20251208142904_Q63PT AU001L 2025-12-09T14:13:09.658Z 2025-12-10T14:17:06.780Z
8703898 8703898 20251208142652_u33A0 AU001L 2025-12-09T14:13:07.003Z 2025-12-10T14:17:06.760Z
8703795 8703795 20251208141616_VciG2 AU001L 2025-12-09T14:12:57.431Z 2025-12-10T14:17:06.614Z
8703769 8703769 20251208141355_bmRWc AU001L 2025-12-09T14:12:44.042Z 2025-12-10T14:17:06.582Z
8703568 8703568 20251208134729_7h6BW AU001L 2025-12-09T14:12:19.867Z 2025-12-10T14:17:05.783Z
8703350 8703350 20251208131807_07f6u AU001L 2025-12-09T14:11:39.004Z 2025-12-10T14:17:04.504Z
8703141 8703141 20251208124520_CEkPI AU001L 2025-12-09T14:11:01.253Z 2025-12-10T14:17:04.328Z
8703101 8703101 20251208123723_tTC6y AU001L 2025-12-09T14:10:43.333Z 2025-12-10T14:17:04.069Z
8702987 8702987 20251208122111_bvDhC AU001L 2025-12-09T14:10:23.432Z 2025-12-10T14:17:04.010Z
8702881 8702881 20251208121051_Hl8Gn AU001L 2025-12-09T14:09:56.397Z 2025-12-10T14:17:03.971Z
8702775 8702775 20251208115743_vv5px AU001L 2025-12-09T14:09:41.431Z 2025-12-10T14:17:03.905Z
8702635 8702635 20251208114224_jzyhO AU001L 2025-12-09T14:09:10.814Z 2025-12-10T14:17:03.834Z
8702611 8702611 20251208114003_Za92t AU001L 2025-12-09T14:09:05.832Z 2025-12-10T14:17:03.816Z
8701948 8701948 20251208103855_hor5Z AU001L 2025-12-09T14:06:52.258Z 2025-12-10T14:17:03.295Z
8701931 8701931 20251208103640_pY7Pt AU001L 2025-12-09T14:06:49.316Z 2025-12-10T14:17:03.288Z
8701749 8701749 20251208101657_vrvml AU001L 2025-12-09T14:06:01.917Z 2025-12-10T14:17:03.081Z
8698245 8698245 20251207175023_rpi3I AU001L 2025-12-08T14:14:27.045Z 2025-12-11T14:25:00.689Z
8698234 8698234 20251207174014_4wzYl AU001L 2025-12-08T14:14:25.176Z 2025-12-11T14:24:59.928Z
8698231 8698231 20251207173816_NvfqM AU001L 2025-12-08T14:14:24.542Z 2025-12-11T14:24:59.388Z
8698179 8698179 20251207170702_KTyCN AU001L 2025-12-08T14:14:08.923Z 2025-12-08T14:14:08.923Z
8698173 8698173 20251207170433_ClRzr AU001L 2025-12-08T14:14:07.167Z 2025-12-11T14:24:54.776Z
8698151 8698151 20251207165624_2Q9zq AU001L 2025-12-08T14:14:02.777Z 2025-12-08T14:14:02.777Z
8698143 8698143 20251207165124_dVXI2 AU001L 2025-12-08T14:14:01.259Z 2025-12-11T14:24:52.545Z
8698139 8698139 20251207165009_eKHZR AU001L 2025-12-08T14:14:00.448Z 2025-12-11T14:24:51.482Z
8698133 8698133 20251207164913_x4vYW AU001L 2025-12-08T14:13:59.430Z 2025-12-11T14:24:51.158Z
8698129 8698129 20251207164835_Qu7DN AU001L 2025-12-08T14:13:58.651Z 2025-12-11T14:24:51.058Z
8698089 8698089 20251207162604_4pelS AU001L 2025-12-08T14:13:52.322Z 2025-12-11T14:24:47.563Z
8698086 8698086 20251207161513_SwOv0 AU001L 2025-12-08T14:13:51.434Z 2025-12-08T14:13:51.434Z
8698075 8698075 20251207160024_iinvX AU001L 2025-12-08T14:13:49.681Z 2025-12-11T14:24:46.619Z
8698074 8698074 20251207155842_TQWXM AU001L 2025-12-08T14:13:49.370Z 2025-12-11T14:24:46.502Z
8698065 8698065 20251207155518_syjmS AU001L 2025-12-08T14:13:47.863Z 2025-12-11T14:24:45.877Z
8698056 8698056 20251207155315_mAUpB AU001L 2025-12-08T14:13:46.751Z 2025-12-11T14:24:45.337Z
8697931 8697931 20251207152935_bi1Pv AU001L 2025-12-08T14:13:17.780Z 2025-12-11T14:24:31.061Z
8697921 8697921 20251207152759_JPVdY AU001L 2025-12-08T14:13:15.911Z 2025-12-11T14:24:30.434Z
8697862 8697862 20251207152055_jLK0a AU001L 2025-12-08T14:13:06.188Z 2025-12-11T14:24:27.851Z
8697741 8697741 20251207150514_Q14La AU001L 2025-12-08T14:12:42.473Z 2025-12-11T14:24:22.200Z
8697612 8697612 20251207144501_5YY3L AU001L 2025-12-08T14:12:11.186Z 2025-12-11T14:24:16.511Z
8697610 8697610 20251207144441_7fRCT AU001L 2025-12-08T14:12:10.688Z 2025-12-11T14:24:16.337Z
8697605 8697605 20251207144428_UsfV2 AU001L 2025-12-08T14:12:09.680Z 2025-12-11T14:24:16.154Z
8697574 8697574 20251207143654_GisZP AU001L 2025-12-08T14:12:03.800Z 2025-12-11T14:24:14.267Z
8697522 8697522 20251207142917_Buo6Y AU001L 2025-12-08T14:11:57.076Z 2025-12-11T14:24:12.117Z
8697511 8697511 20251207142734_dKGiH AU001L 2025-12-08T14:11:53.695Z 2025-12-11T14:24:11.516Z
8697377 8697377 20251207140834_IjjyM AU001L 2025-12-08T14:11:23.585Z 2025-12-11T14:23:55.640Z
8697366 8697366 20251207140751_qgXg8 AU001L 2025-12-08T14:11:18.802Z 2025-12-11T14:23:55.031Z
8697315 8697315 20251207140341_1S6TV AU001L 2025-12-08T14:11:08.643Z 2025-12-11T14:23:53.624Z
8697269 8697269 20251207135926_PCwOS AU001L 2025-12-08T14:11:01.599Z 2025-12-11T14:23:51.428Z
8697096 8697096 20251207133333_IIUpL AU001L 2025-12-08T14:10:26.903Z 2025-12-11T14:23:39.509Z
8696983 8696983 20251207131553_vxPhf AU001L 2025-12-08T14:10:03.715Z 2025-12-11T14:23:29.616Z
8696944 8696944 20251207131001_3UcqP AU001L 2025-12-08T14:09:56.464Z 2025-12-11T14:23:27.293Z
8696753 8696753 20251207124123_9Bh2b AU001L 2025-12-08T14:09:12.313Z 2025-12-11T14:23:11.615Z
8696628 8696628 20251207122441_z43z7 AU001L 2025-12-08T14:08:43.688Z 2025-12-08T14:08:43.688Z
8696448 8696448 20251207120239_KwdhE AU001L 2025-12-08T14:07:58.866Z 2025-12-11T14:22:56.319Z
8696329 8696329 20251207114045_HwRoS AU001L 2025-12-08T14:07:22.964Z 2025-12-11T14:22:50.963Z
8696239 8696239 20251207112838_Z1DB2 AU001L 2025-12-08T14:06:44.004Z 2025-12-11T14:22:39.828Z
8696042 8696042 20251207110144_hlLAc AU001L 2025-12-08T14:06:05.402Z 2025-12-11T14:22:30.298Z
8696006 8696006 20251207105329_KVACJ AU001L 2025-12-08T14:06:00.375Z 2025-12-11T14:22:29.057Z
8695927 8695927 20251207104032_sp7PM AU001L 2025-12-08T14:05:38.425Z 2025-12-11T14:22:24.795Z
8695765 8695765 20251207102358_W7qs0 AU001L 2025-12-08T14:05:06.193Z 2025-12-08T14:05:06.193Z
8689532 8689532 20251205174055_KhuNc AU001L 2025-12-06T14:08:49.594Z 2025-12-11T14:34:48.529Z
8689508 8689508 20251205171818_LwJlu AU001L 2025-12-06T14:08:44.679Z 2025-12-11T14:34:47.578Z
8689488 8689488 20251205170538_xNWjK AU001L 2025-12-06T14:08:39.800Z 2025-12-11T14:34:46.455Z
8689482 8689482 20251205164958_G3X0X AU001L 2025-12-06T14:08:38.461Z 2025-12-11T14:34:46.159Z
8689473 8689473 20251205164152_CeHzB AU001L 2025-12-06T14:08:35.452Z 2025-12-11T14:34:45.376Z
8689459 8689459 20251205162322_MdUGI AU001L 2025-12-06T14:08:31.478Z 2025-12-11T14:34:44.088Z
8689453 8689453 20251205162158_6cUNU AU001L 2025-12-06T14:08:28.064Z 2025-12-11T14:34:43.856Z
8689449 8689449 20251205161506_8N9Jg AU001L 2025-12-06T14:08:26.926Z 2025-12-11T14:34:43.587Z
8689441 8689441 20251205161052_cba3a AU001L 2025-12-06T14:08:25.033Z 2025-12-11T14:34:43.045Z
8689440 8689440 20251205161047_Hd7Bt AU001L 2025-12-06T14:08:24.522Z 2025-12-11T14:34:42.977Z
8689436 8689436 20251205160831_7jm68 AU001L 2025-12-06T14:08:21.620Z 2025-12-11T14:34:42.395Z
8689404 8689404 20251205154723_xowAx AU001L 2025-12-06T14:08:14.166Z 2025-12-11T14:34:41.065Z

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