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 = "NZ0001" 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
9270637 9270637 20260128161707_sHGIm NZ0001 2026-01-29T14:13:09.823Z 2026-01-29T14:13:09.823Z
9270598 9270598 20260128160950_Hga2n NZ0001 2026-01-29T14:12:55.130Z 2026-01-29T14:12:55.130Z
9270390 9270390 20260128154217_dUeiz NZ0001 2026-01-29T14:12:01.086Z 2026-01-29T14:12:01.086Z
9270280 9270280 20260128152522_JYtQh NZ0001 2026-01-29T14:11:31.811Z 2026-01-29T14:11:31.811Z
9270158 9270158 20260128150315_SMUHs NZ0001 2026-01-29T14:11:08.512Z 2026-01-29T14:11:08.512Z
9270008 9270008 20260128144331_ymSjB NZ0001 2026-01-29T14:10:37.584Z 2026-01-29T14:10:37.584Z
9269916 9269916 20260128143155_To1tp NZ0001 2026-01-29T14:10:13.410Z 2026-01-29T14:10:13.410Z
9269725 9269725 20260128140038_8YoBF NZ0001 2026-01-29T14:09:19.223Z 2026-01-29T14:09:19.223Z
9269402 9269402 20260128131250_AgQrJ NZ0001 2026-01-29T14:07:51.772Z 2026-01-29T14:07:51.772Z
9269045 9269045 20260128121200_WnqTl NZ0001 2026-01-29T14:06:09.310Z 2026-01-29T14:06:09.310Z
9269029 9269029 20260128120643_6SwqW NZ0001 2026-01-29T14:06:05.786Z 2026-01-29T14:06:05.786Z
9269022 9269022 20260128120213_a6kvN NZ0001 2026-01-29T14:06:03.481Z 2026-01-29T14:06:03.481Z
9268880 9268880 20260128113810_egFM2 NZ0001 2026-01-29T14:05:18.152Z 2026-01-29T14:05:18.152Z
9268852 9268852 20260128113359_X6gIy NZ0001 2026-01-29T14:05:11.906Z 2026-01-29T14:05:11.906Z
9268845 9268845 20260128113253_5IbFw NZ0001 2026-01-29T14:05:10.019Z 2026-01-29T14:05:10.019Z
9268787 9268787 20260128112243_UrcPx NZ0001 2026-01-29T14:04:52.989Z 2026-01-29T14:04:52.989Z
9268782 9268782 20260128111810_bXUCZ NZ0001 2026-01-29T14:04:51.254Z 2026-01-29T14:04:51.254Z
9268766 9268766 20260128111751_hK7ff NZ0001 2026-01-29T14:04:49.026Z 2026-01-29T14:04:49.026Z
9268508 9268508 20260128103857_HieNU NZ0001 2026-01-29T14:03:26.716Z 2026-01-29T14:03:26.716Z
9268503 9268503 20260128103856_cL5qi NZ0001 2026-01-29T14:03:26.017Z 2026-01-29T14:03:26.017Z
9268308 9268308 20260128094719_7vwpP NZ0001 2026-01-29T14:02:18.915Z 2026-01-29T14:02:18.915Z
9268244 9268244 20260128093043_YyQ5O NZ0001 2026-01-29T14:01:57.929Z 2026-01-29T14:01:57.929Z
9265678 9265678 20260127154836_2LH4L NZ0001 2026-01-28T14:10:57.620Z 2026-01-29T14:30:24.653Z
9265667 9265667 20260127154621_aOqpg NZ0001 2026-01-28T14:10:55.202Z 2026-01-29T14:30:24.650Z
9265623 9265623 20260127154229_ZdqAf NZ0001 2026-01-28T14:10:45.947Z 2026-01-29T14:30:24.634Z
9265400 9265400 20260127151217_9b3Oa NZ0001 2026-01-28T14:10:03.048Z 2026-01-29T14:30:24.541Z
9265388 9265388 20260127151115_4phIA NZ0001 2026-01-28T14:10:01.607Z 2026-01-29T14:30:24.539Z
9265288 9265288 20260127145740_9Ea2q NZ0001 2026-01-28T14:09:45.326Z 2026-01-29T14:30:24.521Z
9265254 9265254 20260127145030_t6RYX NZ0001 2026-01-28T14:09:40.739Z 2026-01-29T14:30:24.516Z
9265213 9265213 20260127143954_nd98q NZ0001 2026-01-28T14:09:31.697Z 2026-01-29T14:30:24.505Z
9265040 9265040 20260127140339_p50Wx NZ0001 2026-01-28T14:08:47.213Z 2026-01-29T14:30:24.423Z
9265018 9265018 20260127135604_lePfn NZ0001 2026-01-28T14:08:41.051Z 2026-01-29T14:30:24.416Z
9264900 9264900 20260127133132_X2eku NZ0001 2026-01-28T14:08:12.403Z 2026-01-29T14:30:24.323Z
9264897 9264897 20260127133029_x7hs4 NZ0001 2026-01-28T14:08:11.489Z 2026-01-29T14:30:24.323Z
9264768 9264768 20260127130836_mr7xh NZ0001 2026-01-28T14:07:33.265Z 2026-01-29T14:30:24.287Z
9264644 9264644 20260127125202_zn8Gh NZ0001 2026-01-28T14:07:00.709Z 2026-01-29T14:30:24.236Z
9264135 9264135 20260127112008_3M6cq NZ0001 2026-01-28T14:04:34.097Z 2026-01-29T14:30:20.070Z
9256963 9256963 20260125112059_iyoAY NZ0001 2026-01-26T14:03:00.055Z 2026-01-29T14:36:38.687Z
9256941 9256941 20260125111356_9qS7K NZ0001 2026-01-26T14:02:52.145Z 2026-01-29T14:36:37.707Z
9256927 9256927 20260125110811_voV6J NZ0001 2026-01-26T14:02:45.521Z 2026-01-29T14:36:36.686Z
9246063 9246063 20260122161946_NwFSf NZ0001 2026-01-23T14:04:38.540Z 2026-01-29T14:50:40.994Z
9246046 9246046 20260122161448_g6jR6 NZ0001 2026-01-23T14:04:35.111Z 2026-01-29T14:50:39.618Z
9245848 9245848 20260122150007_JcVpa NZ0001 2026-01-23T14:03:41.645Z 2026-01-29T14:50:17.909Z
9245829 9245829 20260122144839_qIwgu NZ0001 2026-01-23T14:03:38.171Z 2026-01-29T14:50:15.687Z
9245773 9245773 20260122142129_ss3Kf NZ0001 2026-01-23T14:03:27.412Z 2026-01-29T14:50:10.934Z
9245697 9245697 20260122135341_pV1zx NZ0001 2026-01-23T14:03:01.786Z 2026-01-29T14:49:58.351Z
9245680 9245680 20260122134247_IgcFN NZ0001 2026-01-23T14:02:58.531Z 2026-01-29T14:49:56.994Z
9245197 9245197 20260122111146_13LFQ NZ0001 2026-01-23T14:00:59.597Z 2026-01-29T14:49:14.040Z
9227032 9227032 20260119141021_LDMre NZ0001 2026-01-20T14:06:17.537Z 2026-01-28T14:55:48.561Z
9227014 9227014 20260119135736_7pXJw NZ0001 2026-01-20T14:06:12.417Z 2026-01-28T14:55:47.017Z
9226848 9226848 20260119131857_2a8qi NZ0001 2026-01-20T14:05:20.276Z 2026-01-28T14:55:31.758Z
9226825 9226825 20260119131245_9EG23 NZ0001 2026-01-20T14:05:11.055Z 2026-01-28T14:55:30.370Z
9226566 9226566 20260119122156_cuYD2 NZ0001 2026-01-20T14:03:57.868Z 2026-01-28T14:55:15.417Z
9221582 9221582 20260118160836_lzsqy NZ0001 2026-01-19T14:08:23.890Z 2026-01-27T15:00:32.854Z
9221466 9221466 20260118154308_d2thX NZ0001 2026-01-19T14:07:58.779Z 2026-01-27T15:00:24.207Z
9221408 9221408 20260118153543_TVrYf NZ0001 2026-01-19T14:07:51.045Z 2026-01-27T15:00:19.872Z
9221404 9221404 20260118153509_htwGO NZ0001 2026-01-19T14:07:50.024Z 2026-01-27T15:00:19.071Z
9221254 9221254 20260118151147_hFT2r NZ0001 2026-01-19T14:07:16.965Z 2026-01-27T14:59:59.185Z
9221180 9221180 20260118145913_r4JnJ NZ0001 2026-01-19T14:06:58.910Z 2026-01-27T14:59:56.317Z
9220995 9220995 20260118143953_sqWP5 NZ0001 2026-01-19T14:06:25.590Z 2026-01-27T14:59:50.225Z
9220912 9220912 20260118141859_THLQY NZ0001 2026-01-19T14:06:09.322Z 2026-01-27T14:59:35.049Z
9220891 9220891 20260118141541_8j42e NZ0001 2026-01-19T14:06:00.916Z 2026-01-27T14:59:34.077Z
9220877 9220877 20260118141037_hHGH2 NZ0001 2026-01-19T14:05:55.770Z 2026-01-27T14:59:33.422Z
9220833 9220833 20260118140010_bt07S NZ0001 2026-01-19T14:05:48.845Z 2026-01-27T14:59:31.892Z
9220561 9220561 20260118130943_Q52Jt NZ0001 2026-01-19T14:04:48.271Z 2026-01-27T14:59:20.849Z
9220412 9220412 20260118124611_40rEK NZ0001 2026-01-19T14:04:04.492Z 2026-01-27T14:59:14.294Z
9220081 9220081 20260118120408_TdLR8 NZ0001 2026-01-19T14:02:34.917Z 2026-01-27T14:58:48.847Z
9220030 9220030 20260118115647_R0ZHB NZ0001 2026-01-19T14:02:17.723Z 2026-01-27T14:58:46.629Z
9219949 9219949 20260118114321_52SFq NZ0001 2026-01-19T14:01:51.120Z 2026-01-27T14:58:43.422Z
9219803 9219803 20260118112016_H08Aw NZ0001 2026-01-19T14:00:57.366Z 2026-01-27T14:58:31.988Z
9219615 9219615 20260117111944_XKOFP NZ0001 2026-01-18T14:17:11.245Z 2026-01-25T14:59:33.626Z
9219492 9219492 20260117104549_hnxEi NZ0001 2026-01-18T14:16:40.446Z 2026-01-25T14:59:29.629Z
9219342 9219342 20260117100234_X0Oxv NZ0001 2026-01-18T14:16:00.392Z 2026-01-25T14:59:11.161Z
9219321 9219321 20260117095657_BViY3 NZ0001 2026-01-18T14:15:55.781Z 2026-01-25T14:59:10.519Z
9219246 9219246 20260117093804_5UFWE NZ0001 2026-01-18T14:15:37.567Z 2026-01-25T14:59:08.494Z
9217136 9217136 20260117145208_6Ei6Z NZ0001 2026-01-18T14:04:27.499Z 2026-01-26T14:59:57.650Z
9217080 9217080 20260117143232_1qNmG NZ0001 2026-01-18T14:04:14.203Z 2026-01-26T14:59:55.893Z
9217052 9217052 20260117142435_dh3BU NZ0001 2026-01-18T14:04:04.152Z 2026-01-26T14:59:54.326Z
9217004 9217004 20260117135945_dXmaK NZ0001 2026-01-18T14:03:47.540Z 2026-01-26T14:59:52.112Z
9216977 9216977 20260117134928_Jkr7S NZ0001 2026-01-18T14:03:40.752Z 2026-01-26T14:59:50.301Z
9216860 9216860 20260117131426_cTSG2 NZ0001 2026-01-18T14:03:01.223Z 2026-01-26T14:59:32.958Z
9216614 9216614 20260117122441_pDlV4 NZ0001 2026-01-18T14:01:37.203Z 2026-01-26T14:59:20.910Z
9216584 9216584 20260117121529_tWmKD NZ0001 2026-01-18T14:01:27.930Z 2026-01-26T14:59:19.530Z
9216463 9216463 20260117115436_2cnnZ NZ0001 2026-01-18T14:00:47.273Z 2026-01-26T14:59:15.474Z
9216408 9216408 20260117113858_Rp6ht NZ0001 2026-01-18T14:00:16.900Z 2026-01-26T14:59:09.215Z
9209904 9209904 20260115111834_p9nRk NZ0001 2026-01-16T14:17:56.628Z 2026-01-22T15:05:39.283Z
9192551 9192551 20260112124350_Rhpgc NZ0001 2026-01-13T14:28:38.285Z 2026-01-20T15:26:25.581Z
9192539 9192539 20260112124157_VSsve NZ0001 2026-01-13T14:28:36.611Z 2026-01-20T15:26:25.196Z
9192449 9192449 20260112123626_BiyIn NZ0001 2026-01-13T14:28:25.733Z 2026-01-20T15:26:22.667Z
9192245 9192245 20260112121538_cbp2T NZ0001 2026-01-13T14:27:51.667Z 2026-01-20T15:26:16.018Z
9191808 9191808 20260112114556_ORQTC NZ0001 2026-01-13T14:26:28.873Z 2026-01-20T15:25:47.409Z
9191746 9191746 20260112114209_i5SyR NZ0001 2026-01-13T14:26:18.320Z 2026-01-20T15:25:45.668Z
9191597 9191597 20260112112323_FT5a4 NZ0001 2026-01-13T14:25:49.957Z 2026-01-20T15:25:39.942Z
9191428 9191428 20260112110721_HtDDO NZ0001 2026-01-13T14:25:23.021Z 2026-01-20T15:25:24.528Z
9191420 9191420 20260112110617_RGCAP NZ0001 2026-01-13T14:25:21.982Z 2026-01-20T15:25:24.302Z
9191158 9191158 20260112104025_DQFTQ NZ0001 2026-01-13T14:24:34.914Z 2026-01-20T15:25:12.486Z
9191087 9191087 20260112103242_3fm05 NZ0001 2026-01-13T14:24:25.351Z 2026-01-20T15:25:09.790Z
9190929 9190929 20260112101657_tC8PK NZ0001 2026-01-13T14:23:57.408Z 2026-01-20T15:25:04.378Z
9187129 9187129 20260111152046_LVW1L NZ0001 2026-01-13T14:05:41.550Z 2026-01-20T15:20:02.304Z
9186835 9186835 20260112154849_HaN1G NZ0001 2026-01-13T14:03:41.957Z 2026-01-21T15:03:02.458Z

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