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

2,694 rows where station_code = "AU002E" 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
8661584 8661584 20251130160621_1cR6X AU002E 2025-12-02T14:12:06.016Z 2025-12-06T14:38:13.789Z
8650311 8650311 20251129195157_jcrso AU002E 2025-12-01T14:15:46.479Z 2025-12-06T14:45:53.975Z
8650104 8650104 20251129192409_2Q3TI AU002E 2025-12-01T14:15:05.758Z 2025-12-06T14:45:48.206Z
8650036 8650036 20251129191126_aDVct AU002E 2025-12-01T14:14:45.909Z 2025-12-06T14:45:46.094Z
8650026 8650026 20251129190829_02qRg AU002E 2025-12-01T14:14:43.913Z 2025-12-06T14:45:45.773Z
8649323 8649323 20251129170547_jS5qP AU002E 2025-12-01T14:12:01.065Z 2025-12-06T14:44:55.867Z
8649193 8649193 20251129163506_ezY31 AU002E 2025-12-01T14:11:23.892Z 2025-12-06T14:44:50.981Z
8649186 8649186 20251129163321_dytbt AU002E 2025-12-01T14:11:22.263Z 2025-12-06T14:44:50.874Z
8649158 8649158 20251129162740_FBpLz AU002E 2025-12-01T14:11:14.582Z 2025-12-06T14:44:50.194Z
8649117 8649117 20251129161607_hXlBu AU002E 2025-12-01T14:10:59.598Z 2025-12-06T14:44:49.093Z
8644421 8644421 20251128192601_Ce83M AU002E 2025-11-30T14:21:59.002Z 2025-12-06T14:54:42.094Z
8644295 8644295 20251128191835_RHgZJ AU002E 2025-11-30T14:21:36.246Z 2025-12-06T14:54:40.510Z
8644271 8644271 20251128191342_WppGl AU002E 2025-11-30T14:21:32.934Z 2025-12-06T14:54:40.174Z
8644143 8644143 20251128190223_ppEqP AU002E 2025-11-30T14:21:24.084Z 2025-12-06T14:54:38.695Z
8562255 8562255 20251121135459_zcLpf AU002E 2025-11-23T14:05:11.293Z 2025-11-30T15:03:25.567Z
8478482 8478482 20251115172135_DJPyM AU002E 2025-11-17T14:13:39.671Z 2025-11-24T15:04:14.005Z
8474602 8474602 20251115131329_6m5hT AU002E 2025-11-17T14:04:58.476Z 2025-11-24T15:02:57.372Z
8433191 8433191 20251111164215_u97aD AU002E 2025-11-13T14:09:39.627Z 2025-11-20T15:20:36.393Z
8419067 8419067 20251110152652_MBCWz AU002E 2025-11-12T14:05:08.619Z 2025-11-19T15:12:58.302Z
8418815 8418815 20251110143702_qvinF AU002E 2025-11-12T14:03:44.089Z 2025-11-19T15:12:46.371Z
8401766 8401766 20251108172333_GuQ23 AU002E 2025-11-10T14:04:20.227Z 2025-11-17T14:58:01.953Z
8401722 8401722 20251108165358_tKhgr AU002E 2025-11-10T14:04:03.731Z 2025-11-17T14:58:00.030Z
8401617 8401617 20251108154250_YV5Hb AU002E 2025-11-10T14:03:22.494Z 2025-11-17T14:57:56.478Z
8401495 8401495 20251108150742_F8VDo AU002E 2025-11-10T14:02:56.082Z 2025-11-17T14:57:50.759Z
8401328 8401328 20251108142446_rP3sa AU002E 2025-11-10T14:02:13.596Z 2025-11-17T14:57:47.236Z
8401284 8401284 20251108141112_Knlow AU002E 2025-11-10T14:01:58.248Z 2025-11-17T14:57:46.839Z
8401209 8401209 20251108133947_CZ5eX AU002E 2025-11-10T14:01:40.490Z 2025-11-17T14:57:46.177Z
8400944 8400944 20251107121538_rn2kq AU002E 2025-11-09T14:30:18.454Z 2025-11-15T15:01:10.005Z
8395866 8395866 20251107183542_pPXzc AU002E 2025-11-09T14:06:15.782Z 2025-11-16T15:02:54.351Z
8395738 8395738 20251107175916_A3aSL AU002E 2025-11-09T14:05:39.509Z 2025-11-16T15:02:42.113Z
8395609 8395609 20251107172722_Gl3uV AU002E 2025-11-09T14:05:06.832Z 2025-11-16T15:02:35.627Z
8395510 8395510 20251107165707_DvRlS AU002E 2025-11-09T14:04:42.359Z 2025-11-16T15:02:29.046Z
8395312 8395312 20251107151918_eYbQn AU002E 2025-11-09T14:03:32.386Z 2025-11-16T15:02:10.738Z
8395144 8395144 20251107142713_X4CJi AU002E 2025-11-09T14:02:33.582Z 2025-11-16T15:02:02.840Z
8388655 8388655 20251106154719_cegzx AU002E 2025-11-08T14:02:52.314Z 2025-11-15T14:59:11.110Z
8368665 8368665 20251103154840_99R6a AU002E 2025-11-05T14:03:22.257Z 2025-11-12T15:08:38.830Z
8368647 8368647 20251103154420_Vv8Z8 AU002E 2025-11-05T14:03:18.380Z 2025-11-12T15:08:38.667Z
8361085 8361085 20251102163345_CFZlO AU002E 2025-11-04T14:06:54.045Z 2025-11-11T15:02:44.848Z
8360537 8360537 20251102153334_waAql AU002E 2025-11-04T14:05:01.137Z 2025-11-11T15:02:33.687Z
8359516 8359516 20251102132140_G2XuJ AU002E 2025-11-04T14:01:02.974Z 2025-11-11T15:02:19.139Z
8359455 8359455 20251102131110_2J22E AU002E 2025-11-04T14:00:48.558Z 2025-11-11T15:02:18.286Z
8349087 8349087 20251101173053_22RpH AU002E 2025-11-03T14:05:47.134Z 2025-11-10T15:04:10.958Z
8348393 8348393 20251101151321_385ZR AU002E 2025-11-03T14:02:42.537Z 2025-11-10T15:03:07.264Z
8332244 8332244 20251030170842_mdGg1 AU002E 2025-11-02T14:15:03.688Z 2025-11-08T15:10:32.639Z
8332221 8332221 20251030163434_3vW3z AU002E 2025-11-02T14:14:41.272Z 2025-11-08T15:10:29.090Z
8332211 8332211 20251030162300_UOKkL AU002E 2025-11-02T14:14:37.611Z 2025-11-08T15:10:28.101Z
8316587 8316587 20251030172903_6yHQL AU002E 2025-11-01T12:06:24.853Z 2025-11-08T15:10:40.237Z
8288948 8288948 20251028180650_dSo07 AU002E 2025-10-30T12:12:01.029Z 2025-11-06T15:11:34.887Z
8288921 8288921 20251028180545_yqlk8 AU002E 2025-10-30T12:11:58.142Z 2025-11-06T15:11:34.704Z
8288758 8288758 20251028175342_VBsm7 AU002E 2025-10-30T12:11:24.173Z 2025-11-06T15:11:32.923Z
8288664 8288664 20251028174434_X73xr AU002E 2025-10-30T12:10:58.421Z 2025-11-06T15:11:30.376Z
8288556 8288556 20251028173737_WKDDf AU002E 2025-10-30T12:10:37.627Z 2025-11-06T15:11:28.009Z
8288212 8288212 20251028170714_PLocD AU002E 2025-10-30T12:09:38.929Z 2025-11-06T15:11:05.392Z
8288177 8288177 20251028170414_SOM41 AU002E 2025-10-30T12:09:29.227Z 2025-11-06T15:11:02.174Z
8286084 8286084 20251028141052_vsGx3 AU002E 2025-10-30T12:02:35.827Z 2025-11-06T15:10:21.557Z
8286042 8286042 20251028140840_c2SAc AU002E 2025-10-30T12:02:31.718Z 2025-11-06T15:10:20.928Z
8285814 8285814 20251028134920_sITkG AU002E 2025-10-30T12:01:42.577Z 2025-11-06T15:10:16.867Z
8285574 8285574 20251028132449_Y8u3i AU002E 2025-10-30T12:00:54.833Z 2025-11-06T15:10:12.642Z
8249958 8249958 20251026183420_2Ciee AU002E 2025-10-28T12:07:30.550Z 2025-11-04T15:40:13.567Z
8249563 8249563 20251026175209_HoEUl AU002E 2025-10-28T12:06:13.482Z 2025-11-04T15:40:04.910Z
8248328 8248328 20251026134142_3SRNv AU002E 2025-10-28T12:01:17.156Z 2025-11-04T15:38:48.084Z
8231154 8231154 20251025174627_Gxm7o AU002E 2025-10-27T12:06:43.276Z 2025-11-03T15:15:34.200Z
8231108 8231108 20251025171425_N2WXt AU002E 2025-10-27T12:06:31.097Z 2025-11-03T15:15:32.406Z
8231106 8231106 20251025171424_vLjpt AU002E 2025-10-27T12:06:30.728Z 2025-11-03T15:15:32.401Z
8231070 8231070 20251025165617_31C78 AU002E 2025-10-27T12:06:23.201Z 2025-11-03T15:15:32.158Z
8231048 8231048 20251025164425_C36a3 AU002E 2025-10-27T12:06:19.714Z 2025-11-03T15:15:31.798Z
8231045 8231045 20251025164222_6zHhd AU002E 2025-10-27T12:06:19.429Z 2025-11-03T15:15:31.782Z
8230551 8230551 20251025153854_q9wT0 AU002E 2025-10-27T12:04:58.729Z 2025-11-03T15:15:21.368Z
8229769 8229769 20251025140555_nySlb AU002E 2025-10-27T12:02:18.947Z 2025-11-03T15:15:10.462Z
8208404 8208404 20251023132118_JPpDX AU002E 2025-10-26T12:12:41.479Z 2025-11-01T13:09:01.760Z
8208317 8208317 20251023123753_P9pdG AU002E 2025-10-26T12:12:05.618Z 2025-11-01T13:08:59.102Z
8178108 8178108 20251021184941_TTVow AU002E 2025-10-23T12:12:15.870Z 2025-10-30T13:12:46.392Z
8177604 8177604 20251021173353_OJ6RJ AU002E 2025-10-23T12:10:36.980Z 2025-10-30T13:12:44.639Z
8177459 8177459 20251021170701_ymVt2 AU002E 2025-10-23T12:10:01.022Z 2025-10-30T13:12:44.125Z
8177320 8177320 20251021164746_iTcyO AU002E 2025-10-23T12:09:28.546Z 2025-10-30T13:12:43.661Z
8177283 8177283 20251021164007_JV5Hr AU002E 2025-10-23T12:09:21.274Z 2025-10-30T13:12:43.217Z
8176655 8176655 20251021154036_SWzmA AU002E 2025-10-23T12:07:17.759Z 2025-10-30T13:12:38.485Z
8176063 8176063 20251021145411_gLcX2 AU002E 2025-10-23T12:05:40.748Z 2025-10-30T13:12:36.566Z
8175985 8175985 20251021144743_1WBrI AU002E 2025-10-23T12:05:17.919Z 2025-10-30T13:12:36.256Z
8174575 8174575 20251021123124_a8RUZ AU002E 2025-10-23T12:00:40.861Z 2025-10-30T13:12:32.052Z
8156983 8156983 20251018174952_K0Ppw AU002E 2025-10-21T12:19:02.287Z 2025-10-27T13:09:38.306Z
8156913 8156913 20251018152034_ZvViW AU002E 2025-10-21T12:18:18.097Z 2025-10-27T13:09:32.818Z
8156895 8156895 20251018142313_xjJ1C AU002E 2025-10-21T12:18:08.977Z 2025-10-27T13:09:28.669Z
8141624 8141624 20251018191622_ftaF3 AU002E 2025-10-20T12:07:54.159Z 2025-10-27T13:09:42.489Z
8141230 8141230 20251018174952_t3EJq AU002E 2025-10-20T12:06:09.233Z 2025-10-20T12:31:45.094Z
8141136 8141136 20251018172010_eNelV AU002E 2025-10-20T12:05:48.047Z 2025-10-27T13:09:36.896Z
8141119 8141119 20251018171146_fc0wi AU002E 2025-10-20T12:05:44.767Z 2025-10-27T13:09:36.700Z
8141033 8141033 20251018162358_QObIs AU002E 2025-10-20T12:05:15.883Z 2025-10-27T13:09:34.555Z
8140973 8140973 20251018160106_SIkJB AU002E 2025-10-20T12:04:58.046Z 2025-10-27T13:09:33.483Z
8109195 8109195 20251015162356_xYvFh AU002E 2025-10-17T12:04:28.471Z 2025-10-24T13:15:14.408Z
8109109 8109109 20251015154956_qBZhr AU002E 2025-10-17T12:03:58.073Z 2025-10-24T13:15:06.840Z
8108909 8108909 20251015132841_0rH1m AU002E 2025-10-17T12:03:01.029Z 2025-10-24T13:14:47.938Z
8097320 8097320 20251013191755_7zH7N AU002E 2025-10-15T12:12:28.736Z 2025-10-22T13:09:30.474Z
8097225 8097225 20251013182153_7fms3 AU002E 2025-10-15T12:11:52.694Z 2025-10-22T13:09:26.193Z
8097197 8097197 20251013180620_7vCBb AU002E 2025-10-15T12:11:47.254Z 2025-10-22T13:09:24.553Z
8084022 8084022 20251012115126_xJu6V AU002E 2025-10-13T12:00:59.947Z 2025-10-21T13:08:15.190Z
8037301 8037301 20251001194612_gusyr AU002E 2025-10-03T12:17:42.574Z 2025-10-10T12:39:36.476Z
8037210 8037210 20251001192006_Fh54m AU002E 2025-10-03T12:17:23.214Z 2025-10-10T12:39:21.438Z
8037199 8037199 20251001191627_5G9s3 AU002E 2025-10-03T12:17:21.848Z 2025-10-10T12:39:20.409Z
8037104 8037104 20251001184102_IbIvV AU002E 2025-10-03T12:17:10.640Z 2025-10-10T12:39:09.018Z

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