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 = "AU001P" 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
9381981 9381981 20260223154250_bOZdC AU001P 2026-02-24T14:27:02.846Z 2026-03-03T14:32:17.489Z
9381952 9381952 20260223152951_BUJLB AU001P 2026-02-24T14:26:53.321Z 2026-03-03T14:32:16.764Z
9381949 9381949 20260223152951_VpsR2 AU001P 2026-02-24T14:26:53.021Z 2026-03-03T14:32:16.741Z
9381735 9381735 20260223130022_qbTul AU001P 2026-02-24T14:25:58.632Z 2026-03-03T14:32:04.622Z
9378847 9378847 20260222152132_3QC3E AU001P 2026-02-24T14:19:59.891Z 2026-02-24T14:19:59.891Z
9378843 9378843 20260222152129_tz301 AU001P 2026-02-24T14:19:59.646Z 2026-02-24T14:19:59.646Z
9351018 9351018 20260217162230_9wAKi AU001P 2026-02-20T14:02:37.130Z 2026-02-26T14:39:41.401Z
9350957 9350957 20260217154459_Rueku AU001P 2026-02-20T14:02:34.917Z 2026-02-26T14:39:39.891Z
9350946 9350946 20260217152328_JTotP AU001P 2026-02-20T14:02:33.911Z 2026-02-26T14:39:39.285Z
9349825 9349825 20260218190652_qu3Y6 AU001P 2026-02-20T14:01:59.198Z 2026-02-27T14:35:53.602Z
9349315 9349315 20260218174957_IRCVM AU001P 2026-02-20T14:01:57.396Z 2026-02-27T14:35:48.573Z
9349029 9349029 20260218165902_MKsl8 AU001P 2026-02-20T14:01:56.325Z 2026-02-27T14:35:45.708Z
9348846 9348846 20260218163024_KRpua AU001P 2026-02-20T14:01:55.745Z 2026-02-27T14:35:36.017Z
9348690 9348690 20260218161258_77c94 AU001P 2026-02-20T14:01:55.194Z 2026-02-27T14:35:34.236Z
9347471 9347471 20260218135041_YrT2n AU001P 2026-02-20T14:01:52.154Z 2026-02-27T14:35:06.804Z
9347284 9347284 20260218133307_9R1nw AU001P 2026-02-20T14:01:47.813Z 2026-02-27T14:35:05.134Z
9338564 9338564 20260217160928_Q8fHh AU001P 2026-02-18T14:11:37.912Z 2026-02-26T14:39:40.887Z
9338310 9338310 20260217144715_QgG7V AU001P 2026-02-18T14:10:37.364Z 2026-02-26T14:39:38.450Z
9333794 9333794 20260215154751_yelEv AU001P 2026-02-17T14:21:15.413Z 2026-02-24T14:42:36.896Z
9329135 9329135 20260215162607_Gc8UK AU001P 2026-02-16T14:11:45.981Z 2026-02-24T14:42:38.299Z
9321680 9321680 20260212173415_IrOKI AU001P 2026-02-14T14:19:07.034Z 2026-02-21T14:37:28.999Z
9321604 9321604 20260212162814_Qs2zh AU001P 2026-02-14T14:18:11.465Z 2026-02-21T14:37:26.838Z
9320891 9320891 20260213150048_FbskC AU001P 2026-02-14T14:09:14.025Z 2026-02-22T14:42:14.795Z
9305845 9305845 20260208163055_nv9Ra AU001P 2026-02-09T14:13:57.747Z 2026-02-16T14:53:33.428Z
9293875 9293875 20260205164650_ktUAU AU001P 2026-02-06T14:11:47.860Z 2026-02-06T14:11:47.860Z
9270709 9270709 20260128163940_Yt22y AU001P 2026-01-29T14:13:29.451Z 2026-02-06T14:46:16.447Z
9265990 9265990 20260127162926_bb2zx AU001P 2026-01-28T14:11:59.874Z 2026-02-05T14:47:38.164Z
9262184 9262184 20260126174812_VH2WW AU001P 2026-01-27T14:08:06.456Z 2026-02-04T14:48:07.804Z
9258829 9258829 20260124172100_TSwxF AU001P 2026-01-26T14:14:36.848Z 2026-02-02T14:47:52.454Z
9258759 9258759 20260124164207_q0S89 AU001P 2026-01-26T14:14:14.551Z 2026-02-02T14:47:38.055Z
9247243 9247243 20260121174239_TncFT AU001P 2026-01-23T14:09:30.056Z 2026-01-30T14:53:08.167Z
9246874 9246874 20260121151050_MGv1z AU001P 2026-01-23T14:08:15.200Z 2026-01-30T14:52:49.984Z
9246871 9246871 20260121150949_pcuW6 AU001P 2026-01-23T14:08:14.693Z 2026-01-30T14:52:49.822Z
9240980 9240980 20260120184124_odQVL AU001P 2026-01-22T14:11:07.126Z 2026-01-29T15:02:07.840Z
9240776 9240776 20260120174533_jDCyB AU001P 2026-01-22T14:09:57.631Z 2026-01-29T15:01:54.241Z
9240694 9240694 20260120172605_9z5pg AU001P 2026-01-22T14:09:37.489Z 2026-01-29T15:01:46.373Z
9240377 9240377 20260120154244_Pow1z AU001P 2026-01-22T14:08:05.524Z 2026-01-29T15:01:20.834Z
9240376 9240376 20260120153804_dakEl AU001P 2026-01-22T14:08:03.710Z 2026-01-29T15:01:20.211Z
9240302 9240302 20260120150205_4M08U AU001P 2026-01-22T14:07:39.494Z 2026-01-29T15:01:03.482Z
9233788 9233788 20260119175358_Y6ozF AU001P 2026-01-21T14:10:37.432Z 2026-01-28T14:56:34.208Z
9233635 9233635 20260119155241_U1Knn AU001P 2026-01-21T14:09:19.829Z 2026-01-28T14:56:15.841Z
9233618 9233618 20260119153248_n1XiC AU001P 2026-01-21T14:09:11.124Z 2026-01-28T14:56:12.733Z
9212188 9212188 20260115194729_ZhfPZ AU001P 2026-01-17T14:10:28.474Z 2026-01-17T14:10:28.474Z
9211975 9211975 20260115183518_KoRfs AU001P 2026-01-17T14:09:20.287Z 2026-01-24T15:10:15.718Z
9211927 9211927 20260115182446_CNOtg AU001P 2026-01-17T14:09:05.506Z 2026-01-24T15:10:11.485Z
9211875 9211875 20260115181436_KH3C2 AU001P 2026-01-17T14:08:52.601Z 2026-01-24T15:10:07.931Z
9211681 9211681 20260115171438_WdvxZ AU001P 2026-01-17T14:07:53.231Z 2026-01-24T15:09:45.715Z
9211679 9211679 20260115171438_cLys2 AU001P 2026-01-17T14:07:52.248Z 2026-01-24T15:09:45.602Z
9211622 9211622 20260115165858_pzq1b AU001P 2026-01-17T14:07:32.931Z 2026-01-24T15:09:41.219Z
9211620 9211620 20260115165858_oOc5y AU001P 2026-01-17T14:07:32.279Z 2026-01-24T15:09:40.972Z
9211545 9211545 20260115162850_DvJRZ AU001P 2026-01-17T14:07:11.581Z 2026-01-24T15:09:31.792Z
9211473 9211473 20260115155847_PNRe0 AU001P 2026-01-17T14:06:50.385Z 2026-01-24T15:09:17.079Z
9211183 9211183 20260115132248_qNvXY AU001P 2026-01-17T14:05:23.715Z 2026-01-24T15:08:51.525Z
9206732 9206732 20260114183850_nf2da AU001P 2026-01-16T14:05:19.834Z 2026-01-22T15:02:34.943Z
9206474 9206474 20260114170545_2URyM AU001P 2026-01-16T14:04:05.479Z 2026-01-22T15:02:27.066Z
9206461 9206461 20260114165821_637bk AU001P 2026-01-16T14:04:01.292Z 2026-01-22T15:02:26.486Z
9206434 9206434 20260114164746_2NoNg AU001P 2026-01-16T14:03:53.308Z 2026-01-22T15:02:25.637Z
9206346 9206346 20260114161230_vZn6i AU001P 2026-01-16T14:03:26.529Z 2026-01-22T15:02:10.843Z
9206319 9206319 20260114154401_qAEQu AU001P 2026-01-16T14:03:17.572Z 2026-01-22T15:02:02.751Z
9206261 9206261 20260114150618_d47nL AU001P 2026-01-16T14:02:59.341Z 2026-01-22T15:01:57.065Z
9206145 9206145 20260114134207_Az0Ul AU001P 2026-01-16T14:02:23.199Z 2026-01-22T15:01:50.826Z
9206144 9206144 20260114134207_5h5Oe AU001P 2026-01-16T14:02:22.326Z 2026-01-22T15:01:50.740Z
9199087 9199087 20260113190133_eoCJs AU001P 2026-01-15T14:09:10.699Z 2026-01-22T15:07:13.716Z
9198705 9198705 20260113173956_5udQ2 AU001P 2026-01-15T14:06:33.346Z 2026-01-22T15:07:01.253Z
9198400 9198400 20260113161030_aVP0A AU001P 2026-01-15T14:04:02.670Z 2026-01-22T15:06:26.111Z
9179988 9179988 20260110183409_ItKUS AU001P 2026-01-12T14:05:15.522Z 2026-01-19T15:15:39.847Z
9179816 9179816 20260110174656_bbpJY AU001P 2026-01-12T14:04:27.886Z 2026-01-19T15:15:18.831Z
9179797 9179797 20260110174435_nG1yr AU001P 2026-01-12T14:04:21.722Z 2026-01-19T15:15:16.512Z
9125847 9125847 20251231190306_y3Z13 AU001P 2026-01-02T14:56:15.415Z 2026-01-08T15:16:10.993Z
9125771 9125771 20251231184535_c72GG AU001P 2026-01-02T14:56:03.606Z 2026-01-08T15:15:58.187Z
9125766 9125766 20251231184535_OVVM5 AU001P 2026-01-02T14:56:03.421Z 2026-01-08T15:15:57.876Z
9125575 9125575 20251231182200_3xULx AU001P 2026-01-02T14:55:33.597Z 2026-01-08T15:15:47.584Z
9125573 9125573 20251231182200_MXEzA AU001P 2026-01-02T14:55:33.226Z 2026-01-08T15:15:47.428Z
9120728 9120728 20251231192715_Xhi9a AU001P 2026-01-02T14:03:56.727Z 2026-01-09T14:51:21.039Z
9120561 9120561 20251231190638_VqLxH AU001P 2026-01-02T14:03:06.042Z 2026-01-09T14:51:14.014Z
9120553 9120553 20251231190532_aYqGB AU001P 2026-01-02T14:03:02.586Z 2026-01-09T14:51:13.677Z
9120550 9120550 20251231190532_bI5XA AU001P 2026-01-02T14:03:01.552Z 2026-01-09T14:51:13.576Z
9109395 9109395 20251226194332_3IR5C AU001P 2025-12-31T15:32:08.319Z 2026-01-03T15:43:30.084Z
9109380 9109380 20251226191913_Z4r2L AU001P 2025-12-31T15:31:57.701Z 2026-01-03T15:43:20.490Z
9109301 9109301 20251227192659_qd2m5 AU001P 2025-12-31T15:20:24.448Z 2026-01-04T15:35:07.594Z
9109290 9109290 20251227184202_DrW3T AU001P 2025-12-31T15:19:53.902Z 2026-01-04T15:34:53.324Z
9109279 9109279 20251227183029_7KvbI AU001P 2025-12-31T15:19:47.320Z 2026-01-04T15:34:50.070Z
9099799 9099799 20251225185838_3vwcH AU001P 2025-12-30T15:36:06.761Z 2026-01-02T15:48:04.774Z
9099786 9099786 20251225185218_f3d6X AU001P 2025-12-30T15:36:05.113Z 2026-01-02T15:48:01.565Z
9098278 9098278 20251227184202_sl6Fs AU001P 2025-12-30T15:10:03.122Z 2026-01-04T15:34:53.237Z
9097582 9097582 20251227170100_AaNm4 AU001P 2025-12-30T15:09:05.014Z 2026-01-04T15:34:13.704Z
9075881 9075881 20251222194559_0cC1P AU001P 2025-12-29T15:21:30.973Z 2025-12-30T15:49:12.904Z
9075834 9075834 20251223194653_tVeUq AU001P 2025-12-29T15:12:22.348Z 2025-12-31T15:43:46.261Z
9075828 9075828 20251223193111_0AbPJ AU001P 2025-12-29T15:12:20.640Z 2025-12-31T15:43:44.365Z
9075824 9075824 20251223192503_cwkBq AU001P 2025-12-29T15:12:19.441Z 2025-12-31T15:43:43.887Z
9073951 9073951 20251225185218_Ol1w2 AU001P 2025-12-29T14:59:59.726Z 2026-01-02T15:48:01.492Z
9071927 9071927 20251226195353_S2uj3 AU001P 2025-12-29T14:50:14.790Z 2026-01-03T15:43:33.121Z
9071719 9071719 20251226191913_TYVFR AU001P 2025-12-29T14:49:45.293Z 2026-01-03T15:43:20.582Z
9049829 9049829 20251219190538_xxL8L AU001P 2025-12-28T15:22:05.574Z 2025-12-28T15:22:05.574Z
9049814 9049814 20251219175038_JQXHx AU001P 2025-12-28T15:21:57.014Z 2025-12-28T15:21:57.014Z
9049749 9049749 20251220191745_vc7xP AU001P 2025-12-28T15:14:54.138Z 2025-12-29T15:26:16.268Z
9048594 9048594 20251222172507_HillN AU001P 2025-12-28T15:03:05.326Z 2025-12-30T15:49:03.057Z
9047665 9047665 20251223193902_1A1ik AU001P 2025-12-28T14:56:43.465Z 2025-12-31T15:43:45.841Z
9047636 9047636 20251223193111_5txCZ AU001P 2025-12-28T14:56:42.203Z 2025-12-31T15:43:44.504Z
9047584 9047584 20251223192503_IKxt8 AU001P 2025-12-28T14:56:40.480Z 2025-12-31T15:43:43.842Z

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