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,029 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
8705055 8705055 20251208174816_Fgmev AU001N 2025-12-09T14:15:58.092Z 2025-12-10T14:17:08.393Z
8704906 8704906 20251208172402_RXVW2 AU001N 2025-12-09T14:15:47.955Z 2025-12-10T14:17:08.323Z
8704851 8704851 20251208171242_n83w9 AU001N 2025-12-09T14:15:40.910Z 2025-12-10T14:17:08.278Z
8704635 8704635 20251208162129_X3WoU AU001N 2025-12-09T14:15:07.829Z 2025-12-10T14:17:08.105Z
8704627 8704627 20251208161935_3J2sW AU001N 2025-12-09T14:15:06.883Z 2025-12-10T14:17:08.102Z
8704591 8704591 20251208160933_hW0IY AU001N 2025-12-09T14:15:03.363Z 2025-12-10T14:17:08.045Z
8704339 8704339 20251208152342_eMMZd AU001N 2025-12-09T14:14:20.163Z 2025-12-10T14:17:07.391Z
8703569 8703569 20251208134729_7h6BW AU001N 2025-12-09T14:12:19.867Z 2025-12-10T14:17:05.783Z
8703351 8703351 20251208131807_07f6u AU001N 2025-12-09T14:11:39.004Z 2025-12-10T14:17:04.504Z
8703102 8703102 20251208123723_tTC6y AU001N 2025-12-09T14:10:43.333Z 2025-12-10T14:17:04.069Z
8702882 8702882 20251208121051_Hl8Gn AU001N 2025-12-09T14:09:56.397Z 2025-12-10T14:17:03.971Z
8702776 8702776 20251208115743_vv5px AU001N 2025-12-09T14:09:41.431Z 2025-12-10T14:17:03.905Z
8698246 8698246 20251207175023_rpi3I AU001N 2025-12-08T14:14:27.045Z 2025-12-11T14:25:00.689Z
8698232 8698232 20251207173816_NvfqM AU001N 2025-12-08T14:14:24.542Z 2025-12-11T14:24:59.388Z
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-11T14:24:52.545Z
8698134 8698134 20251207164913_x4vYW AU001N 2025-12-08T14:13:59.430Z 2025-12-11T14:24:51.158Z
8698130 8698130 20251207164835_Qu7DN AU001N 2025-12-08T14:13:58.651Z 2025-12-11T14:24:51.058Z
8698090 8698090 20251207162604_4pelS AU001N 2025-12-08T14:13:52.322Z 2025-12-11T14:24:47.563Z
8698076 8698076 20251207160024_iinvX AU001N 2025-12-08T14:13:49.681Z 2025-12-11T14:24:46.619Z
8698066 8698066 20251207155518_syjmS AU001N 2025-12-08T14:13:47.864Z 2025-12-11T14:24:45.877Z
8698057 8698057 20251207155315_mAUpB AU001N 2025-12-08T14:13:46.751Z 2025-12-11T14:24:45.337Z
8697932 8697932 20251207152935_bi1Pv AU001N 2025-12-08T14:13:17.780Z 2025-12-11T14:24:31.061Z
8697606 8697606 20251207144428_UsfV2 AU001N 2025-12-08T14:12:09.680Z 2025-12-11T14:24:16.154Z
8697512 8697512 20251207142734_dKGiH AU001N 2025-12-08T14:11:53.695Z 2025-12-11T14:24:11.516Z
8697316 8697316 20251207140341_1S6TV AU001N 2025-12-08T14:11:08.643Z 2025-12-11T14:23:53.624Z
8697097 8697097 20251207133333_IIUpL AU001N 2025-12-08T14:10:26.903Z 2025-12-11T14:23:39.509Z
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-11T14:22:39.828Z
8696043 8696043 20251207110144_hlLAc AU001N 2025-12-08T14:06:05.402Z 2025-12-11T14:22:30.298Z
8696007 8696007 20251207105329_KVACJ AU001N 2025-12-08T14:06:00.375Z 2025-12-11T14:22:29.057Z
8689509 8689509 20251205171818_LwJlu AU001N 2025-12-06T14:08:44.679Z 2025-12-11T14:34:47.578Z
8689483 8689483 20251205164958_G3X0X AU001N 2025-12-06T14:08:38.461Z 2025-12-11T14:34:46.159Z
8689454 8689454 20251205162158_6cUNU AU001N 2025-12-06T14:08:28.064Z 2025-12-11T14:34:43.856Z
8689450 8689450 20251205161506_8N9Jg AU001N 2025-12-06T14:08:26.926Z 2025-12-11T14:34:43.587Z
8689405 8689405 20251205154723_xowAx AU001N 2025-12-06T14:08:14.166Z 2025-12-11T14:34:41.065Z
8689289 8689289 20251205150312_5l0ij AU001N 2025-12-06T14:07:45.617Z 2025-12-11T14:34:30.855Z
8689278 8689278 20251205145839_qfXqB AU001N 2025-12-06T14:07:43.468Z 2025-12-11T14:34:28.193Z
8689261 8689261 20251205145301_Uu2WU AU001N 2025-12-06T14:07:32.034Z 2025-12-11T14:34:22.605Z
8689014 8689014 20251205134415_unBpv AU001N 2025-12-06T14:06:45.627Z 2025-12-11T14:34:05.729Z
8688929 8688929 20251205131938_Mapsi AU001N 2025-12-06T14:06:22.328Z 2025-12-11T14:34:02.423Z
8685240 8685240 20251204163330_5m3NP AU001N 2025-12-05T14:06:17.050Z 2025-12-11T14:37:12.434Z
8685227 8685227 20251204160616_jYVo4 AU001N 2025-12-05T14:06:14.811Z 2025-12-11T14:37:10.103Z
8685225 8685225 20251204155849_AELob AU001N 2025-12-05T14:06:14.391Z 2025-12-11T14:37:09.967Z
8685217 8685217 20251204154656_sArc8 AU001N 2025-12-05T14:06:12.969Z 2025-12-11T14:37:09.638Z
8684796 8684796 20251204141402_xq72o AU001N 2025-12-05T14:04:35.535Z 2025-12-11T14:36:55.828Z
8684679 8684679 20251204134843_Ffg4x AU001N 2025-12-05T14:04:14.890Z 2025-12-11T14:36:51.579Z
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
8670114 8670114 20251202131306_u2rky AU001N 2025-12-03T14:06:57.616Z 2025-12-11T14:43:43.118Z
8670087 8670087 20251202130633_pG5X3 AU001N 2025-12-03T14:06:52.119Z 2025-12-11T14:43:42.376Z
8669747 8669747 20251202120716_rKD9s AU001N 2025-12-03T14:05:20.917Z 2025-12-11T14:43:31.413Z
8669196 8669196 20251202103002_LBzgK AU001N 2025-12-03T14:02:49.864Z 2025-12-11T14:42:50.186Z
8662016 8662016 20251130174244_Dupxe AU001N 2025-12-02T14:13:58.770Z 2025-12-09T14:56:26.520Z
8661766 8661766 20251130170843_W7TCG AU001N 2025-12-02T14:12:58.092Z 2025-12-09T14:56:19.821Z
8661712 8661712 20251130165653_UX1uD AU001N 2025-12-02T14:12:41.990Z 2025-12-09T14:56:18.093Z
8661708 8661708 20251130165625_ENVob AU001N 2025-12-02T14:12:41.095Z 2025-12-09T14:56:17.994Z
8661682 8661682 20251130165228_cMYtB AU001N 2025-12-02T14:12:35.426Z 2025-12-09T14:56:17.331Z
8661674 8661674 20251130164935_JU46z AU001N 2025-12-02T14:12:33.536Z 2025-12-09T14:56:17.227Z
8661643 8661643 20251130164034_5zurM AU001N 2025-12-02T14:12:26.947Z 2025-12-09T14:56:15.934Z
8661637 8661637 20251130163748_lbFw7 AU001N 2025-12-02T14:12:25.410Z 2025-12-09T14:56:15.541Z
8661603 8661603 20251130161752_BuoZR AU001N 2025-12-02T14:12:10.708Z 2025-12-09T14:56:10.711Z
8661536 8661536 20251130154455_XD3kl AU001N 2025-12-02T14:11:49.830Z 2025-12-09T14:55:40.579Z
8661492 8661492 20251130153518_iNU11 AU001N 2025-12-02T14:11:39.050Z 2025-12-09T14:55:31.497Z
8661449 8661449 20251130152342_JZCx1 AU001N 2025-12-02T14:11:30.821Z 2025-12-09T14:55:30.565Z
8661294 8661294 20251130150610_J8YZ4 AU001N 2025-12-02T14:11:01.957Z 2025-12-09T14:55:27.348Z
8661189 8661189 20251130145700_YQcJY AU001N 2025-12-02T14:10:40.329Z 2025-12-09T14:55:22.461Z
8661075 8661075 20251130144009_nE27j AU001N 2025-12-02T14:10:16.844Z 2025-12-09T14:55:20.150Z
8660975 8660975 20251130142017_4Cf6W AU001N 2025-12-02T14:09:52.145Z 2025-12-09T14:55:17.683Z
8660378 8660378 20251130124325_88b0x AU001N 2025-12-02T14:07:41.307Z 2025-12-09T14:55:04.278Z

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