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

5,011 rows where station_code = "NZ005B" 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
9270534 9270534 20260128155834_Keb5C NZ005B 2026-01-29T14:12:33.054Z 2026-01-29T14:12:33.054Z
9270474 9270474 20260128155401_y4Aw9 NZ005B 2026-01-29T14:12:22.885Z 2026-01-29T14:12:22.885Z
9270469 9270469 20260128155319_MZiQx NZ005B 2026-01-29T14:12:22.110Z 2026-01-29T14:12:22.110Z
9270351 9270351 20260128153515_WCJpy NZ005B 2026-01-29T14:11:51.125Z 2026-01-29T14:11:51.125Z
9270327 9270327 20260128153202_20sjI NZ005B 2026-01-29T14:11:46.589Z 2026-01-29T14:11:46.589Z
9270312 9270312 20260128153030_nBdjr NZ005B 2026-01-29T14:11:43.759Z 2026-01-29T14:11:43.759Z
9270294 9270294 20260128152819_LUaQa NZ005B 2026-01-29T14:11:39.884Z 2026-01-29T14:11:39.884Z
9270093 9270093 20260128145328_3tF3D NZ005B 2026-01-29T14:10:49.242Z 2026-01-29T14:10:49.242Z
9270081 9270081 20260128145210_twfkP NZ005B 2026-01-29T14:10:47.800Z 2026-01-29T14:10:47.800Z
9269966 9269966 20260128143811_iUD6O NZ005B 2026-01-29T14:10:21.600Z 2026-01-29T14:10:21.600Z
9269912 9269912 20260128143111_iutBm NZ005B 2026-01-29T14:10:12.506Z 2026-01-29T14:10:12.506Z
9269773 9269773 20260128141109_NF318 NZ005B 2026-01-29T14:09:34.722Z 2026-01-29T14:09:34.722Z
9269749 9269749 20260128140842_cRoeo NZ005B 2026-01-29T14:09:29.697Z 2026-01-29T14:09:29.697Z
9269724 9269724 20260128140001_zsV6V NZ005B 2026-01-29T14:09:17.450Z 2026-01-29T14:09:17.450Z
9269510 9269510 20260128132835_k2mOn NZ005B 2026-01-29T14:08:20.236Z 2026-01-29T14:08:20.236Z
9269477 9269477 20260128132557_ROZ3X NZ005B 2026-01-29T14:08:09.374Z 2026-01-29T14:08:09.374Z
9269237 9269237 20260128124955_12GKs NZ005B 2026-01-29T14:07:04.531Z 2026-01-29T14:07:04.531Z
9269231 9269231 20260128124942_m3qY2 NZ005B 2026-01-29T14:07:03.647Z 2026-01-29T14:07:03.647Z
9269189 9269189 20260128124421_TNs2h NZ005B 2026-01-29T14:06:55.937Z 2026-01-29T14:06:55.937Z
9269170 9269170 20260128124006_Xu1xL NZ005B 2026-01-29T14:06:48.018Z 2026-01-29T14:06:48.018Z
9269152 9269152 20260128123825_oxqXU NZ005B 2026-01-29T14:06:44.230Z 2026-01-29T14:06:44.230Z
9269041 9269041 20260128120825_wefbj NZ005B 2026-01-29T14:06:07.842Z 2026-01-29T14:06:07.842Z
9269037 9269037 20260128120815_d8i0F NZ005B 2026-01-29T14:06:07.295Z 2026-01-29T14:06:07.295Z
9268984 9268984 20260128115724_MmjOk NZ005B 2026-01-29T14:05:51.350Z 2026-01-29T14:05:51.350Z
9268937 9268937 20260128114537_9D5ZY NZ005B 2026-01-29T14:05:37.952Z 2026-01-29T14:05:37.952Z
9268929 9268929 20260128114449_npgJh NZ005B 2026-01-29T14:05:35.964Z 2026-01-29T14:05:35.964Z
9268919 9268919 20260128114416_gMXir NZ005B 2026-01-29T14:05:32.894Z 2026-01-29T14:05:32.894Z
9268893 9268893 20260128113821_wsS9D NZ005B 2026-01-29T14:05:20.523Z 2026-01-29T14:05:20.523Z
9268839 9268839 20260128113206_nEz36 NZ005B 2026-01-29T14:05:08.841Z 2026-01-29T14:05:08.841Z
9268834 9268834 20260128113126_wqLAJ NZ005B 2026-01-29T14:05:07.313Z 2026-01-29T14:05:07.313Z
9268805 9268805 20260128112359_sI2Aq NZ005B 2026-01-29T14:04:57.843Z 2026-01-29T14:04:57.843Z
9268800 9268800 20260128112346_slCn0 NZ005B 2026-01-29T14:04:57.202Z 2026-01-29T14:04:57.202Z
9268796 9268796 20260128112346_vtp6Z NZ005B 2026-01-29T14:04:53.784Z 2026-01-29T14:04:53.784Z
9268760 9268760 20260128111633_iaL9w NZ005B 2026-01-29T14:04:46.759Z 2026-01-29T14:04:46.759Z
9268754 9268754 20260128111520_CdSiJ NZ005B 2026-01-29T14:04:43.731Z 2026-01-29T14:04:43.731Z
9268731 9268731 20260128111252_MZeIJ NZ005B 2026-01-29T14:04:39.111Z 2026-01-29T14:04:39.111Z
9268706 9268706 20260128110545_6qs74 NZ005B 2026-01-29T14:04:26.334Z 2026-01-29T14:04:26.334Z
9268578 9268578 20260128104749_TG8Q6 NZ005B 2026-01-29T14:03:51.297Z 2026-01-29T14:03:51.297Z
9268402 9268402 20260128100633_7jlwa NZ005B 2026-01-29T14:02:49.819Z 2026-01-29T14:02:49.819Z
9268387 9268387 20260128100505_mRCnR NZ005B 2026-01-29T14:02:45.699Z 2026-01-29T14:02:45.699Z
9268316 9268316 20260128094753_1awLI NZ005B 2026-01-29T14:02:20.690Z 2026-01-29T14:02:20.690Z
9268237 9268237 20260128092805_QgT11 NZ005B 2026-01-29T14:01:54.439Z 2026-01-29T14:01:54.439Z
9268126 9268126 20260128085629_3JhDE NZ005B 2026-01-29T14:01:14.743Z 2026-01-29T14:01:14.743Z
9263945 9263945 20260127104534_Yr0Ww NZ005B 2026-01-28T14:03:37.962Z 2026-01-29T14:30:19.974Z
9263750 9263750 20260127100710_m3WNy NZ005B 2026-01-28T14:02:36.196Z 2026-01-29T14:30:18.926Z
9261905 9261905 20260126143111_vbAw3 NZ005B 2026-01-27T14:06:20.578Z 2026-01-29T14:33:15.244Z
9261856 9261856 20260126135612_n6ZIK NZ005B 2026-01-27T14:06:07.066Z 2026-01-29T14:33:10.853Z
9261656 9261656 20260126124216_sxrNs NZ005B 2026-01-27T14:04:52.406Z 2026-01-29T14:32:46.137Z
9261534 9261534 20260126121009_t5oeU NZ005B 2026-01-27T14:04:14.550Z 2026-01-29T14:32:38.287Z
9261530 9261530 20260126120739_ZDSjM NZ005B 2026-01-27T14:04:12.935Z 2026-01-29T14:32:37.957Z
9261456 9261456 20260126114642_OfNLz NZ005B 2026-01-27T14:03:48.014Z 2026-01-29T14:32:25.843Z
9261400 9261400 20260126112751_xkicw NZ005B 2026-01-27T14:03:35.922Z 2026-01-29T14:32:16.166Z
9261317 9261317 20260126110555_A2c8a NZ005B 2026-01-27T14:03:11.329Z 2026-01-29T14:32:11.731Z
9261213 9261213 20260126102736_7PB3U NZ005B 2026-01-27T14:02:35.287Z 2026-01-29T14:32:04.690Z
9261159 9261159 20260126100421_hBBXw NZ005B 2026-01-27T14:02:17.105Z 2026-01-29T14:32:00.281Z
9260972 9260972 20260126090542_SYZHo NZ005B 2026-01-27T14:01:11.806Z 2026-01-29T14:31:16.709Z
9257719 9257719 20260125154109_Zgu3o NZ005B 2026-01-26T14:07:25.160Z 2026-01-29T14:37:36.823Z
9257715 9257715 20260125153847_RA4Qy NZ005B 2026-01-26T14:07:23.727Z 2026-01-29T14:37:36.580Z
9257710 9257710 20260125153503_IV86b NZ005B 2026-01-26T14:07:22.577Z 2026-01-29T14:37:36.351Z
9257708 9257708 20260125153102_iGspV NZ005B 2026-01-26T14:07:21.751Z 2026-01-29T14:37:36.111Z
9257670 9257670 20260125152213_qqs8v NZ005B 2026-01-26T14:07:09.866Z 2026-01-29T14:37:33.974Z
9257618 9257618 20260125145944_D78SC NZ005B 2026-01-26T14:06:46.078Z 2026-01-29T14:37:30.550Z
9257615 9257615 20260125145848_jphKZ NZ005B 2026-01-26T14:06:44.992Z 2026-01-29T14:37:30.477Z
9257607 9257607 20260125145502_W2SAI NZ005B 2026-01-26T14:06:38.008Z 2026-01-29T14:37:30.047Z
9257541 9257541 20260125142620_x206s NZ005B 2026-01-26T14:06:13.097Z 2026-01-29T14:37:26.430Z
9257335 9257335 20260125124920_3aWxL NZ005B 2026-01-26T14:04:47.340Z 2026-01-29T14:37:06.010Z
9257234 9257234 20260125122919_jJwQL NZ005B 2026-01-26T14:04:17.919Z 2026-01-29T14:37:00.641Z
9256824 9256824 20260125103720_oaLdw NZ005B 2026-01-26T14:02:09.734Z 2026-01-29T14:36:25.962Z
9256573 9256573 20260125085751_giJic NZ005B 2026-01-26T14:00:38.084Z 2026-01-29T14:36:09.283Z
9253956 9253956 20260124160949_OhDLn NZ005B 2026-01-25T14:05:09.177Z 2026-01-29T14:41:53.760Z
9253942 9253942 20260124160427_HK6je NZ005B 2026-01-25T14:05:05.779Z 2026-01-29T14:41:51.868Z
9253936 9253936 20260124160219_1X8Kq NZ005B 2026-01-25T14:05:04.168Z 2026-01-29T14:41:51.263Z
9253790 9253790 20260124144025_g2oSz NZ005B 2026-01-25T14:04:25.508Z 2026-01-29T14:41:30.575Z
9253692 9253692 20260124135207_CvXsz NZ005B 2026-01-25T14:03:59.117Z 2026-01-29T14:41:17.488Z
9253686 9253686 20260124134601_yP4I3 NZ005B 2026-01-25T14:03:57.349Z 2026-01-29T14:41:16.808Z
9250516 9250516 20260123155117_afCqd NZ005B 2026-01-24T14:03:20.570Z 2026-01-29T14:45:44.243Z
9250505 9250505 20260123154602_UZUlH NZ005B 2026-01-24T14:03:17.300Z 2026-01-29T14:45:42.826Z
9250467 9250467 20260123152348_PbcEu NZ005B 2026-01-24T14:03:04.247Z 2026-01-29T14:45:37.361Z
9250172 9250172 20260123105616_2tflF NZ005B 2026-01-24T14:01:32.765Z 2026-01-29T14:45:03.429Z
9250166 9250166 20260123105454_KkYgJ NZ005B 2026-01-24T14:01:31.762Z 2026-01-29T14:45:03.059Z
9250052 9250052 20260123095600_IQyJD NZ005B 2026-01-24T14:00:52.602Z 2026-01-29T14:44:56.004Z
9249973 9249973 20260123091737_43Em6 NZ005B 2026-01-24T14:00:23.517Z 2026-01-29T14:44:45.667Z
9249950 9249950 20260123090940_2X4Ky NZ005B 2026-01-24T14:00:17.004Z 2026-01-29T14:44:44.516Z
9249932 9249932 20260123090048_ClSi7 NZ005B 2026-01-24T14:00:09.719Z 2026-01-29T14:44:41.295Z
9249774 9249774 20260122083620_mm7L2 NZ005B 2026-01-23T14:16:13.365Z 2026-01-29T14:58:54.844Z
9245715 9245715 20260122135902_aBPps NZ005B 2026-01-23T14:03:05.516Z 2026-01-29T14:49:59.260Z
9245683 9245683 20260122134309_g691r NZ005B 2026-01-23T14:02:58.983Z 2026-01-29T14:49:57.070Z
9245087 9245087 20260122100202_m9Yxc NZ005B 2026-01-23T14:00:28.241Z 2026-01-29T14:48:57.248Z
9245060 9245060 20260122094930_JA3bJ NZ005B 2026-01-23T14:00:20.910Z 2026-01-29T14:48:55.169Z
9220689 9220689 20260118132835_CSb9B NZ005B 2026-01-19T14:05:15.079Z 2026-01-27T14:59:25.045Z
9215932 9215932 20260116112559_LY2xf NZ005B 2026-01-17T14:27:17.295Z 2026-01-24T15:15:18.658Z
9215813 9215813 20260116110340_joqYP NZ005B 2026-01-17T14:26:59.147Z 2026-01-24T15:15:14.102Z
9215615 9215615 20260116103533_PMQmE NZ005B 2026-01-17T14:26:16.654Z 2026-01-24T15:15:05.002Z
9215459 9215459 20260116101733_uS2zg NZ005B 2026-01-17T14:25:37.781Z 2026-01-24T15:14:55.394Z
9215357 9215357 20260116095745_Ht1EX NZ005B 2026-01-17T14:25:15.505Z 2026-01-24T15:14:42.373Z
9215334 9215334 20260116095604_YrrMl NZ005B 2026-01-17T14:25:13.799Z 2026-01-24T15:14:41.893Z
9215153 9215153 20260116092810_J39yd NZ005B 2026-01-17T14:24:36.659Z 2026-01-24T15:14:32.793Z
9215131 9215131 20260116092034_KJrIY NZ005B 2026-01-17T14:24:31.386Z 2026-01-24T15:14:31.526Z
9215114 9215114 20260116091850_O0Sgh NZ005B 2026-01-17T14:24:27.086Z 2026-01-24T15:14:30.741Z
9211044 9211044 20260116151326_6wf3r NZ005B 2026-01-17T14:04:02.160Z 2026-01-25T14:57:17.290Z

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