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

6,234 rows where station_code = "NZ0049" 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
9625987 9625987 20260408124658_tPeHd NZ0049 2026-04-09T12:07:15.194Z 2026-04-09T12:07:15.194Z
9624470 9624470 20260408070459_M4McR NZ0049 2026-04-09T12:01:35.275Z 2026-04-09T12:01:35.275Z
9610195 9610195 20260405142134_EWlkb NZ0049 2026-04-06T12:06:18.118Z 2026-04-09T12:36:38.999Z
9610173 9610173 20260405141019_LpleS NZ0049 2026-04-06T12:06:09.161Z 2026-04-09T12:36:38.320Z
9607799 9607799 20260404151002_RpFXr NZ0049 2026-04-05T12:04:04.185Z 2026-04-09T12:39:32.633Z
9605986 9605986 20260403134016_cRu2p NZ0049 2026-04-04T12:04:46.388Z 2026-04-09T12:42:05.414Z
9605959 9605959 20260403132934_20ScQ NZ0049 2026-04-04T12:04:37.532Z 2026-04-09T12:42:04.816Z
9604011 9604011 20260402145412_GHG8p NZ0049 2026-04-03T12:05:30.160Z 2026-04-09T12:44:13.566Z
9603954 9603954 20260402142053_BReEb NZ0049 2026-04-03T12:05:19.530Z 2026-04-09T12:44:12.405Z
9603824 9603824 20260402125853_GNBPF NZ0049 2026-04-03T12:04:48.351Z 2026-04-09T12:44:09.915Z
9603802 9603802 20260402124416_Z5NIY NZ0049 2026-04-03T12:04:43.037Z 2026-04-09T12:44:09.559Z
9601525 9601525 20260401154059_n25fo NZ0049 2026-04-02T12:03:00.502Z 2026-04-09T12:45:30.759Z
9601508 9601508 20260401153457_CcVkm NZ0049 2026-04-02T12:02:57.959Z 2026-04-09T12:45:30.255Z
9601439 9601439 20260401151937_ztKM9 NZ0049 2026-04-02T12:02:47.361Z 2026-04-09T12:45:29.091Z
9601261 9601261 20260401133728_4u9HE NZ0049 2026-04-02T12:02:09.843Z 2026-04-09T12:45:25.650Z
9601244 9601244 20260401133221_QEUgc NZ0049 2026-04-02T12:02:07.172Z 2026-04-09T12:45:25.512Z
9601226 9601226 20260401132222_E3Poj NZ0049 2026-04-02T12:02:03.505Z 2026-04-09T12:45:25.275Z
9601222 9601222 20260401132025_MGYHy NZ0049 2026-04-02T12:02:02.974Z 2026-04-09T12:45:25.111Z
9601175 9601175 20260401124004_dqLVb NZ0049 2026-04-02T12:01:52.009Z 2026-04-09T12:45:24.350Z
9601149 9601149 20260401123137_sRuDL NZ0049 2026-04-02T12:01:46.196Z 2026-04-09T12:45:24.074Z
9601117 9601117 20260401120525_nITZj NZ0049 2026-04-02T12:01:39.689Z 2026-04-09T12:45:23.733Z
9601101 9601101 20260401114814_G9GQO NZ0049 2026-04-02T12:01:34.939Z 2026-04-09T12:45:23.430Z
9601098 9601098 20260401114738_Wbeki NZ0049 2026-04-02T12:01:34.133Z 2026-04-09T12:45:23.403Z
9601009 9601009 20260401103004_kUlsq NZ0049 2026-04-02T12:01:16.665Z 2026-04-09T12:45:21.928Z
9599909 9599909 20260331172122_7zwUs NZ0049 2026-04-01T12:05:13.622Z 2026-04-09T12:48:00.361Z
9599892 9599892 20260331171829_2Rl1G NZ0049 2026-04-01T12:05:11.328Z 2026-04-09T12:47:59.551Z
9599622 9599622 20260331160338_2SQaJ NZ0049 2026-04-01T12:04:16.232Z 2026-04-09T12:47:07.073Z
9599429 9599429 20260331143643_NWT1G NZ0049 2026-04-01T12:03:33.867Z 2026-04-09T12:46:47.416Z
9598924 9598924 20260331090523_1lv1u NZ0049 2026-04-01T12:01:36.520Z 2026-04-09T12:46:38.129Z
9598922 9598922 20260331090134_Lz6NW NZ0049 2026-04-01T12:01:35.836Z 2026-04-09T12:46:38.054Z
9598912 9598912 20260331085131_se3A2 NZ0049 2026-04-01T12:01:32.661Z 2026-04-09T12:46:37.864Z
9597428 9597428 20260330161719_kEaqM NZ0049 2026-03-31T12:06:22.375Z 2026-04-08T12:43:42.689Z
9597394 9597394 20260330161326_rt2MX NZ0049 2026-03-31T12:06:18.462Z 2026-04-08T12:43:41.966Z
9597173 9597173 20260330153057_ZmYci NZ0049 2026-03-31T12:05:50.343Z 2026-04-08T12:43:34.807Z
9597161 9597161 20260330152909_ImQWu NZ0049 2026-03-31T12:05:49.379Z 2026-04-08T12:43:34.629Z
9597131 9597131 20260330152214_0rEUJ NZ0049 2026-03-31T12:05:42.530Z 2026-04-08T12:43:33.407Z
9597127 9597127 20260330152213_UuCdY NZ0049 2026-03-31T12:05:42.239Z 2026-04-08T12:43:33.359Z
9596888 9596888 20260330142259_O3rDp NZ0049 2026-03-31T12:05:09.586Z 2026-04-08T12:43:26.985Z
9596659 9596659 20260330133637_Pa92A NZ0049 2026-03-31T12:04:39.953Z 2026-04-08T12:43:21.640Z
9596573 9596573 20260330131519_XMnCQ NZ0049 2026-03-31T12:04:32.025Z 2026-04-08T12:43:19.778Z
9596526 9596526 20260330130131_tosKP NZ0049 2026-03-31T12:04:27.241Z 2026-04-08T12:43:18.823Z
9596440 9596440 20260330123741_5zBG8 NZ0049 2026-03-31T12:04:16.295Z 2026-04-08T12:43:07.331Z
9596435 9596435 20260330123634_1oOrq NZ0049 2026-03-31T12:04:15.581Z 2026-04-08T12:43:03.236Z
9586436 9586436 20260327073943_jJ2fR NZ0049 2026-03-28T12:03:05.292Z 2026-04-05T12:33:25.460Z
9586434 9586434 20260327073902_WIg1n NZ0049 2026-03-28T12:03:04.552Z 2026-04-05T12:33:25.337Z
9586421 9586421 20260327072440_8jf32 NZ0049 2026-03-28T12:03:02.640Z 2026-04-05T12:33:24.702Z
9578408 9578408 20260325114554_Tg9S7 NZ0049 2026-03-26T12:07:33.289Z 2026-04-03T12:38:02.311Z
9578283 9578283 20260325110823_zHtKX NZ0049 2026-03-26T12:07:13.157Z 2026-04-03T12:37:56.772Z
9574645 9574645 20260323072903_3dpXq NZ0049 2026-03-25T12:13:04.356Z 2026-03-31T12:26:37.382Z
9568711 9568711 20260323171507_xhTWt NZ0049 2026-03-24T12:15:36.975Z 2026-03-24T12:24:25.513Z
9568556 9568556 20260323165340_35Exf NZ0049 2026-03-24T12:15:17.211Z 2026-03-31T12:28:30.670Z
9568544 9568544 20260323165255_54wag NZ0049 2026-03-24T12:15:16.335Z 2026-03-24T12:24:25.478Z
9568537 9568537 20260323165255_oAb2X NZ0049 2026-03-24T12:15:15.655Z 2026-03-24T12:24:25.476Z
9568238 9568238 20260323162229_2ZfIc NZ0049 2026-03-24T12:14:45.893Z 2026-03-31T12:28:26.154Z
9568151 9568151 20260323161625_a3P0L NZ0049 2026-03-24T12:14:37.895Z 2026-03-31T12:28:23.685Z
9568100 9568100 20260323161236_skwft NZ0049 2026-03-24T12:14:30.682Z 2026-03-31T12:28:22.815Z
9568067 9568067 20260323161102_QgIpU NZ0049 2026-03-24T12:14:28.469Z 2026-03-31T12:28:22.513Z
9568044 9568044 20260323160837_BAN5Q NZ0049 2026-03-24T12:14:26.879Z 2026-03-31T12:28:22.209Z
9568021 9568021 20260323160717_Nzqgg NZ0049 2026-03-24T12:14:24.159Z 2026-03-31T12:28:21.695Z
9567845 9567845 20260323155330_GLy3N NZ0049 2026-03-24T12:14:13.453Z 2026-03-31T12:28:19.764Z
9567755 9567755 20260323154611_cDrcQ NZ0049 2026-03-24T12:14:06.326Z 2026-03-31T12:28:18.321Z
9567195 9567195 20260323145159_sSRCO NZ0049 2026-03-24T12:13:11.925Z 2026-03-31T12:28:10.170Z
9566848 9566848 20260323141854_0cZCK NZ0049 2026-03-24T12:12:32.658Z 2026-03-31T12:28:05.072Z
9566762 9566762 20260323141139_ELVY4 NZ0049 2026-03-24T12:12:24.502Z 2026-03-31T12:27:56.574Z
9566734 9566734 20260323140754_Ni9f2 NZ0049 2026-03-24T12:12:22.351Z 2026-03-31T12:27:56.244Z
9566111 9566111 20260323130700_2PcbG NZ0049 2026-03-24T12:11:21.758Z 2026-03-31T12:27:46.216Z
9566083 9566083 20260323130357_UEPV8 NZ0049 2026-03-24T12:11:19.319Z 2026-03-31T12:27:45.892Z
9565739 9565739 20260323123617_id4cj NZ0049 2026-03-24T12:10:45.107Z 2026-03-31T12:27:40.410Z
9565712 9565712 20260323123457_0MlXP NZ0049 2026-03-24T12:10:42.708Z 2026-03-31T12:27:40.000Z
9565601 9565601 20260323122444_Kfs4F NZ0049 2026-03-24T12:10:28.815Z 2026-03-31T12:27:38.124Z
9565343 9565343 20260323120144_SObMR NZ0049 2026-03-24T12:09:55.353Z 2026-03-31T12:27:33.428Z
9565301 9565301 20260323115832_aIIsf NZ0049 2026-03-24T12:09:50.031Z 2026-03-31T12:27:32.806Z
9565162 9565162 20260323114750_309mn NZ0049 2026-03-24T12:09:31.106Z 2026-03-31T12:27:27.022Z
9565077 9565077 20260323114237_1RCTy NZ0049 2026-03-24T12:09:21.617Z 2026-03-31T12:27:22.272Z
9565055 9565055 20260323114132_ARxtH NZ0049 2026-03-24T12:09:19.850Z 2026-03-31T12:27:22.026Z
9564895 9564895 20260323111948_TEEay NZ0049 2026-03-24T12:08:59.227Z 2026-03-31T12:27:18.653Z
9564787 9564787 20260323110816_eA5gT NZ0049 2026-03-24T12:08:47.875Z 2026-03-31T12:27:15.478Z
9564780 9564780 20260323110745_y1Oft NZ0049 2026-03-24T12:08:46.799Z 2026-03-31T12:27:15.320Z
9564206 9564206 20260323101101_Onld7 NZ0049 2026-03-24T12:07:37.452Z 2026-03-31T12:27:05.026Z
9564132 9564132 20260323100237_OXCns NZ0049 2026-03-24T12:07:28.641Z 2026-03-31T12:27:03.192Z
9563988 9563988 20260323094513_jmPIO NZ0049 2026-03-24T12:07:07.055Z 2026-03-31T12:27:00.242Z
9563847 9563847 20260323092101_Q2s0q NZ0049 2026-03-24T12:06:51.128Z 2026-03-31T12:26:57.868Z
9563447 9563447 20260323082250_bot6d NZ0049 2026-03-24T12:06:02.274Z 2026-03-31T12:26:43.474Z
9563382 9563382 20260323080713_ft4Nx NZ0049 2026-03-24T12:05:54.115Z 2026-03-31T12:26:42.230Z
9563364 9563364 20260323080518_jTrK4 NZ0049 2026-03-24T12:05:50.238Z 2026-03-31T12:26:41.554Z
9563176 9563176 20260323072901_WOX3w NZ0049 2026-03-24T12:05:22.116Z 2026-03-31T12:26:37.294Z
9559249 9559249 20260321164956_klhO6 NZ0049 2026-03-23T12:10:59.226Z 2026-03-29T12:20:35.807Z
9558544 9558544 20260322165516_DmPej NZ0049 2026-03-23T12:06:48.363Z 2026-03-30T12:30:16.335Z
9558498 9558498 20260322165234_ZKIDU NZ0049 2026-03-23T12:06:46.772Z 2026-03-30T12:30:15.499Z
9558481 9558481 20260322164735_HfITA NZ0049 2026-03-23T12:06:46.057Z 2026-03-30T12:30:14.913Z
9558475 9558475 20260322164735_LwMuZ NZ0049 2026-03-23T12:06:45.955Z 2026-03-30T12:30:14.884Z
9558364 9558364 20260322162635_bHEkZ NZ0049 2026-03-23T12:06:40.043Z 2026-03-30T12:30:11.463Z
9558333 9558333 20260322162429_qAyLs NZ0049 2026-03-23T12:06:39.037Z 2026-03-30T12:30:10.947Z
9558240 9558240 20260322161148_kZ7so NZ0049 2026-03-23T12:06:34.787Z 2026-03-30T12:30:08.720Z
9558238 9558238 20260322161148_mNUxX NZ0049 2026-03-23T12:06:34.684Z 2026-03-30T12:30:08.673Z
9557984 9557984 20260322152718_OCF7V NZ0049 2026-03-23T12:06:18.266Z 2026-03-30T12:29:53.618Z
9557978 9557978 20260322152717_Jw0c7 NZ0049 2026-03-23T12:06:18.157Z 2026-03-30T12:29:53.549Z
9557965 9557965 20260322152621_KJ2qB NZ0049 2026-03-23T12:06:17.539Z 2026-03-30T12:29:53.214Z
9557937 9557937 20260322151956_uyPHh NZ0049 2026-03-23T12:06:16.918Z 2026-03-30T12:29:52.456Z
9557866 9557866 20260322150802_dI3K2 NZ0049 2026-03-23T12:06:13.303Z 2026-03-30T12:29:50.472Z

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