participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,660 rows where station_code = "NZ002S" sorted by created_at descending
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 |
---|---|---|---|---|---|
5500447 | 5500447 | 20241108154511_uh5hv | NZ002S | 2024-11-09T14:06:17.937Z | 2024-11-09T14:06:17.937Z |
5500427 | 5500427 | 20241108154202_SIVix | NZ002S | 2024-11-09T14:06:16.065Z | 2024-11-09T14:06:16.065Z |
5500358 | 5500358 | 20241108152716_Cev36 | NZ002S | 2024-11-09T14:06:10.294Z | 2024-11-09T14:06:10.294Z |
5500315 | 5500315 | 20241108151843_bycYs | NZ002S | 2024-11-09T14:06:06.252Z | 2024-11-09T14:06:06.252Z |
5500267 | 5500267 | 20241108150927_uAbGd | NZ002S | 2024-11-09T14:06:02.255Z | 2024-11-09T14:06:02.255Z |
5500220 | 5500220 | 20241108150557_2ot3C | NZ002S | 2024-11-09T14:05:59.385Z | 2024-11-09T14:05:59.385Z |
5499795 | 5499795 | 20241108133225_cO0ki | NZ002S | 2024-11-09T14:04:58.537Z | 2024-11-09T14:04:58.537Z |
5499761 | 5499761 | 20241108131821_C3j2M | NZ002S | 2024-11-09T14:04:55.327Z | 2024-11-09T14:04:55.327Z |
5499746 | 5499746 | 20241108131624_Kd233 | NZ002S | 2024-11-09T14:04:53.292Z | 2024-11-09T14:04:53.292Z |
5499715 | 5499715 | 20241108130736_TeeDR | NZ002S | 2024-11-09T14:04:48.616Z | 2024-11-09T14:04:48.616Z |
5499709 | 5499709 | 20241108130525_F3eXJ | NZ002S | 2024-11-09T14:04:47.667Z | 2024-11-09T14:04:47.667Z |
5499570 | 5499570 | 20241108123814_ra0xL | NZ002S | 2024-11-09T14:04:21.078Z | 2024-11-09T14:04:21.078Z |
5499430 | 5499430 | 20241108121812_bVMoj | NZ002S | 2024-11-09T14:04:05.930Z | 2024-11-09T14:04:05.930Z |
5494148 | 5494148 | 20241107160442_dPsDj | NZ002S | 2024-11-08T14:05:26.474Z | 2024-11-09T14:16:27.870Z |
5493922 | 5493922 | 20241107143719_oc5IP | NZ002S | 2024-11-08T14:04:55.684Z | 2024-11-09T14:16:27.777Z |
5480643 | 5480643 | 20241105142756_NIxTw | NZ002S | 2024-11-06T14:06:09.522Z | 2024-11-09T14:19:27.409Z |
5480551 | 5480551 | 20241105134428_ayNxD | NZ002S | 2024-11-06T14:05:54.441Z | 2024-11-09T14:19:25.460Z |
5480494 | 5480494 | 20241105131840_D4ogF | NZ002S | 2024-11-06T14:05:47.967Z | 2024-11-09T14:19:24.597Z |
5480458 | 5480458 | 20241105130609_Gp1DK | NZ002S | 2024-11-06T14:05:44.137Z | 2024-11-09T14:19:24.232Z |
5480352 | 5480352 | 20241105123212_uvKFs | NZ002S | 2024-11-06T14:05:19.678Z | 2024-11-09T14:19:23.066Z |
5480215 | 5480215 | 20241105120335_C8dWY | NZ002S | 2024-11-06T14:04:59.012Z | 2024-11-09T14:19:20.549Z |
5473967 | 5473967 | 20241103153102_GSduG | NZ002S | 2024-11-05T14:09:57.039Z | 2024-11-09T14:21:42.292Z |
5473736 | 5473736 | 20241103145711_QreSf | NZ002S | 2024-11-05T14:09:39.921Z | 2024-11-09T14:21:40.790Z |
5472937 | 5472937 | 20241103130228_D1OAq | NZ002S | 2024-11-05T14:07:53.732Z | 2024-11-09T14:21:35.919Z |
5472895 | 5472895 | 20241103125740_k7JPS | NZ002S | 2024-11-05T14:07:50.467Z | 2024-11-09T14:21:35.529Z |
5472844 | 5472844 | 20241103125210_2uB23 | NZ002S | 2024-11-05T14:07:47.349Z | 2024-11-09T14:21:35.347Z |
5472833 | 5472833 | 20241103125002_PfgGT | NZ002S | 2024-11-05T14:07:46.564Z | 2024-11-09T14:21:35.331Z |
5472785 | 5472785 | 20241103124115_XzPdx | NZ002S | 2024-11-05T14:07:42.569Z | 2024-11-09T14:21:34.941Z |
5472743 | 5472743 | 20241103123219_2oAGO | NZ002S | 2024-11-05T14:07:39.220Z | 2024-11-09T14:21:34.507Z |
5472313 | 5472313 | 20241104143713_3SSj2 | NZ002S | 2024-11-05T14:05:37.511Z | 2024-11-09T14:20:38.942Z |
5472082 | 5472082 | 20241104133518_YzWdy | NZ002S | 2024-11-05T14:05:05.036Z | 2024-11-09T14:20:36.442Z |
5471994 | 5471994 | 20241104132033_CgO1Z | NZ002S | 2024-11-05T14:04:55.952Z | 2024-11-09T14:20:35.445Z |
5471949 | 5471949 | 20241104130803_ObzJu | NZ002S | 2024-11-05T14:04:52.141Z | 2024-11-09T14:20:35.242Z |
5471821 | 5471821 | 20241104124710_vKawN | NZ002S | 2024-11-05T14:04:40.295Z | 2024-11-09T14:20:33.988Z |
5471772 | 5471772 | 20241104123530_0tGdk | NZ002S | 2024-11-05T14:04:34.732Z | 2024-11-09T14:20:33.505Z |
5471706 | 5471706 | 20241104122914_1B80G | NZ002S | 2024-11-05T14:04:27.623Z | 2024-11-09T14:20:32.810Z |
5471671 | 5471671 | 20241104122230_pgbjC | NZ002S | 2024-11-05T14:04:17.861Z | 2024-11-09T14:20:32.661Z |
5471455 | 5471455 | 20241104114645_ONFhv | NZ002S | 2024-11-05T14:03:45.452Z | 2024-11-09T14:20:31.176Z |
5471430 | 5471430 | 20241104114415_2FkTZ | NZ002S | 2024-11-05T14:03:43.625Z | 2024-11-09T14:20:31.102Z |
5471423 | 5471423 | 20241104114353_Loplv | NZ002S | 2024-11-05T14:03:43.087Z | 2024-11-09T14:20:31.081Z |
5471379 | 5471379 | 20241104113452_u2YM0 | NZ002S | 2024-11-05T14:03:34.287Z | 2024-11-09T14:20:30.589Z |
5471025 | 5471025 | 20241104103456_vPdOO | NZ002S | 2024-11-05T14:02:33.087Z | 2024-11-09T14:20:27.524Z |
5470930 | 5470930 | 20241104100816_GTBte | NZ002S | 2024-11-05T14:02:18.857Z | 2024-11-09T14:20:26.372Z |
5470910 | 5470910 | 20241104100248_E22fy | NZ002S | 2024-11-05T14:02:16.202Z | 2024-11-09T14:20:26.289Z |
5470653 | 5470653 | 20241104091350_WRJks | NZ002S | 2024-11-05T14:01:28.272Z | 2024-11-09T14:20:22.259Z |
5470475 | 5470475 | 20241104081438_7CBnR | NZ002S | 2024-11-05T14:00:50.299Z | 2024-11-09T14:20:20.827Z |
5465421 | 5465421 | 20241103115251_wev0L | NZ002S | 2024-11-04T14:03:41.314Z | 2024-11-09T14:21:33.145Z |
5465396 | 5465396 | 20241103114430_q4YEI | NZ002S | 2024-11-04T14:03:38.285Z | 2024-11-09T14:21:33.012Z |
5465379 | 5465379 | 20241103114044_HCsWQ | NZ002S | 2024-11-04T14:03:36.805Z | 2024-11-09T14:21:32.775Z |
5465270 | 5465270 | 20241103111438_88fdA | NZ002S | 2024-11-04T14:03:13.963Z | 2024-11-09T14:21:31.740Z |
5465260 | 5465260 | 20241103111303_qaduC | NZ002S | 2024-11-04T14:03:11.657Z | 2024-11-09T14:21:31.722Z |
5465171 | 5465171 | 20241103105549_jhvKH | NZ002S | 2024-11-04T14:03:00.109Z | 2024-11-09T14:21:31.184Z |
5464906 | 5464906 | 20241103095040_lsaUz | NZ002S | 2024-11-04T14:02:08.715Z | 2024-11-09T14:21:29.556Z |
5464837 | 5464837 | 20241103092930_RUf63 | NZ002S | 2024-11-04T14:01:48.390Z | 2024-11-09T14:21:29.219Z |
5464723 | 5464723 | 20241103090224_t2fI0 | NZ002S | 2024-11-04T14:01:30.010Z | 2024-11-09T14:21:28.365Z |
5464686 | 5464686 | 20241103085102_A7zg8 | NZ002S | 2024-11-04T14:01:20.977Z | 2024-11-09T14:21:27.680Z |
5464654 | 5464654 | 20241103084355_k2Cek | NZ002S | 2024-11-04T14:01:14.131Z | 2024-11-09T14:21:27.430Z |
5464515 | 5464515 | 20241103080016_Zmq6y | NZ002S | 2024-11-04T14:00:48.324Z | 2024-11-09T14:21:26.251Z |
5461161 | 5461161 | 20241101161841_Q3Oeh | NZ002S | 2024-11-03T14:14:46.475Z | 2024-11-09T14:23:27.177Z |
5461156 | 5461156 | 20241101161805_s8KNk | NZ002S | 2024-11-03T14:14:46.224Z | 2024-11-09T14:23:27.166Z |
5460776 | 5460776 | 20241101150155_BMGK1 | NZ002S | 2024-11-03T14:14:24.523Z | 2024-11-09T14:23:25.259Z |
5460729 | 5460729 | 20241101145709_SZik7 | NZ002S | 2024-11-03T14:14:18.174Z | 2024-11-09T14:23:24.860Z |
5460664 | 5460664 | 20241101144550_x63eW | NZ002S | 2024-11-03T14:14:10.867Z | 2024-11-09T14:23:24.728Z |
5460617 | 5460617 | 20241101143846_Mdf9D | NZ002S | 2024-11-03T14:14:04.107Z | 2024-11-09T14:23:24.663Z |
5460547 | 5460547 | 20241101142908_eXDfn | NZ002S | 2024-11-03T14:13:57.942Z | 2024-11-09T14:23:24.520Z |
5460463 | 5460463 | 20241101141424_tcShw | NZ002S | 2024-11-03T14:13:46.799Z | 2024-11-09T14:23:24.300Z |
5460406 | 5460406 | 20241101140348_3vTiI | NZ002S | 2024-11-03T14:13:42.235Z | 2024-11-09T14:23:23.895Z |
5460400 | 5460400 | 20241101140322_PKuKW | NZ002S | 2024-11-03T14:13:41.940Z | 2024-11-09T14:23:23.893Z |
5460314 | 5460314 | 20241101134321_Vph5u | NZ002S | 2024-11-03T14:13:35.391Z | 2024-11-09T14:23:23.327Z |
5460255 | 5460255 | 20241101132448_Koo3a | NZ002S | 2024-11-03T14:13:31.253Z | 2024-11-09T14:23:23.242Z |
5459974 | 5459974 | 20241101122658_yOtoX | NZ002S | 2024-11-03T14:13:00.969Z | 2024-11-09T14:23:21.608Z |
5459867 | 5459867 | 20241101120739_CwXJh | NZ002S | 2024-11-03T14:12:42.933Z | 2024-11-09T14:23:21.159Z |
5459750 | 5459750 | 20241101114716_r9jCk | NZ002S | 2024-11-03T14:12:33.340Z | 2024-11-09T14:23:20.563Z |
5458858 | 5458858 | 20241101092921_Q6LRU | NZ002S | 2024-11-03T14:10:43.134Z | 2024-11-09T14:23:14.733Z |
5458643 | 5458643 | 20241101085435_ryQkK | NZ002S | 2024-11-03T14:10:14.159Z | 2024-11-09T14:23:13.292Z |
5458448 | 5458448 | 20241101082725_2u32W | NZ002S | 2024-11-03T14:09:46.179Z | 2024-11-09T14:23:12.116Z |
5458318 | 5458318 | 20241101080521_sPlPt | NZ002S | 2024-11-03T14:09:34.944Z | 2024-11-09T14:23:11.500Z |
5458062 | 5458062 | 20241102160556_otcTY | NZ002S | 2024-11-03T14:08:38.814Z | 2024-11-09T14:22:49.435Z |
5457203 | 5457203 | 20241102134716_hyeQv | NZ002S | 2024-11-03T14:06:45.838Z | 2024-11-09T14:22:47.068Z |
5457050 | 5457050 | 20241102132132_Y7Ks8 | NZ002S | 2024-11-03T14:06:27.044Z | 2024-11-09T14:22:46.476Z |
5449589 | 5449589 | 20241031155858_Csq39 | NZ002S | 2024-11-02T12:13:10.909Z | 2024-11-09T14:24:11.233Z |
5449426 | 5449426 | 20241031153511_5jden | NZ002S | 2024-11-02T12:12:52.153Z | 2024-11-09T14:24:10.411Z |
5449254 | 5449254 | 20241031151039_zAesU | NZ002S | 2024-11-02T12:12:20.622Z | 2024-11-09T14:24:10.015Z |
5449134 | 5449134 | 20241031145849_cdkSK | NZ002S | 2024-11-02T12:12:09.171Z | 2024-11-09T14:24:09.547Z |
5449094 | 5449094 | 20241031145344_37oWX | NZ002S | 2024-11-02T12:12:04.765Z | 2024-11-09T14:24:09.398Z |
5449051 | 5449051 | 20241031144714_wDqow | NZ002S | 2024-11-02T12:12:00.832Z | 2024-11-09T14:24:09.328Z |
5448950 | 5448950 | 20241031143541_Oh4mL | NZ002S | 2024-11-02T12:11:51.503Z | 2024-11-09T14:24:08.508Z |
5448932 | 5448932 | 20241031143330_5HtfI | NZ002S | 2024-11-02T12:11:48.301Z | 2024-11-09T14:24:08.490Z |
5448853 | 5448853 | 20241031142415_4pzZh | NZ002S | 2024-11-02T12:11:34.319Z | 2024-11-09T14:24:07.991Z |
5448828 | 5448828 | 20241031142133_pJNOs | NZ002S | 2024-11-02T12:11:31.856Z | 2024-11-09T14:24:07.737Z |
5448790 | 5448790 | 20241031141605_J33Nb | NZ002S | 2024-11-02T12:11:26.975Z | 2024-11-09T14:24:07.461Z |
5448758 | 5448758 | 20241031141332_oR5uE | NZ002S | 2024-11-02T12:11:24.879Z | 2024-11-09T14:24:07.368Z |
5448673 | 5448673 | 20241031140419_NdjAM | NZ002S | 2024-11-02T12:11:17.767Z | 2024-11-09T14:24:06.939Z |
5448651 | 5448651 | 20241031140121_hjYtn | NZ002S | 2024-11-02T12:11:15.505Z | 2024-11-09T14:24:06.883Z |
5448606 | 5448606 | 20241031135153_cNpZ4 | NZ002S | 2024-11-02T12:11:10.569Z | 2024-11-09T14:24:06.645Z |
5448422 | 5448422 | 20241031133101_yyCNh | NZ002S | 2024-11-02T12:10:45.084Z | 2024-11-09T14:24:05.852Z |
5448382 | 5448382 | 20241031132243_8fdOq | NZ002S | 2024-11-02T12:10:39.994Z | 2024-11-09T14:24:05.710Z |
5448366 | 5448366 | 20241031132154_4273l | NZ002S | 2024-11-02T12:10:37.803Z | 2024-11-09T14:24:05.544Z |
5448315 | 5448315 | 20241031131323_gZmvA | NZ002S | 2024-11-02T12:10:32.112Z | 2024-11-09T14:24:04.689Z |
5448127 | 5448127 | 20241031124715_t3IPE | NZ002S | 2024-11-02T12:10:02.091Z | 2024-11-09T14:24:03.501Z |
Advanced export
JSON shape: default, array, newline-delimited
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);