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

5,050 rows where station_code = "AU001N" 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
8766723 8766723 20251212175301_g5iJ8 AU001N 2025-12-14T14:55:49.062Z 2025-12-14T15:16:09.070Z
8766603 8766603 20251212172854_w98bH AU001N 2025-12-14T14:54:43.455Z 2025-12-14T15:16:09.008Z
8766569 8766569 20251212172356_rYXD7 AU001N 2025-12-14T14:54:19.885Z 2025-12-14T15:16:08.996Z
8765875 8765875 20251212153727_kllT8 AU001N 2025-12-14T14:51:22.908Z 2025-12-14T15:16:08.676Z
8765283 8765283 20251212150750_mrMoN AU001N 2025-12-14T14:49:49.840Z 2025-12-14T15:16:08.545Z
8765138 8765138 20251212145935_HUH3U AU001N 2025-12-14T14:49:15.861Z 2025-12-14T15:16:08.514Z
8765002 8765002 20251212145220_1BFVy AU001N 2025-12-14T14:49:03.644Z 2025-12-14T15:16:08.464Z
8764933 8764933 20251212144835_FFL3L AU001N 2025-12-14T14:48:59.549Z 2025-12-14T15:16:08.450Z
8762562 8762562 20251212125223_Okzjb AU001N 2025-12-14T14:42:33.741Z 2025-12-14T15:16:07.828Z
8762290 8762290 20251212123750_uAmsV AU001N 2025-12-14T14:41:32.980Z 2025-12-14T15:16:07.747Z
8750068 8750068 20251209170232_YCXG5 AU001N 2025-12-13T15:37:19.669Z 2025-12-14T15:42:58.009Z
8750050 8750050 20251209165851_v3klo AU001N 2025-12-13T15:37:15.632Z 2025-12-14T15:42:48.658Z
8749987 8749987 20251209163958_tHMrx AU001N 2025-12-13T15:37:07.921Z 2025-12-14T15:42:37.518Z
8749942 8749942 20251209163143_KjE7s AU001N 2025-12-13T15:37:05.732Z 2025-12-14T15:42:35.954Z
8749682 8749682 20251209152353_jdz5Q AU001N 2025-12-13T15:36:53.448Z 2025-12-14T15:42:26.955Z
8749639 8749639 20251209151842_6wU7m AU001N 2025-12-13T15:36:51.197Z 2025-12-14T15:42:25.670Z
8749504 8749504 20251209150220_TwOEC AU001N 2025-12-13T15:36:23.989Z 2025-12-14T15:42:21.751Z
8748733 8748733 20251209131202_b4Evc AU001N 2025-12-13T15:35:20.039Z 2025-12-14T15:41:26.227Z
8748590 8748590 20251209125140_HX7f7 AU001N 2025-12-13T15:34:38.111Z 2025-12-14T15:41:02.696Z
8748545 8748545 20251209124634_hQYms AU001N 2025-12-13T15:34:33.961Z 2025-12-14T15:40:58.772Z
8748339 8748339 20251209121852_xaq5I AU001N 2025-12-13T15:34:19.037Z 2025-12-14T15:40:48.233Z
8705055 8705055 20251208174816_Fgmev AU001N 2025-12-09T14:15:58.092Z 2025-12-14T15:52:43.670Z
8704906 8704906 20251208172402_RXVW2 AU001N 2025-12-09T14:15:47.955Z 2025-12-14T15:52:40.523Z
8704851 8704851 20251208171242_n83w9 AU001N 2025-12-09T14:15:40.910Z 2025-12-14T15:52:39.225Z
8704635 8704635 20251208162129_X3WoU AU001N 2025-12-09T14:15:07.829Z 2025-12-14T15:52:31.001Z
8704627 8704627 20251208161935_3J2sW AU001N 2025-12-09T14:15:06.883Z 2025-12-14T15:52:27.922Z
8704591 8704591 20251208160933_hW0IY AU001N 2025-12-09T14:15:03.363Z 2025-12-14T15:52:20.676Z
8704339 8704339 20251208152342_eMMZd AU001N 2025-12-09T14:14:20.163Z 2025-12-14T15:52:08.101Z
8703569 8703569 20251208134729_7h6BW AU001N 2025-12-09T14:12:19.867Z 2025-12-14T15:51:21.407Z
8703351 8703351 20251208131807_07f6u AU001N 2025-12-09T14:11:39.004Z 2025-12-14T15:51:15.597Z
8703102 8703102 20251208123723_tTC6y AU001N 2025-12-09T14:10:43.333Z 2025-12-14T15:50:52.620Z
8702882 8702882 20251208121051_Hl8Gn AU001N 2025-12-09T14:09:56.397Z 2025-12-14T15:50:47.039Z
8702776 8702776 20251208115743_vv5px AU001N 2025-12-09T14:09:41.431Z 2025-12-14T15:50:27.110Z
8698246 8698246 20251207175023_rpi3I AU001N 2025-12-08T14:14:27.045Z 2025-12-14T15:58:45.463Z
8698232 8698232 20251207173816_NvfqM AU001N 2025-12-08T14:14:24.542Z 2025-12-14T15:58:44.750Z
8698180 8698180 20251207170702_KTyCN AU001N 2025-12-08T14:14:08.923Z 2025-12-08T14:14:08.923Z
8698152 8698152 20251207165624_2Q9zq AU001N 2025-12-08T14:14:02.777Z 2025-12-08T14:14:02.777Z
8698144 8698144 20251207165124_dVXI2 AU001N 2025-12-08T14:14:01.259Z 2025-12-14T15:58:41.440Z
8698134 8698134 20251207164913_x4vYW AU001N 2025-12-08T14:13:59.430Z 2025-12-14T15:58:41.109Z
8698130 8698130 20251207164835_Qu7DN AU001N 2025-12-08T14:13:58.651Z 2025-12-14T15:58:41.083Z
8698090 8698090 20251207162604_4pelS AU001N 2025-12-08T14:13:52.322Z 2025-12-14T15:58:39.474Z
8698076 8698076 20251207160024_iinvX AU001N 2025-12-08T14:13:49.681Z 2025-12-14T15:58:38.930Z
8698066 8698066 20251207155518_syjmS AU001N 2025-12-08T14:13:47.864Z 2025-12-14T15:58:38.577Z
8698057 8698057 20251207155315_mAUpB AU001N 2025-12-08T14:13:46.751Z 2025-12-14T15:58:38.135Z
8697932 8697932 20251207152935_bi1Pv AU001N 2025-12-08T14:13:17.780Z 2025-12-14T15:58:11.812Z
8697606 8697606 20251207144428_UsfV2 AU001N 2025-12-08T14:12:09.680Z 2025-12-14T15:57:51.419Z
8697512 8697512 20251207142734_dKGiH AU001N 2025-12-08T14:11:53.695Z 2025-12-14T15:57:48.799Z
8697316 8697316 20251207140341_1S6TV AU001N 2025-12-08T14:11:08.643Z 2025-12-14T15:57:44.701Z
8697097 8697097 20251207133333_IIUpL AU001N 2025-12-08T14:10:26.903Z 2025-12-14T15:57:39.202Z
8696629 8696629 20251207122441_z43z7 AU001N 2025-12-08T14:08:43.688Z 2025-12-08T14:08:43.688Z
8696240 8696240 20251207112838_Z1DB2 AU001N 2025-12-08T14:06:44.004Z 2025-12-14T15:56:51.672Z
8696043 8696043 20251207110144_hlLAc AU001N 2025-12-08T14:06:05.402Z 2025-12-14T15:56:47.753Z
8696007 8696007 20251207105329_KVACJ AU001N 2025-12-08T14:06:00.375Z 2025-12-14T15:56:47.177Z
8689509 8689509 20251205171818_LwJlu AU001N 2025-12-06T14:08:44.679Z 2025-12-14T16:06:15.616Z
8689483 8689483 20251205164958_G3X0X AU001N 2025-12-06T14:08:38.461Z 2025-12-14T16:06:14.618Z
8689454 8689454 20251205162158_6cUNU AU001N 2025-12-06T14:08:28.064Z 2025-12-14T16:06:13.234Z
8689450 8689450 20251205161506_8N9Jg AU001N 2025-12-06T14:08:26.926Z 2025-12-14T16:06:13.083Z
8689405 8689405 20251205154723_xowAx AU001N 2025-12-06T14:08:14.166Z 2025-12-14T16:06:11.754Z
8689289 8689289 20251205150312_5l0ij AU001N 2025-12-06T14:07:45.617Z 2025-12-14T16:06:08.636Z
8689278 8689278 20251205145839_qfXqB AU001N 2025-12-06T14:07:43.468Z 2025-12-14T16:06:08.459Z
8689261 8689261 20251205145301_Uu2WU AU001N 2025-12-06T14:07:32.034Z 2025-12-14T16:06:07.982Z
8689014 8689014 20251205134415_unBpv AU001N 2025-12-06T14:06:45.627Z 2025-12-14T16:06:03.230Z
8688929 8688929 20251205131938_Mapsi AU001N 2025-12-06T14:06:22.328Z 2025-12-14T16:06:01.102Z
8685240 8685240 20251204163330_5m3NP AU001N 2025-12-05T14:06:17.050Z 2025-12-13T16:03:35.678Z
8685227 8685227 20251204160616_jYVo4 AU001N 2025-12-05T14:06:14.811Z 2025-12-13T16:03:34.205Z
8685225 8685225 20251204155849_AELob AU001N 2025-12-05T14:06:14.391Z 2025-12-13T16:03:34.152Z
8685217 8685217 20251204154656_sArc8 AU001N 2025-12-05T14:06:12.969Z 2025-12-13T16:03:33.894Z
8684796 8684796 20251204141402_xq72o AU001N 2025-12-05T14:04:35.535Z 2025-12-13T16:03:25.456Z
8684679 8684679 20251204134843_Ffg4x AU001N 2025-12-05T14:04:14.890Z 2025-12-13T16:03:23.285Z
8678320 8678320 20251203174913_Upxj8 AU001N 2025-12-04T14:04:19.875Z 2025-12-11T14:41:07.683Z
8678317 8678317 20251203174748_MWLXr AU001N 2025-12-04T14:04:19.325Z 2025-12-11T14:41:05.925Z
8678309 8678309 20251203172742_Agshp AU001N 2025-12-04T14:04:16.837Z 2025-12-11T14:40:49.293Z
8678276 8678276 20251203164652_wLJS9 AU001N 2025-12-04T14:04:10.065Z 2025-12-11T14:40:42.772Z
8678264 8678264 20251203163017_aZbJ2 AU001N 2025-12-04T14:04:06.789Z 2025-12-11T14:40:41.525Z
8678262 8678262 20251203162841_6d06H AU001N 2025-12-04T14:04:06.206Z 2025-12-11T14:40:41.316Z
8678252 8678252 20251203160332_bOUvD AU001N 2025-12-04T14:04:03.662Z 2025-12-11T14:40:39.328Z
8678246 8678246 20251203155940_Pn0G8 AU001N 2025-12-04T14:04:02.401Z 2025-12-11T14:40:38.908Z
8678181 8678181 20251203151953_d20Ee AU001N 2025-12-04T14:03:44.549Z 2025-12-11T14:40:34.320Z
8678094 8678094 20251203144158_HFrVX AU001N 2025-12-04T14:03:30.773Z 2025-12-11T14:40:30.929Z
8678029 8678029 20251203140952_OAbhU AU001N 2025-12-04T14:03:15.769Z 2025-12-11T14:40:22.905Z
8677966 8677966 20251203134750_AxRw7 AU001N 2025-12-04T14:03:06.945Z 2025-12-11T14:40:07.618Z
8673231 8673231 20251201173852_qYh0t AU001N 2025-12-03T14:18:02.518Z 2025-12-10T14:38:15.831Z
8673225 8673225 20251201173457_4ABfi AU001N 2025-12-03T14:18:01.413Z 2025-12-10T14:38:15.641Z
8673183 8673183 20251201172214_jrmSB AU001N 2025-12-03T14:17:48.241Z 2025-12-10T14:38:14.468Z
8673086 8673086 20251201165150_bS0ud AU001N 2025-12-03T14:17:30.562Z 2025-12-10T14:38:12.263Z
8672995 8672995 20251201161320_6151L AU001N 2025-12-03T14:17:05.312Z 2025-12-10T14:38:10.496Z
8672559 8672559 20251201144647_ryQIx AU001N 2025-12-03T14:15:54.187Z 2025-12-10T14:37:56.920Z
8672552 8672552 20251201144550_mXN7O AU001N 2025-12-03T14:15:53.534Z 2025-12-10T14:37:56.795Z
8670324 8670324 20251202165116_VCm1X AU001N 2025-12-03T14:07:59.373Z 2025-12-11T14:43:55.838Z
8670318 8670318 20251202164335_zOFay AU001N 2025-12-03T14:07:57.969Z 2025-12-11T14:43:55.160Z
8670312 8670312 20251202163434_beToz AU001N 2025-12-03T14:07:56.477Z 2025-12-11T14:43:54.757Z
8670290 8670290 20251202161024_5kPPh AU001N 2025-12-03T14:07:51.693Z 2025-12-11T14:43:52.269Z
8670274 8670274 20251202155559_c0b3n AU001N 2025-12-03T14:07:48.010Z 2025-12-11T14:43:51.338Z
8670239 8670239 20251202153944_nWBjw AU001N 2025-12-03T14:07:34.998Z 2025-12-11T14:43:49.836Z
8670216 8670216 20251202152702_yq8iP AU001N 2025-12-03T14:07:27.816Z 2025-12-11T14:43:49.013Z
8670195 8670195 20251202151520_Rd20c AU001N 2025-12-03T14:07:22.384Z 2025-12-11T14:43:48.028Z
8670191 8670191 20251202151356_Njrue AU001N 2025-12-03T14:07:21.535Z 2025-12-11T14:43:47.900Z
8670168 8670168 20251202141507_SOewD AU001N 2025-12-03T14:07:16.579Z 2025-12-11T14:43:45.881Z
8670156 8670156 20251202140234_GCYR1 AU001N 2025-12-03T14:07:05.241Z 2025-12-11T14:43:45.297Z
8670132 8670132 20251202131803_YskPf AU001N 2025-12-03T14:07:00.421Z 2025-12-11T14:43:43.911Z

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