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 = "NZ0012" 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
9627385 9627385 20260408172311_Wj3La NZ0012 2026-04-09T12:10:47.250Z 2026-04-10T12:14:22.534Z
9626738 9626738 20260408150014_WZNrd NZ0012 2026-04-09T12:09:06.814Z 2026-04-10T12:14:22.406Z
9626535 9626535 20260408141235_3oImB NZ0012 2026-04-09T12:08:38.950Z 2026-04-10T12:14:22.370Z
9626485 9626485 20260408140549_1mtvZ NZ0012 2026-04-09T12:08:26.365Z 2026-04-10T12:14:22.360Z
9626446 9626446 20260408140410_nN9qX NZ0012 2026-04-09T12:08:22.383Z 2026-04-10T12:14:22.355Z
9626374 9626374 20260408134841_33sqP NZ0012 2026-04-09T12:08:13.668Z 2026-04-10T12:14:22.341Z
9626206 9626206 20260408132542_CYDpU NZ0012 2026-04-09T12:07:46.439Z 2026-04-10T12:14:22.318Z
9626178 9626178 20260408132247_nVUHv NZ0012 2026-04-09T12:07:44.310Z 2026-04-10T12:14:22.314Z
9605340 9605340 20260403085104_xr2Uf NZ0012 2026-04-04T12:01:51.488Z 2026-04-10T12:31:33.876Z
9605302 9605302 20260403083454_gBA3Y NZ0012 2026-04-04T12:01:41.539Z 2026-04-10T12:31:33.150Z
9605285 9605285 20260403082522_P1XYN NZ0012 2026-04-04T12:01:37.582Z 2026-04-10T12:31:32.782Z
9605228 9605228 20260403080544_mTTA3 NZ0012 2026-04-04T12:01:19.757Z 2026-04-10T12:31:31.343Z
9604367 9604367 20260402172550_kfW57 NZ0012 2026-04-03T12:07:05.445Z 2026-04-10T12:34:49.166Z
9604229 9604229 20260402164317_WrG33 NZ0012 2026-04-03T12:06:27.862Z 2026-04-10T12:34:45.706Z
9604208 9604208 20260402163328_ODGrx NZ0012 2026-04-03T12:06:23.210Z 2026-04-10T12:34:45.260Z
9604199 9604199 20260402163119_08ROC NZ0012 2026-04-03T12:06:21.455Z 2026-04-10T12:34:45.077Z
9604155 9604155 20260402161432_SzV9o NZ0012 2026-04-03T12:06:13.187Z 2026-04-10T12:34:43.842Z
9604152 9604152 20260402161139_uwsW0 NZ0012 2026-04-03T12:06:12.738Z 2026-04-10T12:34:43.785Z
9604119 9604119 20260402155831_cGN3v NZ0012 2026-04-03T12:06:01.587Z 2026-04-10T12:34:42.744Z
9604113 9604113 20260402155656_LlJdv NZ0012 2026-04-03T12:05:59.885Z 2026-04-10T12:34:42.549Z
9602004 9602004 20260401174738_kDvv8 NZ0012 2026-04-02T12:04:29.568Z 2026-04-10T12:35:51.632Z
9601718 9601718 20260401164001_tUF7l NZ0012 2026-04-02T12:03:31.154Z 2026-04-10T12:35:46.274Z
9601595 9601595 20260401160001_IBxWf NZ0012 2026-04-02T12:03:13.482Z 2026-04-10T12:35:41.885Z
9601585 9601585 20260401155815_U2sW2 NZ0012 2026-04-02T12:03:12.559Z 2026-04-10T12:35:41.801Z
9601582 9601582 20260401155635_n0KsN NZ0012 2026-04-02T12:03:12.077Z 2026-04-10T12:35:41.742Z
9601547 9601547 20260401154414_3SMh2 NZ0012 2026-04-02T12:03:04.407Z 2026-04-10T12:35:41.020Z
9601443 9601443 20260401152127_7wtW9 NZ0012 2026-04-02T12:02:48.638Z 2026-04-10T12:35:39.114Z
9601421 9601421 20260401151437_MY4ky NZ0012 2026-04-02T12:02:45.224Z 2026-04-10T12:35:38.803Z
9601372 9601372 20260401145543_KJpPR NZ0012 2026-04-02T12:02:35.448Z 2026-04-10T12:35:37.994Z
9601345 9601345 20260401143503_acDi6 NZ0012 2026-04-02T12:02:29.532Z 2026-04-10T12:35:37.369Z
9600878 9600878 20260401073535_b3z3I NZ0012 2026-04-02T12:00:47.344Z 2026-04-10T12:35:28.395Z
9599927 9599927 20260331172955_0k98m NZ0012 2026-04-01T12:05:19.922Z 2026-04-09T12:48:02.613Z
9599877 9599877 20260331171223_MSqmL NZ0012 2026-04-01T12:05:08.029Z 2026-04-09T12:47:58.404Z
9599869 9599869 20260331171040_2chwB NZ0012 2026-04-01T12:05:06.592Z 2026-04-09T12:47:56.360Z
9599863 9599863 20260331170945_iqJd1 NZ0012 2026-04-01T12:05:05.845Z 2026-04-09T12:47:53.862Z
9599792 9599792 20260331165044_FtBUk NZ0012 2026-04-01T12:04:51.298Z 2026-04-09T12:47:32.192Z
9599777 9599777 20260331164704_AR5xa NZ0012 2026-04-01T12:04:48.632Z 2026-04-09T12:47:30.282Z
9599747 9599747 20260331163601_2UM8Y NZ0012 2026-04-01T12:04:42.136Z 2026-04-09T12:47:23.079Z
9599691 9599691 20260331162425_uIf6U NZ0012 2026-04-01T12:04:32.015Z 2026-04-09T12:47:15.483Z
9599680 9599680 20260331162005_tGAuB NZ0012 2026-04-01T12:04:28.698Z 2026-04-09T12:47:14.515Z
9599641 9599641 20260331160942_IeWz5 NZ0012 2026-04-01T12:04:20.393Z 2026-04-09T12:47:08.224Z
9599598 9599598 20260331155918_0JxY3 NZ0012 2026-04-01T12:04:12.644Z 2026-04-09T12:47:04.361Z
9599561 9599561 20260331154537_G9HWu NZ0012 2026-04-01T12:04:03.559Z 2026-04-09T12:46:58.350Z
9599486 9599486 20260331145944_6Vxwi NZ0012 2026-04-01T12:03:46.828Z 2026-04-09T12:46:48.859Z
9596935 9596935 20260330144013_Zs7d8 NZ0012 2026-03-31T12:05:19.625Z 2026-04-08T12:43:28.521Z
9596930 9596930 20260330143806_RgRCj NZ0012 2026-03-31T12:05:17.247Z 2026-04-08T12:43:28.379Z
9596865 9596865 20260330141922_fZRbP NZ0012 2026-03-31T12:05:07.118Z 2026-04-08T12:43:26.586Z
9595760 9595760 20260330083057_nMvqt NZ0012 2026-03-31T12:02:25.581Z 2026-04-08T12:42:31.451Z
9595743 9595743 20260330082019_aFB1S NZ0012 2026-03-31T12:02:21.886Z 2026-04-08T12:42:31.116Z
9593972 9593972 20260329171404_NH1EO NZ0012 2026-03-30T12:05:41.109Z 2026-04-07T12:27:41.386Z
9593847 9593847 20260329161342_JVxJB NZ0012 2026-03-30T12:05:16.458Z 2026-04-07T12:27:37.815Z
9593818 9593818 20260329154810_qEJMi NZ0012 2026-03-30T12:05:11.987Z 2026-04-07T12:27:36.814Z
9593777 9593777 20260329151512_DHyRk NZ0012 2026-03-30T12:05:05.226Z 2026-04-07T12:27:35.634Z
9593742 9593742 20260329144113_zGCWo NZ0012 2026-03-30T12:04:59.901Z 2026-04-07T12:27:34.616Z
9593646 9593646 20260329125644_Vdke6 NZ0012 2026-03-30T12:04:38.906Z 2026-04-07T12:27:16.531Z
9591087 9591087 20260328131255_gMsJn NZ0012 2026-03-29T12:03:49.168Z 2026-04-06T12:38:59.778Z
9591080 9591080 20260328130906_jfewM NZ0012 2026-03-29T12:03:48.441Z 2026-04-06T12:38:59.427Z
9591075 9591075 20260328130842_OfBvh NZ0012 2026-03-29T12:03:48.195Z 2026-04-06T12:38:59.200Z
9587985 9587985 20260327171132_D11hs NZ0012 2026-03-28T12:06:52.135Z 2026-04-05T12:35:02.790Z
9587941 9587941 20260327165715_txHlc NZ0012 2026-03-28T12:06:46.152Z 2026-04-05T12:35:00.612Z
9587908 9587908 20260327164854_cyQ15 NZ0012 2026-03-28T12:06:41.913Z 2026-04-05T12:34:57.923Z
9587902 9587902 20260327164542_u2oZs NZ0012 2026-03-28T12:06:41.249Z 2026-04-05T12:34:48.915Z
9587881 9587881 20260327163711_GRg7b NZ0012 2026-03-28T12:06:38.869Z 2026-04-05T12:34:48.024Z
9583523 9583523 20260326154703_XUOh6 NZ0012 2026-03-27T12:09:03.390Z 2026-04-04T12:41:22.685Z
9574921 9574921 20260323173837_F04B2 NZ0012 2026-03-25T12:19:52.619Z 2026-03-31T12:28:44.329Z
9569220 9569220 20260322141513_xst8P NZ0012 2026-03-24T12:20:13.325Z 2026-03-30T12:29:39.683Z
9568664 9568664 20260323171007_0yVLb NZ0012 2026-03-24T12:15:29.002Z 2026-03-31T12:28:39.975Z
9568508 9568508 20260323165113_LF3b2 NZ0012 2026-03-24T12:15:12.862Z 2026-03-31T12:28:30.121Z
9568475 9568475 20260323164735_3M3If NZ0012 2026-03-24T12:15:10.349Z 2026-03-31T12:28:29.733Z
9568390 9568390 20260323163959_YljFT NZ0012 2026-03-24T12:15:03.114Z 2026-03-31T12:28:28.637Z
9568287 9568287 20260323162727_w7mdI NZ0012 2026-03-24T12:14:50.402Z 2026-03-31T12:28:26.891Z
9568278 9568278 20260323162645_BTAyW NZ0012 2026-03-24T12:14:50.039Z 2026-03-31T12:28:26.839Z
9568129 9568129 20260323161604_xztOJ NZ0012 2026-03-24T12:14:36.622Z 2026-03-31T12:28:23.426Z
9559510 9559510 20260321173706_tdVfK NZ0012 2026-03-23T12:11:08.542Z 2026-03-29T12:20:40.140Z
9559485 9559485 20260321172816_WCNB9 NZ0012 2026-03-23T12:11:07.619Z 2026-03-29T12:20:39.907Z
9559447 9559447 20260321172008_S5U63 NZ0012 2026-03-23T12:11:06.248Z 2026-03-29T12:20:39.355Z
9559435 9559435 20260321171724_yohEd NZ0012 2026-03-23T12:11:05.785Z 2026-03-29T12:20:39.179Z
9559411 9559411 20260321171406_Lq4Cm NZ0012 2026-03-23T12:11:05.123Z 2026-03-29T12:20:38.891Z
9559280 9559280 20260321165250_zXj2d NZ0012 2026-03-23T12:11:00.754Z 2026-03-29T12:20:36.233Z
9559272 9559272 20260321165238_FnNqe NZ0012 2026-03-23T12:11:00.441Z 2026-03-29T12:20:36.132Z
9559174 9559174 20260321164317_Jpxl8 NZ0012 2026-03-23T12:10:56.568Z 2026-03-29T12:20:34.923Z
9559161 9559161 20260321164144_2Jb53 NZ0012 2026-03-23T12:10:56.224Z 2026-03-29T12:20:34.794Z
9559142 9559142 20260321164029_f2tpY NZ0012 2026-03-23T12:10:55.559Z 2026-03-29T12:20:34.520Z
9559137 9559137 20260321164003_VNKRQ NZ0012 2026-03-23T12:10:55.309Z 2026-03-29T12:20:34.453Z
9559051 9559051 20260321162354_p3rf9 NZ0012 2026-03-23T12:10:52.581Z 2026-03-29T12:20:33.510Z
9558945 9558945 20260321160851_CHfDD NZ0012 2026-03-23T12:10:41.294Z 2026-03-29T12:20:32.231Z
9558900 9558900 20260321160322_mHxOV NZ0012 2026-03-23T12:10:39.149Z 2026-03-29T12:20:31.530Z
9558833 9558833 20260321155126_jFs1W NZ0012 2026-03-23T12:10:36.157Z 2026-03-29T12:20:30.603Z
9558698 9558698 20260322172936_nYJlE NZ0012 2026-03-23T12:06:56.103Z 2026-03-30T12:30:20.557Z
9558694 9558694 20260322172935_E7s30 NZ0012 2026-03-23T12:06:55.903Z 2026-03-30T12:30:20.522Z
9558614 9558614 20260322170946_l32ks NZ0012 2026-03-23T12:06:51.346Z 2026-03-30T12:30:18.011Z
9558222 9558222 20260322161024_7sr5Y NZ0012 2026-03-23T12:06:33.614Z 2026-03-30T12:30:08.542Z
9558218 9558218 20260322161023_6w5TJ NZ0012 2026-03-23T12:06:30.147Z 2026-03-30T12:30:08.396Z
9558214 9558214 20260322160945_tEixW NZ0012 2026-03-23T12:06:29.927Z 2026-03-30T12:30:08.233Z
9558210 9558210 20260322160945_AQAty NZ0012 2026-03-23T12:06:29.836Z 2026-03-30T12:30:08.156Z
9558183 9558183 20260322160311_2aq7N NZ0012 2026-03-23T12:06:28.725Z 2026-03-30T12:30:07.185Z
9558121 9558121 20260322155211_D59Q0 NZ0012 2026-03-23T12:06:26.190Z 2026-03-30T12:30:05.174Z
9558073 9558073 20260322154104_PYXTx NZ0012 2026-03-23T12:06:22.455Z 2026-03-30T12:30:03.530Z
9558057 9558057 20260322153802_897t9 NZ0012 2026-03-23T12:06:21.562Z 2026-03-30T12:30:02.762Z
9558049 9558049 20260322153755_IA8iV NZ0012 2026-03-23T12:06:21.236Z 2026-03-30T12:30:02.676Z

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