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 = "AU003H" 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
9824919 9824919 20260429214916_GwmWH AU003H 2026-05-01T12:06:33.173Z 2026-05-01T12:19:55.951Z
9824807 9824807 20260429212616_739MK AU003H 2026-05-01T12:06:04.536Z 2026-05-01T12:19:55.923Z
9804412 9804412 20260425125023_rNPJR AU003H 2026-04-27T12:51:43.429Z 2026-04-30T12:55:58.489Z
9803665 9803665 20260425113133_QxReg AU003H 2026-04-27T12:50:14.159Z 2026-04-30T12:55:24.885Z
9797663 9797663 20260425211510_9ThLn AU003H 2026-04-27T12:20:25.844Z 2026-04-30T12:44:08.745Z
9797655 9797655 20260425211437_3Zv3X AU003H 2026-04-27T12:20:20.899Z 2026-04-30T12:44:08.530Z
9797545 9797545 20260425210056_7p1jh AU003H 2026-04-27T12:19:51.546Z 2026-04-30T12:44:04.926Z
9797524 9797524 20260425205803_2LTx5 AU003H 2026-04-27T12:19:46.822Z 2026-04-30T12:44:04.088Z
9797403 9797403 20260425204147_yDQ5V AU003H 2026-04-27T12:19:16.259Z 2026-04-30T12:43:58.178Z
9797280 9797280 20260425202244_cSH6g AU003H 2026-04-27T12:18:53.923Z 2026-04-30T12:43:53.971Z
9797123 9797123 20260425194720_iAfpJ AU003H 2026-04-27T12:18:06.703Z 2026-04-30T12:43:47.637Z
9797081 9797081 20260425194102_ivyI1 AU003H 2026-04-27T12:18:00.220Z 2026-04-30T12:43:35.909Z
9797024 9797024 20260425193324_3m9V2 AU003H 2026-04-27T12:17:46.031Z 2026-04-30T12:43:34.085Z
9796991 9796991 20260425192656_NUeEA AU003H 2026-04-27T12:17:37.761Z 2026-04-30T12:43:32.668Z
9796971 9796971 20260425192545_fCsBH AU003H 2026-04-27T12:17:34.832Z 2026-04-30T12:43:32.036Z
9796969 9796969 20260425192539_7HKph AU003H 2026-04-27T12:17:34.184Z 2026-04-30T12:43:31.911Z
9796924 9796924 20260425192149_xUndR AU003H 2026-04-27T12:17:20.385Z 2026-04-30T12:43:28.321Z
9796908 9796908 20260425191842_0IYDD AU003H 2026-04-27T12:17:17.429Z 2026-04-30T12:43:27.751Z
9796855 9796855 20260425191141_p7JFd AU003H 2026-04-27T12:17:06.949Z 2026-04-30T12:43:25.915Z
9796843 9796843 20260425190907_1M8Ks AU003H 2026-04-27T12:17:04.125Z 2026-04-30T12:43:25.296Z
9796841 9796841 20260425190858_3sT3f AU003H 2026-04-27T12:17:03.444Z 2026-04-30T12:43:25.229Z
9796811 9796811 20260425190253_0JH7Z AU003H 2026-04-27T12:16:51.952Z 2026-04-30T12:43:24.100Z
9796785 9796785 20260425185708_YKZz3 AU003H 2026-04-27T12:16:43.154Z 2026-04-30T12:43:23.010Z
9796756 9796756 20260425185229_iOSC9 AU003H 2026-04-27T12:16:36.666Z 2026-04-30T12:43:21.964Z
9796675 9796675 20260425183556_5Abe4 AU003H 2026-04-27T12:16:10.214Z 2026-04-30T12:43:18.447Z
9796650 9796650 20260425183119_3WCzJ AU003H 2026-04-27T12:16:05.714Z 2026-04-30T12:43:17.307Z
9796640 9796640 20260425182917_e4e38 AU003H 2026-04-27T12:16:03.308Z 2026-04-30T12:43:16.737Z
9796582 9796582 20260425182200_8NCYm AU003H 2026-04-27T12:15:46.189Z 2026-04-30T12:43:14.449Z
9796488 9796488 20260425180316_DtFEn AU003H 2026-04-27T12:15:31.900Z 2026-04-30T12:43:00.005Z
9796259 9796259 20260425174824_RSe0P AU003H 2026-04-27T12:14:56.000Z 2026-04-30T12:42:53.555Z
9796171 9796171 20260425174207_c8ReE AU003H 2026-04-27T12:14:34.202Z 2026-04-30T12:42:51.338Z
9795221 9795221 20260425164808_If9Oz AU003H 2026-04-27T12:11:57.489Z 2026-04-30T12:42:18.259Z
9794823 9794823 20260425162201_gikQw AU003H 2026-04-27T12:10:44.289Z 2026-04-30T12:41:55.590Z
9794529 9794529 20260425155506_gsSYU AU003H 2026-04-27T12:09:50.531Z 2026-04-30T12:41:46.534Z
9794335 9794335 20260425154117_5V9J4 AU003H 2026-04-27T12:09:09.404Z 2026-04-30T12:41:41.822Z
9794073 9794073 20260425151955_m56hM AU003H 2026-04-27T12:08:31.294Z 2026-04-30T12:41:36.185Z
9793899 9793899 20260425150830_lOrSQ AU003H 2026-04-27T12:07:57.668Z 2026-04-30T12:41:22.646Z
9793512 9793512 20260425144633_zEh3j AU003H 2026-04-27T12:07:03.489Z 2026-04-30T12:41:12.031Z
9793436 9793436 20260425143846_3ekii AU003H 2026-04-27T12:06:46.053Z 2026-04-30T12:41:10.147Z
9793384 9793384 20260425143242_UQO9D AU003H 2026-04-27T12:06:32.083Z 2026-04-30T12:41:08.599Z
9793230 9793230 20260425142434_olQHj AU003H 2026-04-27T12:06:07.690Z 2026-04-30T12:41:05.408Z
9793197 9793197 20260425142357_bCU8j AU003H 2026-04-27T12:06:03.615Z 2026-04-30T12:41:04.740Z
9793090 9793090 20260425141508_OQP4B AU003H 2026-04-27T12:05:34.665Z 2026-04-30T12:41:01.627Z
9792696 9792696 20260425134108_Y6mvl AU003H 2026-04-27T12:04:23.476Z 2026-04-30T12:40:40.891Z
9790337 9790337 20260424114116_C5Mnh AU003H 2026-04-26T12:34:40.618Z 2026-04-30T13:04:02.791Z
9790252 9790252 20260424113307_2J53u AU003H 2026-04-26T12:34:38.953Z 2026-04-30T13:04:01.932Z
9783685 9783685 20260424214114_sh9Ir AU003H 2026-04-26T12:15:24.724Z 2026-04-30T12:51:50.479Z
9783646 9783646 20260424213901_MXJdW AU003H 2026-04-26T12:15:09.348Z 2026-04-30T12:51:49.764Z
9783475 9783475 20260424212703_X2MNg AU003H 2026-04-26T12:14:52.682Z 2026-04-30T12:51:45.803Z
9783401 9783401 20260424211834_iOzdd AU003H 2026-04-26T12:14:39.550Z 2026-04-30T12:51:33.284Z
9783382 9783382 20260424211727_1PpWS AU003H 2026-04-26T12:14:38.121Z 2026-04-30T12:51:28.393Z
9783316 9783316 20260424211014_N0AZ0 AU003H 2026-04-26T12:14:29.653Z 2026-04-30T12:51:26.408Z
9783311 9783311 20260424210828_0TxtK AU003H 2026-04-26T12:14:20.935Z 2026-04-30T12:51:26.227Z
9782942 9782942 20260424201607_sALex AU003H 2026-04-26T12:13:19.910Z 2026-04-30T12:51:14.899Z
9782813 9782813 20260424195640_U66So AU003H 2026-04-26T12:12:51.705Z 2026-04-30T12:51:11.525Z
9782807 9782807 20260424195631_ehhYD AU003H 2026-04-26T12:12:51.466Z 2026-04-30T12:51:11.493Z
9782759 9782759 20260424194720_f4L3V AU003H 2026-04-26T12:12:44.719Z 2026-04-30T12:51:10.138Z
9782753 9782753 20260424194710_sSVKN AU003H 2026-04-26T12:12:44.182Z 2026-04-30T12:51:09.942Z
9782658 9782658 20260424193420_m75al AU003H 2026-04-26T12:12:36.372Z 2026-04-30T12:51:07.751Z
9782649 9782649 20260424193132_9MsLF AU003H 2026-04-26T12:12:35.085Z 2026-04-30T12:51:07.355Z
9782469 9782469 20260424190403_O6rgO AU003H 2026-04-26T12:12:00.908Z 2026-04-30T12:50:46.463Z
9782457 9782457 20260424190348_LR2W4 AU003H 2026-04-26T12:12:00.453Z 2026-04-30T12:50:46.290Z
9782420 9782420 20260424185929_zBhyw AU003H 2026-04-26T12:11:57.260Z 2026-04-30T12:50:43.307Z
9782383 9782383 20260424185410_2as3E AU003H 2026-04-26T12:11:54.074Z 2026-04-30T12:50:42.617Z
9782276 9782276 20260424182955_wJJEO AU003H 2026-04-26T12:11:29.789Z 2026-04-30T12:50:40.243Z
9781741 9781741 20260424174405_u3Pfv AU003H 2026-04-26T12:10:20.925Z 2026-04-30T12:50:31.125Z
9781576 9781576 20260424173538_XTFYg AU003H 2026-04-26T12:09:56.940Z 2026-04-30T12:50:28.716Z
9781221 9781221 20260424171509_KZYrF AU003H 2026-04-26T12:09:11.577Z 2026-04-30T12:50:04.496Z
9779760 9779760 20260424155339_9gJHT AU003H 2026-04-26T12:06:26.670Z 2026-04-30T12:49:24.216Z
9779323 9779323 20260424152407_fBcoc AU003H 2026-04-26T12:05:20.792Z 2026-04-30T12:49:16.403Z
9778953 9778953 20260424150657_2DF9j AU003H 2026-04-26T12:04:39.605Z 2026-04-30T12:48:52.541Z
9778707 9778707 20260424145651_tCOel AU003H 2026-04-26T12:04:17.818Z 2026-04-30T12:48:49.064Z
9778064 9778064 20260424141948_D1Kcr AU003H 2026-04-26T12:02:53.156Z 2026-04-30T12:48:36.509Z
9777831 9777831 20260424140314_1nToP AU003H 2026-04-26T12:02:19.667Z 2026-04-30T12:48:32.322Z
9776481 9776481 20260423114750_2raEO AU003H 2026-04-25T12:58:35.327Z 2026-04-30T13:15:11.117Z
9776395 9776395 20260423113815_I3IMI AU003H 2026-04-25T12:58:27.745Z 2026-04-30T13:15:10.111Z
9776393 9776393 20260423113813_c8kku AU003H 2026-04-25T12:58:27.604Z 2026-04-30T13:15:10.098Z
9776136 9776136 20260423111220_5VLG2 AU003H 2026-04-25T12:57:56.660Z 2026-04-30T13:14:57.542Z
9764404 9764404 20260423210332_TeDqX AU003H 2026-04-25T12:16:05.530Z 2026-04-30T12:58:46.796Z
9764183 9764183 20260423203532_FI8bK AU003H 2026-04-25T12:15:18.900Z 2026-04-30T12:58:42.106Z
9762432 9762432 20260423164511_bAaRB AU003H 2026-04-25T12:09:42.648Z 2026-04-30T12:57:45.218Z
9762189 9762189 20260423162357_lyp6T AU003H 2026-04-25T12:08:53.294Z 2026-04-30T12:57:41.207Z
9762104 9762104 20260423161515_lwXOw AU003H 2026-04-25T12:08:36.265Z 2026-04-30T12:57:38.243Z
9762047 9762047 20260423160705_o6tOS AU003H 2026-04-25T12:08:23.665Z 2026-04-30T12:57:21.223Z
9761581 9761581 20260423153922_4sNSB AU003H 2026-04-25T12:07:04.423Z 2026-04-30T12:57:04.748Z
9761252 9761252 20260423152111_P7Aqh AU003H 2026-04-25T12:06:13.889Z 2026-04-30T12:56:58.063Z
9760862 9760862 20260423144619_aqOFR AU003H 2026-04-25T12:05:05.641Z 2026-04-30T12:56:53.209Z
9760460 9760460 20260423141901_p2jNP AU003H 2026-04-25T12:03:50.000Z 2026-04-30T12:56:48.096Z
9760434 9760434 20260423141811_6yLcs AU003H 2026-04-25T12:03:46.739Z 2026-04-30T12:56:47.696Z
9759555 9759555 20260423125628_8lMKq AU003H 2026-04-25T12:01:06.953Z 2026-04-30T12:56:10.751Z
9759536 9759536 20260423125500_Zkf5c AU003H 2026-04-25T12:01:03.813Z 2026-04-30T12:56:10.563Z
9759221 9759221 20260422113808_hqQMz AU003H 2026-04-24T12:10:03.718Z 2026-04-30T13:22:02.917Z
9759063 9759063 20260422111820_jdBus AU003H 2026-04-24T12:10:01.103Z 2026-04-30T13:22:01.421Z
9748688 9748688 20260422213150_lkD2w AU003H 2026-04-24T12:03:29.057Z 2026-04-30T13:07:58.199Z
9748672 9748672 20260422213113_KMyqL AU003H 2026-04-24T12:03:28.523Z 2026-04-30T13:07:55.939Z
9748609 9748609 20260422212752_tk53V AU003H 2026-04-24T12:03:26.389Z 2026-04-30T13:07:49.925Z
9748339 9748339 20260422210721_jKh35 AU003H 2026-04-24T12:03:19.418Z 2026-04-30T13:07:13.179Z
9748230 9748230 20260422205842_7ZaFv AU003H 2026-04-24T12:03:17.296Z 2026-04-30T13:07:09.531Z
9748195 9748195 20260422205135_AkXuU AU003H 2026-04-24T12:03:16.210Z 2026-04-30T13:07:09.085Z
9747530 9747530 20260422182851_cFmt3 AU003H 2026-04-24T12:02:44.216Z 2026-04-30T13:06:55.569Z

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