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 = "AU000A" 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
9271752 9271752 20260127194957_mplzn AU000A 2026-01-29T14:23:16.922Z 2026-01-29T14:30:25.098Z
9271656 9271656 20260127190114_MVH3E AU000A 2026-01-29T14:22:09.891Z 2026-01-29T14:30:25.002Z
9271604 9271604 20260127182925_TOMKV AU000A 2026-01-29T14:21:43.769Z 2026-01-29T14:30:24.964Z
9271515 9271515 20260127172621_bW16Q AU000A 2026-01-29T14:21:08.053Z 2026-01-29T14:30:24.884Z
9271444 9271444 20260127160138_22MRo AU000A 2026-01-29T14:20:21.268Z 2026-01-29T14:30:24.682Z
9271214 9271214 20260128202514_tOE2w AU000A 2026-01-29T14:15:35.824Z 2026-01-29T14:15:35.824Z
9271169 9271169 20260128201833_Cfh5H AU000A 2026-01-29T14:15:30.205Z 2026-01-29T14:15:30.205Z
9271022 9271022 20260128192554_y613G AU000A 2026-01-29T14:14:59.095Z 2026-01-29T14:14:59.095Z
9270944 9270944 20260128185622_XTjcK AU000A 2026-01-29T14:14:38.384Z 2026-01-29T14:14:38.384Z
9267078 9267078 20260126184607_8XcFL AU000A 2026-01-28T14:19:02.971Z 2026-01-29T14:34:14.269Z
9267071 9267071 20260126184021_3aDMs AU000A 2026-01-28T14:18:54.181Z 2026-01-29T14:34:12.996Z
9267058 9267058 20260126183510_smPQ3 AU000A 2026-01-28T14:18:47.190Z 2026-01-29T14:34:11.016Z
9267038 9267038 20260126182331_Wum6j AU000A 2026-01-28T14:18:36.384Z 2026-01-29T14:34:01.076Z
9267034 9267034 20260126181637_4R0Sp AU000A 2026-01-28T14:18:33.719Z 2026-01-29T14:34:00.287Z
9266992 9266992 20260126174052_pawkE AU000A 2026-01-28T14:18:11.384Z 2026-01-29T14:33:53.012Z
9266900 9266900 20260126160750_4qEUv AU000A 2026-01-28T14:17:24.467Z 2026-01-29T14:33:40.815Z
9254397 9254397 20260123185653_ntQy4 AU000A 2026-01-25T14:08:59.327Z 2026-01-29T14:46:13.895Z
9254364 9254364 20260123184007_0NfkL AU000A 2026-01-25T14:08:44.746Z 2026-01-29T14:46:11.947Z
9254118 9254118 20260123154726_3WTUk AU000A 2026-01-25T14:07:14.951Z 2026-01-29T14:45:43.173Z
9254087 9254087 20260123151053_ZMmm3 AU000A 2026-01-25T14:07:00.628Z 2026-01-29T14:45:36.081Z
9254027 9254027 20260123132643_ckfBu AU000A 2026-01-25T14:06:28.236Z 2026-01-29T14:45:25.572Z
9239008 9239008 20260117123548_3cQar AU000A 2026-01-21T14:41:08.044Z 2026-01-26T14:59:23.673Z
9238965 9238965 20260118185526_kQqOg AU000A 2026-01-21T14:35:41.593Z 2026-01-27T15:01:08.269Z
9238963 9238963 20260118153636_H2aVY AU000A 2026-01-21T14:35:02.740Z 2026-01-27T15:00:20.762Z
9212173 9212173 20260115194203_vSQj3 AU000A 2026-01-17T14:10:23.466Z 2026-01-24T15:10:30.254Z
9212008 9212008 20260115184153_kYXwi AU000A 2026-01-17T14:09:26.768Z 2026-01-24T15:10:18.553Z
9211973 9211973 20260115183518_KoRfs AU000A 2026-01-17T14:09:20.287Z 2026-01-24T15:10:15.718Z
9211957 9211957 20260115183307_NtTaO AU000A 2026-01-17T14:09:16.987Z 2026-01-24T15:10:14.488Z
9211932 9211932 20260115182601_oW9IP AU000A 2026-01-17T14:09:06.666Z 2026-01-24T15:10:12.092Z
9211800 9211800 20260115175257_pSQY6 AU000A 2026-01-17T14:08:33.247Z 2026-01-24T15:09:56.118Z
9211774 9211774 20260115174312_KYFP2 AU000A 2026-01-17T14:08:25.630Z 2026-01-24T15:09:54.300Z
9211702 9211702 20260115172318_ZGuhO AU000A 2026-01-17T14:08:00.763Z 2026-01-24T15:09:47.509Z
9211624 9211624 20260115165942_OLvgV AU000A 2026-01-17T14:07:33.416Z 2026-01-24T15:09:41.455Z
9211603 9211603 20260115164904_zmXqo AU000A 2026-01-17T14:07:28.254Z 2026-01-24T15:09:38.961Z
9211521 9211521 20260115162331_wFOC9 AU000A 2026-01-17T14:07:04.303Z 2026-01-24T15:09:30.775Z
9211507 9211507 20260115161232_MuBfZ AU000A 2026-01-17T14:07:00.336Z 2026-01-24T15:09:29.164Z
9211472 9211472 20260115155847_PNRe0 AU000A 2026-01-17T14:06:50.385Z 2026-01-24T15:09:17.079Z
9211470 9211470 20260115155847_p3XG9 AU000A 2026-01-17T14:06:47.782Z 2026-01-24T15:09:16.903Z
9211448 9211448 20260115154252_HQyf3 AU000A 2026-01-17T14:06:41.094Z 2026-01-24T15:09:15.185Z
9211415 9211415 20260115152850_HzEtE AU000A 2026-01-17T14:06:32.944Z 2026-01-24T15:09:13.153Z
9211182 9211182 20260115132248_qNvXY AU000A 2026-01-17T14:05:23.715Z 2026-01-24T15:08:51.525Z
9211176 9211176 20260115131351_zldLp AU000A 2026-01-17T14:05:19.355Z 2026-01-24T15:08:44.879Z
9206778 9206778 20260114185152_IFOXG AU000A 2026-01-16T14:05:32.357Z 2026-01-22T15:02:36.342Z
9206729 9206729 20260114183850_nf2da AU000A 2026-01-16T14:05:19.834Z 2026-01-22T15:02:34.943Z
9206513 9206513 20260114172402_h3sm2 AU000A 2026-01-16T14:04:16.938Z 2026-01-22T15:02:28.685Z
9206302 9206302 20260114153359_7DAqM AU000A 2026-01-16T14:03:10.936Z 2026-01-22T15:01:58.900Z
9205742 9205742 20260113125430_866JF AU000A 2026-01-15T14:41:16.503Z 2026-01-21T15:06:26.220Z
9199534 9199534 20260113201609_zEZju AU000A 2026-01-15T14:11:22.605Z 2026-01-22T15:07:26.240Z
9199119 9199119 20260113190439_blN3Y AU000A 2026-01-15T14:09:19.188Z 2026-01-22T15:07:14.371Z
9199085 9199085 20260113190133_eoCJs AU000A 2026-01-15T14:09:10.699Z 2026-01-22T15:07:13.716Z
9198980 9198980 20260113184527_9tG9G AU000A 2026-01-15T14:08:41.351Z 2026-01-22T15:07:10.920Z
9198836 9198836 20260113181438_285Ym AU000A 2026-01-15T14:07:34.658Z 2026-01-22T15:07:06.166Z
9198701 9198701 20260113173956_5udQ2 AU000A 2026-01-15T14:06:33.346Z 2026-01-22T15:07:01.253Z
9198656 9198656 20260113173049_i3RDx AU000A 2026-01-15T14:06:17.480Z 2026-01-22T15:06:59.955Z
9198570 9198570 20260113171011_SSvA9 AU000A 2026-01-15T14:05:35.861Z 2026-01-22T15:06:36.029Z
9198491 9198491 20260113164407_A3gc0 AU000A 2026-01-15T14:04:50.716Z 2026-01-22T15:06:31.708Z
9198297 9198297 20260113152319_IKGEa AU000A 2026-01-15T14:03:04.724Z 2026-01-22T15:06:21.526Z
9194353 9194353 20260112200356_e3iHL AU000A 2026-01-14T14:08:48.505Z 2026-01-21T15:03:52.749Z
9194202 9194202 20260112185135_3RPEd AU000A 2026-01-14T14:07:59.695Z 2026-01-21T15:03:39.969Z
9194114 9194114 20260112180227_AWtl4 AU000A 2026-01-14T14:07:27.601Z 2026-01-21T15:03:31.605Z
9194044 9194044 20260112165818_QPOcF AU000A 2026-01-14T14:06:46.396Z 2026-01-21T15:03:22.951Z
9193951 9193951 20260112154059_lckYI AU000A 2026-01-14T14:05:52.685Z 2026-01-21T15:02:59.217Z
9180317 9180317 20260110195649_OD7Wx AU000A 2026-01-12T14:06:40.529Z 2026-01-19T15:15:56.192Z
9179987 9179987 20260110183409_ItKUS AU000A 2026-01-12T14:05:15.522Z 2026-01-19T15:15:39.847Z
9179795 9179795 20260110174435_nG1yr AU000A 2026-01-12T14:04:21.722Z 2026-01-19T15:15:16.512Z
9179706 9179706 20260110172419_ajj05 AU000A 2026-01-12T14:03:58.503Z 2026-01-19T15:15:12.399Z
9179544 9179544 20260110163052_8GQnO AU000A 2026-01-12T14:03:11.162Z 2026-01-19T15:15:04.176Z
9174405 9174405 20260109175851_ZW0CO AU000A 2026-01-11T14:03:02.381Z 2026-01-18T15:06:43.916Z
9174378 9174378 20260109161938_ZVGe3 AU000A 2026-01-11T14:02:50.350Z 2026-01-18T15:06:40.767Z
9174372 9174372 20260109155943_jRNkK AU000A 2026-01-11T14:02:44.753Z 2026-01-18T15:06:39.136Z
9170382 9170382 20260105131445_984vM AU000A 2026-01-09T14:29:58.591Z 2026-01-13T15:16:26.562Z
9170380 9170380 20260105131431_nnnla AU000A 2026-01-09T14:29:58.212Z 2026-01-13T15:16:26.369Z
9170377 9170377 20260106155551_4N8yJ AU000A 2026-01-09T14:25:38.780Z 2026-01-13T15:11:13.633Z
9170326 9170326 20260107151645_pYNgk AU000A 2026-01-09T14:20:30.910Z 2026-01-13T15:05:33.687Z
9170273 9170273 20260107131629_O7UlL AU000A 2026-01-09T14:19:32.877Z 2026-01-13T15:04:37.441Z
9170261 9170261 20260107125549_KWTSg AU000A 2026-01-09T14:19:22.328Z 2026-01-13T15:04:30.278Z
9166219 9166219 20260107172213_i0XC5 AU000A 2026-01-09T14:02:12.037Z 2026-01-16T15:09:32.414Z
9166139 9166139 20260107164629_7aLK9 AU000A 2026-01-09T14:01:44.276Z 2026-01-16T15:09:26.301Z
9156825 9156825 20260104133251_9ElR9 AU000A 2026-01-06T14:40:55.145Z 2026-01-12T15:12:38.988Z
9133563 9133563 20260103133607_SoSAi AU000A 2026-01-04T14:21:25.891Z 2026-01-10T15:03:12.796Z
9125825 9125825 20251231185926_pn2Zl AU000A 2026-01-02T14:56:12.988Z 2026-01-08T15:16:09.833Z
9125706 9125706 20251231183631_BnjEM AU000A 2026-01-02T14:55:56.743Z 2026-01-08T15:15:55.157Z
9125673 9125673 20251231182923_8LMfP AU000A 2026-01-02T14:55:52.845Z 2026-01-08T15:15:52.028Z
9125671 9125671 20251231182923_z9jle AU000A 2026-01-02T14:55:52.540Z 2026-01-08T15:15:51.913Z
9125638 9125638 20251231182635_EoQOK AU000A 2026-01-02T14:55:41.717Z 2026-01-08T15:15:50.843Z
9125540 9125540 20251231181536_niPSX AU000A 2026-01-02T14:55:29.868Z 2026-01-08T15:15:45.589Z
9125261 9125261 20251231171705_t4Uh1 AU000A 2026-01-02T14:54:38.343Z 2026-01-08T15:15:21.252Z
9125191 9125191 20251231170330_293Ev AU000A 2026-01-02T14:54:26.051Z 2026-01-08T15:15:17.191Z
9123142 9123142 20260101182256_3gRBO AU000A 2026-01-02T14:16:56.207Z 2026-01-09T14:54:28.818Z
9123099 9123099 20260101175420_7mdoD AU000A 2026-01-02T14:16:40.034Z 2026-01-09T14:54:23.603Z
9120392 9120392 20260101200921_rA45C AU000A 2026-01-02T14:02:02.596Z 2026-01-09T14:48:26.773Z
9120285 9120285 20260101192125_fSbsA AU000A 2026-01-02T14:01:09.514Z 2026-01-09T14:48:15.716Z
9120265 9120265 20260101191307_Bu06l AU000A 2026-01-02T14:00:59.316Z 2026-01-09T14:48:14.030Z
9120248 9120248 20260101190542_jilSX AU000A 2026-01-02T14:00:49.853Z 2026-01-09T14:48:12.428Z
9120189 9120189 20260101184758_CWxaG AU000A 2026-01-02T14:00:19.191Z 2026-01-09T14:48:08.354Z
9120173 9120173 20251228200753_PmzmO AU000A 2026-01-01T15:34:16.575Z 2026-01-05T15:14:43.375Z
9119117 9119117 20251230162942_2WNXk AU000A 2026-01-01T14:54:53.436Z 2026-01-07T15:12:05.975Z
9109657 9109657 20251230201305_f5JtB AU000A 2026-01-01T14:02:27.603Z 2026-01-08T15:04:17.569Z
9109476 9109476 20251230194158_9Xrzb AU000A 2026-01-01T14:00:55.066Z 2026-01-08T15:03:53.088Z
9109464 9109464 20251230194046_i9TBZ AU000A 2026-01-01T14:00:50.154Z 2026-01-08T15:03:52.534Z

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