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 = "AU001U" 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
9225935 9225935 20260115173448_J0J1A AU001U 2026-01-19T14:39:18.737Z 2026-01-24T15:09:50.588Z
9225849 9225849 20260116150318_0M8vn AU001U 2026-01-19T14:33:33.747Z 2026-01-25T14:57:16.324Z
9225842 9225842 20260116144951_5sy5P AU001U 2026-01-19T14:33:29.423Z 2026-01-25T14:57:15.115Z
9225840 9225840 20260116143620_t78la AU001U 2026-01-19T14:33:23.782Z 2026-01-25T14:57:14.295Z
9216253 9216253 20260115200416_8ZKxC AU001U 2026-01-17T14:28:46.231Z 2026-01-24T15:10:44.237Z
9216250 9216250 20260115200121_QAxS4 AU001U 2026-01-17T14:28:45.810Z 2026-01-24T15:10:36.757Z
9216247 9216247 20260115195603_KjXAo AU001U 2026-01-17T14:28:45.263Z 2026-01-24T15:10:31.980Z
9216242 9216242 20260115192707_DyUFT AU001U 2026-01-17T14:28:44.366Z 2026-01-24T15:10:28.310Z
9216236 9216236 20260115191413_XXZ7k AU001U 2026-01-17T14:28:43.325Z 2026-01-24T15:10:24.340Z
9216233 9216233 20260115190200_tnhDQ AU001U 2026-01-17T14:28:42.740Z 2026-01-24T15:10:21.697Z
9216227 9216227 20260115185518_hXWRe AU001U 2026-01-17T14:28:41.680Z 2026-01-24T15:10:21.080Z
9216225 9216225 20260115185051_6lZZu AU001U 2026-01-17T14:28:41.178Z 2026-01-24T15:10:20.229Z
9216223 9216223 20260115184849_mYM62 AU001U 2026-01-17T14:28:40.221Z 2026-01-24T15:10:19.588Z
9216220 9216220 20260115183821_g8vZJ AU001U 2026-01-17T14:28:39.071Z 2026-01-24T15:10:16.693Z
9216218 9216218 20260115174857_rTpHd AU001U 2026-01-17T14:28:38.300Z 2026-01-24T15:09:55.688Z
9216213 9216213 20260115174334_qk52j AU001U 2026-01-17T14:28:36.978Z 2026-01-24T15:09:54.365Z
9216209 9216209 20260115172516_323sX AU001U 2026-01-17T14:28:36.347Z 2026-01-24T15:09:47.881Z
9216203 9216203 20260115170552_fspPY AU001U 2026-01-17T14:28:35.223Z 2026-01-24T15:09:43.738Z
9216200 9216200 20260115170040_77ICB AU001U 2026-01-17T14:28:34.550Z 2026-01-24T15:09:42.223Z
9216198 9216198 20260115170039_X2Fxb AU001U 2026-01-17T14:28:31.455Z 2026-01-24T15:09:42.074Z
9216196 9216196 20260115163923_FSvYE AU001U 2026-01-17T14:28:25.811Z 2026-01-24T15:09:36.911Z
9216193 9216193 20260115163812_Gv9Wp AU001U 2026-01-17T14:28:21.715Z 2026-01-24T15:09:36.489Z
9216190 9216190 20260115161408_b2xN5 AU001U 2026-01-17T14:28:19.423Z 2026-01-24T15:09:29.559Z
9216184 9216184 20260115160925_MnwC8 AU001U 2026-01-17T14:28:15.429Z 2026-01-24T15:09:18.989Z
9216175 9216175 20260115150450_ec3ty AU001U 2026-01-17T14:28:13.474Z 2026-01-24T15:09:10.743Z
9216171 9216171 20260115143808_1sR5q AU001U 2026-01-17T14:28:12.614Z 2026-01-24T15:09:06.779Z
9216156 9216156 20260115140047_zeLAg AU001U 2026-01-17T14:28:06.477Z 2026-01-24T15:08:55.618Z
9206977 9206977 20260114200942_gpqip AU001U 2026-01-16T14:06:28.273Z 2026-01-22T15:02:45.243Z
9206933 9206933 20260114195331_0YMZO AU001U 2026-01-16T14:06:13.977Z 2026-01-22T15:02:43.614Z
9206863 9206863 20260114192515_Nad8N AU001U 2026-01-16T14:05:56.298Z 2026-01-22T15:02:41.392Z
9206852 9206852 20260114191805_NDYHd AU001U 2026-01-16T14:05:51.440Z 2026-01-22T15:02:40.903Z
9206848 9206848 20260114191635_vNZo2 AU001U 2026-01-16T14:05:50.105Z 2026-01-22T15:02:38.538Z
9206816 9206816 20260114190536_T2GFu AU001U 2026-01-16T14:05:41.462Z 2026-01-22T15:02:37.359Z
9206794 9206794 20260114190054_pyz9g AU001U 2026-01-16T14:05:35.953Z 2026-01-22T15:02:36.779Z
9206747 9206747 20260114184041_WQRj9 AU001U 2026-01-16T14:05:23.702Z 2026-01-22T15:02:35.382Z
9206660 9206660 20260114181359_26G5R AU001U 2026-01-16T14:04:58.115Z 2026-01-22T15:02:32.974Z
9206647 9206647 20260114180548_0czpp AU001U 2026-01-16T14:04:55.588Z 2026-01-22T15:02:32.612Z
9206643 9206643 20260114180426_7p77c AU001U 2026-01-16T14:04:54.458Z 2026-01-22T15:02:32.441Z
9206575 9206575 20260114174628_TStl4 AU001U 2026-01-16T14:04:33.060Z 2026-01-22T15:02:30.488Z
9206547 9206547 20260114173803_IWkdK AU001U 2026-01-16T14:04:23.634Z 2026-01-22T15:02:29.432Z
9206313 9206313 20260114153616_IoWvJ AU001U 2026-01-16T14:03:15.339Z 2026-01-22T15:02:01.347Z
9206286 9206286 20260114152348_3qumb AU001U 2026-01-16T14:03:06.724Z 2026-01-22T15:01:57.902Z
9206266 9206266 20260114150626_7Ds1g AU001U 2026-01-16T14:03:00.947Z 2026-01-22T15:01:57.204Z
9206230 9206230 20260114144249_YDG0X AU001U 2026-01-16T14:02:50.088Z 2026-01-22T15:01:56.017Z
9206193 9206193 20260114141931_JiuC2 AU001U 2026-01-16T14:02:37.619Z 2026-01-22T15:01:54.716Z
9206149 9206149 20260114134633_YeWTm AU001U 2026-01-16T14:02:23.876Z 2026-01-22T15:01:50.939Z
9205734 9205734 20260113124510_09sJ2 AU001U 2026-01-15T14:41:10.535Z 2026-01-21T15:06:25.352Z
9198655 9198655 20260113172939_30lld AU001U 2026-01-15T14:06:15.935Z 2026-01-22T15:06:59.854Z
9198653 9198653 20260113172939_pUGQV AU001U 2026-01-15T14:06:15.337Z 2026-01-22T15:06:59.765Z
9198617 9198617 20260113171530_UrsRF AU001U 2026-01-15T14:05:53.009Z 2026-01-22T15:06:58.008Z
9198604 9198604 20260113171454_Gnimx AU001U 2026-01-15T14:05:48.783Z 2026-01-22T15:06:47.142Z
9198451 9198451 20260113163018_wsD87 AU001U 2026-01-15T14:04:30.787Z 2026-01-22T15:06:30.345Z
9198439 9198439 20260113162647_YDbPU AU001U 2026-01-15T14:04:27.665Z 2026-01-22T15:06:30.177Z
9198346 9198346 20260113154612_LIQfc AU001U 2026-01-15T14:03:29.426Z 2026-01-22T15:06:23.585Z
9198334 9198334 20260113154059_2ap3X AU001U 2026-01-15T14:03:22.293Z 2026-01-22T15:06:23.062Z
9198202 9198202 20260113143644_2p27r AU001U 2026-01-15T14:02:04.631Z 2026-01-22T15:06:17.290Z
9198123 9198123 20260113133604_duGE4 AU001U 2026-01-15T14:01:03.769Z 2026-01-22T15:06:13.504Z
9198036 9198036 20260112134102_3VHet AU001U 2026-01-14T14:37:11.957Z 2026-01-20T15:27:00.677Z
9198021 9198021 20260112131750_O66QJ AU001U 2026-01-14T14:36:52.410Z 2026-01-20T15:26:40.034Z
9198007 9198007 20260112130117_vXFU7 AU001U 2026-01-14T14:36:39.991Z 2026-01-20T15:26:33.103Z
9194364 9194364 20260112201207_EsYro AU001U 2026-01-14T14:08:51.740Z 2026-01-21T15:03:53.146Z
9194314 9194314 20260112194437_yI28R AU001U 2026-01-14T14:08:36.752Z 2026-01-21T15:03:49.004Z
9194233 9194233 20260112190639_3j2X5 AU001U 2026-01-14T14:08:10.432Z 2026-01-21T15:03:43.550Z
9194119 9194119 20260112180239_s4dLi AU001U 2026-01-14T14:07:29.025Z 2026-01-21T15:03:31.693Z
9194117 9194117 20260112180239_Xb5dv AU001U 2026-01-14T14:07:28.314Z 2026-01-21T15:03:31.664Z
9193985 9193985 20260112160741_zPo7u AU001U 2026-01-14T14:06:25.798Z 2026-01-21T15:03:08.467Z
9193950 9193950 20260112154011_15N9B AU001U 2026-01-14T14:05:51.943Z 2026-01-21T15:02:58.670Z
9193941 9193941 20260112153241_H373S AU001U 2026-01-14T14:05:36.225Z 2026-01-21T15:02:56.743Z
9193924 9193924 20260112151131_LTxS3 AU001U 2026-01-14T14:05:04.022Z 2026-01-21T15:02:48.519Z
9193908 9193908 20260112145601_fTWc7 AU001U 2026-01-14T14:04:51.489Z 2026-01-21T15:02:43.592Z
9193871 9193871 20260112143858_1Fd3c AU001U 2026-01-14T14:04:29.947Z 2026-01-21T15:02:32.226Z
9193867 9193867 20260112143300_2EZjQ AU001U 2026-01-14T14:04:23.530Z 2026-01-21T15:02:29.427Z
9193853 9193853 20260112141345_OftEm AU001U 2026-01-14T14:04:06.830Z 2026-01-21T15:02:20.117Z
9193849 9193849 20260112140616_SAtzd AU001U 2026-01-14T14:04:00.628Z 2026-01-21T15:02:15.582Z
9187491 9187491 20260111172646_ZMjV7 AU001U 2026-01-13T14:07:33.750Z 2026-01-20T15:20:30.957Z
9186078 9186078 20260110141543_fL9p3 AU001U 2026-01-12T14:33:29.123Z 2026-01-18T15:11:18.911Z
9186055 9186055 20260110131159_3DCGW AU001U 2026-01-12T14:32:55.627Z 2026-01-18T15:10:52.201Z
9186051 9186051 20260110125944_rI9km AU001U 2026-01-12T14:32:44.761Z 2026-01-18T15:10:47.407Z
9180301 9180301 20260110195437_i4Yhp AU001U 2026-01-12T14:06:37.117Z 2026-01-19T15:15:55.485Z
9180248 9180248 20260110194335_ybLal AU001U 2026-01-12T14:06:26.486Z 2026-01-19T15:15:53.441Z
9180208 9180208 20260110193742_132Yg AU001U 2026-01-12T14:06:14.226Z 2026-01-19T15:15:51.605Z
9180191 9180191 20260110193251_vED0v AU001U 2026-01-12T14:06:09.104Z 2026-01-19T15:15:50.628Z
9180186 9180186 20260110193235_OJ7NW AU001U 2026-01-12T14:06:07.975Z 2026-01-19T15:15:50.424Z
9180182 9180182 20260110193121_6GgD2 AU001U 2026-01-12T14:06:07.461Z 2026-01-19T15:15:50.296Z
9180117 9180117 20260110191320_8dbik AU001U 2026-01-12T14:05:51.700Z 2026-01-19T15:15:47.015Z
9179915 9179915 20260110180858_cDFBx AU001U 2026-01-12T14:04:53.391Z 2026-01-19T15:15:32.839Z
9179836 9179836 20260110175001_YHDmu AU001U 2026-01-12T14:04:31.432Z 2026-01-19T15:15:19.465Z
9179734 9179734 20260110173635_3BaDE AU001U 2026-01-12T14:04:05.329Z 2026-01-19T15:15:13.859Z
9179446 9179446 20260110154534_Iwmcv AU001U 2026-01-12T14:02:25.787Z 2026-01-19T15:14:38.904Z
9174347 9174347 20260109151757_RqY95 AU001U 2026-01-11T14:02:22.288Z 2026-01-18T15:06:21.364Z
9170094 9170094 20260108141937_V7gfu AU001U 2026-01-09T14:15:42.708Z 2026-01-16T15:13:54.619Z
9166683 9166683 20260107194727_urEq9 AU001U 2026-01-09T14:04:23.592Z 2026-01-16T15:10:17.795Z
9166681 9166681 20260107194727_Yg36C AU001U 2026-01-09T14:04:23.187Z 2026-01-16T15:10:15.970Z
9166158 9166158 20260107165228_ed5tF AU001U 2026-01-09T14:01:50.053Z 2026-01-16T15:09:27.427Z
9166156 9166156 20260107165228_P0iOP AU001U 2026-01-09T14:01:49.640Z 2026-01-16T15:09:27.328Z
9165757 9165757 20260107154711_JPrRf AU001U 2026-01-08T14:18:03.010Z 2026-01-13T15:05:56.098Z
9165642 9165642 20260107134540_ztBQO AU001U 2026-01-08T14:17:28.657Z 2026-01-13T15:04:52.669Z
9165640 9165640 20260107134540_GttXH AU001U 2026-01-08T14:17:28.158Z 2026-01-13T15:04:52.519Z
9161809 9161809 20260105142234_BYEAR AU001U 2026-01-07T14:24:45.244Z 2026-01-13T15:16:37.108Z
9161791 9161791 20260105134333_LoNCq AU001U 2026-01-07T14:24:33.227Z 2026-01-13T15:16:31.435Z

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