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 = "NZ001P" 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
9270316 9270316 20260128153109_fXf0U NZ001P 2026-01-29T14:11:44.932Z 2026-01-29T14:11:44.932Z
9270274 9270274 20260128152315_DVU0W NZ001P 2026-01-29T14:11:30.475Z 2026-01-29T14:11:30.475Z
9270216 9270216 20260128151739_bP5XR NZ001P 2026-01-29T14:11:20.455Z 2026-01-29T14:11:20.455Z
9270111 9270111 20260128145749_7U0VU NZ001P 2026-01-29T14:10:55.223Z 2026-01-29T14:10:55.223Z
9270071 9270071 20260128145132_P63LH NZ001P 2026-01-29T14:10:46.896Z 2026-01-29T14:10:46.896Z
9269814 9269814 20260128141730_5x3RH NZ001P 2026-01-29T14:09:44.068Z 2026-01-29T14:09:44.068Z
9269324 9269324 20260128130216_Fn1s4 NZ001P 2026-01-29T14:07:28.166Z 2026-01-29T14:07:28.166Z
9268934 9268934 20260128114537_9D5ZY NZ001P 2026-01-29T14:05:37.952Z 2026-01-29T14:05:37.952Z
9197527 9197527 20260113112827_Z8ud1 NZ001P 2026-01-14T14:23:19.481Z 2026-01-21T15:06:19.659Z
9191635 9191635 20260112112711_Qs87c NZ001P 2026-01-13T14:25:56.838Z 2026-01-20T15:25:41.436Z
9191374 9191374 20260112110141_7YNF1 NZ001P 2026-01-13T14:25:11.880Z 2026-01-20T15:25:22.560Z
9190841 9190841 20260112100433_GydPb NZ001P 2026-01-13T14:23:36.594Z 2026-01-20T15:24:51.471Z
9190834 9190834 20260112100401_JBVig NZ001P 2026-01-13T14:23:35.638Z 2026-01-20T15:24:51.220Z
9190711 9190711 20260112094537_7GzFh NZ001P 2026-01-13T14:23:11.591Z 2026-01-20T15:24:44.906Z
9190589 9190589 20260112092622_3aXD0 NZ001P 2026-01-13T14:22:49.428Z 2026-01-20T15:24:40.095Z
9190476 9190476 20260112091114_QvvC7 NZ001P 2026-01-13T14:22:23.083Z 2026-01-20T15:24:34.940Z
9190456 9190456 20260112090639_0XbRk NZ001P 2026-01-13T14:22:17.165Z 2026-01-20T15:24:34.036Z
9185487 9185487 20260111112145_t4XCY NZ001P 2026-01-12T14:25:03.634Z 2026-01-19T15:20:55.361Z
9185208 9185208 20260111132702_Q5Q8U NZ001P 2026-01-12T14:22:45.355Z 2026-01-19T15:21:57.789Z
9185171 9185171 20260111131916_sJgys NZ001P 2026-01-12T14:22:38.209Z 2026-01-19T15:21:54.323Z
9184858 9184858 20260111122900_YXGfJ NZ001P 2026-01-12T14:21:46.782Z 2026-01-19T15:21:18.916Z
9184748 9184748 20260111121546_KXYrW NZ001P 2026-01-12T14:21:30.942Z 2026-01-19T15:21:11.793Z
9184616 9184616 20260111115823_WrWl2 NZ001P 2026-01-12T14:21:08.708Z 2026-01-19T15:21:05.816Z
9184525 9184525 20260111114717_1wYWv NZ001P 2026-01-12T14:20:51.154Z 2026-01-19T15:21:02.497Z
9184334 9184334 20260111111409_C42Ps NZ001P 2026-01-12T14:20:17.399Z 2026-01-19T15:20:33.954Z
9184158 9184158 20260111105018_Aozyd NZ001P 2026-01-12T14:19:49.031Z 2026-01-19T15:20:25.472Z
9184116 9184116 20260111104615_vrDTV NZ001P 2026-01-12T14:19:43.517Z 2026-01-19T15:20:23.530Z
9183939 9183939 20260111102852_bxo2s NZ001P 2026-01-12T14:19:14.845Z 2026-01-19T15:20:17.080Z
9183864 9183864 20260111102338_iOCax NZ001P 2026-01-12T14:19:04.131Z 2026-01-19T15:20:15.057Z
9183681 9183681 20260111095905_8sv76 NZ001P 2026-01-12T14:18:30.810Z 2026-01-19T15:20:08.237Z
9183640 9183640 20260111095533_2gLHT NZ001P 2026-01-12T14:18:23.818Z 2026-01-19T15:19:48.913Z
9183544 9183544 20260111094147_pV2jO NZ001P 2026-01-12T14:18:05.464Z 2026-01-19T15:19:45.321Z
9183451 9183451 20260111093140_KuiC8 NZ001P 2026-01-12T14:17:50.833Z 2026-01-19T15:19:40.324Z
9183407 9183407 20260111092644_CESlx NZ001P 2026-01-12T14:17:43.743Z 2026-01-19T15:19:38.308Z
9183378 9183378 20260111092349_WZw7K NZ001P 2026-01-12T14:17:36.846Z 2026-01-19T15:19:37.548Z
9183286 9183286 20260111090950_XldUe NZ001P 2026-01-12T14:17:22.051Z 2026-01-12T14:17:22.051Z
9179337 9179337 20260110144052_My2E2 NZ001P 2026-01-12T14:01:14.594Z 2026-01-19T15:14:08.342Z
9179321 9179321 20260111155125_61G0u NZ001P 2026-01-12T14:01:08.964Z 2026-01-20T15:20:11.053Z
9178932 9178932 20260110143000_3TBuz NZ001P 2026-01-11T14:16:05.864Z 2026-01-18T15:11:25.111Z
9178918 9178918 20260110142821_uta8l NZ001P 2026-01-11T14:16:04.291Z 2026-01-18T15:11:24.564Z
9178916 9178916 20260110142745_5VwGq NZ001P 2026-01-11T14:16:03.766Z 2026-01-18T15:11:24.422Z
9178647 9178647 20260110133728_PvX28 NZ001P 2026-01-11T14:15:24.635Z 2026-01-18T15:11:09.816Z
9178616 9178616 20260110133421_T4uSM NZ001P 2026-01-11T14:15:20.453Z 2026-01-18T15:11:08.649Z
9178600 9178600 20260110133214_pKyO9 NZ001P 2026-01-11T14:15:17.931Z 2026-01-18T15:11:08.057Z
9178356 9178356 20260110125627_m03KU NZ001P 2026-01-11T14:14:41.035Z 2026-01-18T15:10:46.367Z
9177344 9177344 20260110092542_BDVKB NZ001P 2026-01-11T14:11:41.629Z 2026-01-18T15:09:38.477Z
9174121 9174121 20260110153500_6fAK0 NZ001P 2026-01-11T14:01:27.717Z 2026-01-19T15:14:36.359Z
9174109 9174109 20260110153431_4kq99 NZ001P 2026-01-11T14:01:26.034Z 2026-01-19T15:14:36.134Z
9174100 9174100 20260110153211_5J8qk NZ001P 2026-01-11T14:01:24.193Z 2026-01-19T15:14:35.856Z
9174051 9174051 20260110152316_upDw2 NZ001P 2026-01-11T14:01:10.119Z 2026-01-19T15:14:33.243Z
9173691 9173691 20260109141845_XWZJo NZ001P 2026-01-10T14:19:05.407Z 2026-01-17T15:26:44.322Z
9173686 9173686 20260109135257_RCuA6 NZ001P 2026-01-10T14:19:02.564Z 2026-01-17T15:26:41.111Z
9173666 9173666 20260109130648_JSzPC NZ001P 2026-01-10T14:18:42.467Z 2026-01-17T15:26:20.459Z
9173570 9173570 20260109145324_mJ3XQ NZ001P 2026-01-10T14:18:06.086Z 2026-01-17T15:26:52.005Z
9173533 9173533 20260109143814_NSh1R NZ001P 2026-01-10T14:17:54.687Z 2026-01-17T15:26:47.082Z
9173419 9173419 20260109140633_2O4Kt NZ001P 2026-01-10T14:17:28.291Z 2026-01-17T15:26:42.659Z
9173400 9173400 20260109140223_kCQOf NZ001P 2026-01-10T14:17:25.389Z 2026-01-17T15:26:42.098Z
9173372 9173372 20260109135257_634MI NZ001P 2026-01-10T14:17:20.453Z 2026-01-10T14:17:20.453Z
9173361 9173361 20260109135201_Xvf0Z NZ001P 2026-01-10T14:17:16.571Z 2026-01-17T15:26:40.876Z
9173265 9173265 20260109132906_5eTYf NZ001P 2026-01-10T14:16:54.968Z 2026-01-17T15:26:34.934Z
9173243 9173243 20260109132627_BYatJ NZ001P 2026-01-10T14:16:50.965Z 2026-01-17T15:26:24.486Z
9173237 9173237 20260109132608_QenMM NZ001P 2026-01-10T14:16:49.765Z 2026-01-17T15:26:24.275Z
9173217 9173217 20260109132406_jBJSo NZ001P 2026-01-10T14:16:45.507Z 2026-01-17T15:26:23.820Z
9173194 9173194 20260109132132_XnZVs NZ001P 2026-01-10T14:16:39.946Z 2026-01-17T15:26:22.999Z
9173114 9173114 20260109130135_JdaWY NZ001P 2026-01-10T14:16:13.950Z 2026-01-17T15:26:16.989Z
9173021 9173021 20260109124459_5ZqGX NZ001P 2026-01-10T14:15:53.660Z 2026-01-17T15:26:12.185Z
9172999 9172999 20260109124142_XmTeg NZ001P 2026-01-10T14:15:48.485Z 2026-01-17T15:26:11.257Z
9172976 9172976 20260109123940_dkAG5 NZ001P 2026-01-10T14:15:44.383Z 2026-01-17T15:26:10.662Z
9172916 9172916 20260109122654_sAweE NZ001P 2026-01-10T14:15:24.894Z 2026-01-17T15:26:07.611Z
9172883 9172883 20260109122244_n310b NZ001P 2026-01-10T14:15:15.328Z 2026-01-17T15:26:06.513Z
9172710 9172710 20260109113658_z1o0k NZ001P 2026-01-10T14:14:34.197Z 2026-01-17T15:25:48.302Z
9172448 9172448 20260109104345_AdxbW NZ001P 2026-01-10T14:13:24.998Z 2026-01-17T15:25:34.433Z
9172446 9172446 20260109104318_FS0lq NZ001P 2026-01-10T14:13:24.032Z 2026-01-17T15:25:34.247Z
9172396 9172396 20260109103210_mGlBX NZ001P 2026-01-10T14:13:08.818Z 2026-01-17T15:25:24.745Z
9172390 9172390 20260109103156_1hkG2 NZ001P 2026-01-10T14:13:06.527Z 2026-01-17T15:25:24.588Z
9172386 9172386 20260109103147_RHfh5 NZ001P 2026-01-10T14:13:05.379Z 2026-01-17T15:25:24.452Z
9172383 9172383 20260109102708_gAlpn NZ001P 2026-01-10T14:13:04.752Z 2026-01-17T15:25:24.257Z
9172281 9172281 20260109094924_GBoFL NZ001P 2026-01-10T14:12:35.485Z 2026-01-17T15:25:16.606Z
9172246 9172246 20260109093831_FKzyO NZ001P 2026-01-10T14:12:23.757Z 2026-01-17T15:25:13.677Z
9170592 9170592 20260109155237_tuTAY NZ001P 2026-01-10T14:01:33.991Z 2026-01-18T15:06:38.459Z
9170507 9170507 20260109153525_1etAr NZ001P 2026-01-10T14:00:58.397Z 2026-01-18T15:06:25.757Z
9170466 9170466 20260109152910_U01iN NZ001P 2026-01-10T14:00:44.698Z 2026-01-18T15:06:23.621Z
9170460 9170460 20260109152854_6ctbT NZ001P 2026-01-10T14:00:42.373Z 2026-01-18T15:06:22.783Z
9170425 9170425 20260109151352_QGd2E NZ001P 2026-01-10T14:00:28.703Z 2026-01-18T15:06:20.661Z
9169810 9169810 20260108105846_95Kwr NZ001P 2026-01-09T14:14:41.624Z 2026-01-16T15:12:34.993Z
9169800 9169800 20260108104212_tEXyV NZ001P 2026-01-09T14:14:39.283Z 2026-01-16T15:12:31.433Z
9169715 9169715 20260108090418_9RG3j NZ001P 2026-01-09T14:14:28.582Z 2026-01-16T15:12:04.691Z
9169326 9169326 20260108141232_gd0Lq NZ001P 2026-01-09T14:13:17.388Z 2026-01-16T15:13:52.352Z
9168823 9168823 20260108122458_IW1el NZ001P 2026-01-09T14:12:05.629Z 2026-01-16T15:13:10.449Z
9168782 9168782 20260108121431_yPUAN NZ001P 2026-01-09T14:12:00.476Z 2026-01-16T15:13:04.256Z
9168757 9168757 20260108120931_PRGE3 NZ001P 2026-01-09T14:11:57.319Z 2026-01-16T15:13:02.466Z
9168686 9168686 20260108120036_h9f3j NZ001P 2026-01-09T14:11:46.018Z 2026-01-16T15:12:58.284Z
9168631 9168631 20260108114106_pgq5I NZ001P 2026-01-09T14:11:37.366Z 2026-01-16T15:12:54.966Z
9168360 9168360 20260108104859_Tusfk NZ001P 2026-01-09T14:10:57.550Z 2026-01-16T15:12:32.566Z
9168316 9168316 20260108103550_7ZaLF NZ001P 2026-01-09T14:10:51.172Z 2026-01-16T15:12:28.948Z
9168286 9168286 20260108103037_OGAns NZ001P 2026-01-09T14:10:46.284Z 2026-01-16T15:12:27.910Z
9168276 9168276 20260108102857_sK2gW NZ001P 2026-01-09T14:10:45.347Z 2026-01-16T15:12:27.568Z
9167997 9167997 20260108091711_V1O83 NZ001P 2026-01-09T14:10:03.457Z 2026-01-16T15:12:05.591Z
9167991 9167991 20260108091606_YF11R NZ001P 2026-01-09T14:10:03.066Z 2026-01-16T15:12:05.379Z
9167937 9167937 20260108085308_BXMoq NZ001P 2026-01-09T14:09:55.002Z 2026-01-16T15:12:03.154Z

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