participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,407 rows where station_code = "NZ0046" 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 |
---|---|---|---|---|---|
5569446 | 5569446 | 20241121153215_BGTrZ | NZ0046 | 2024-11-22T14:10:53.613Z | 2024-11-22T14:10:53.613Z |
5569410 | 5569410 | 20241121152543_Uijd1 | NZ0046 | 2024-11-22T14:10:51.254Z | 2024-11-22T14:10:51.254Z |
5569300 | 5569300 | 20241121150651_qts2m | NZ0046 | 2024-11-22T14:10:44.247Z | 2024-11-22T14:10:44.247Z |
5569275 | 5569275 | 20241121150353_T3ogZ | NZ0046 | 2024-11-22T14:10:43.379Z | 2024-11-22T14:10:43.379Z |
5569250 | 5569250 | 20241121145929_XfNTQ | NZ0046 | 2024-11-22T14:10:41.538Z | 2024-11-22T14:10:41.538Z |
5569188 | 5569188 | 20241121144922_snSP3 | NZ0046 | 2024-11-22T14:10:28.972Z | 2024-11-22T14:10:28.972Z |
5569168 | 5569168 | 20241121144551_Tv8R5 | NZ0046 | 2024-11-22T14:10:25.952Z | 2024-11-22T14:10:25.952Z |
5569115 | 5569115 | 20241121143730_tktJQ | NZ0046 | 2024-11-22T14:10:21.876Z | 2024-11-22T14:10:21.876Z |
5569061 | 5569061 | 20241121142516_KeKkO | NZ0046 | 2024-11-22T14:10:15.820Z | 2024-11-22T14:10:15.820Z |
5569039 | 5569039 | 20241121142404_PMi3h | NZ0046 | 2024-11-22T14:10:13.775Z | 2024-11-22T14:10:13.775Z |
5568795 | 5568795 | 20241121133723_IVMR2 | NZ0046 | 2024-11-22T14:09:43.073Z | 2024-11-22T14:09:43.073Z |
5568614 | 5568614 | 20241121131127_a10FS | NZ0046 | 2024-11-22T14:09:26.045Z | 2024-11-22T14:09:26.045Z |
5568605 | 5568605 | 20241121131041_uHFhH | NZ0046 | 2024-11-22T14:09:25.296Z | 2024-11-22T14:09:25.296Z |
5568484 | 5568484 | 20241121125202_7PNkT | NZ0046 | 2024-11-22T14:09:03.636Z | 2024-11-22T14:09:03.636Z |
5568193 | 5568193 | 20241121120421_JmYcd | NZ0046 | 2024-11-22T14:08:23.640Z | 2024-11-22T14:08:23.640Z |
5568147 | 5568147 | 20241121115527_hBX1A | NZ0046 | 2024-11-22T14:08:12.889Z | 2024-11-22T14:08:12.889Z |
5568078 | 5568078 | 20241121114611_7u4D7 | NZ0046 | 2024-11-22T14:08:03.786Z | 2024-11-22T14:08:03.786Z |
5567885 | 5567885 | 20241121112203_REs3f | NZ0046 | 2024-11-22T14:07:29.800Z | 2024-11-22T14:07:29.800Z |
5567701 | 5567701 | 20241121105305_BLiJi | NZ0046 | 2024-11-22T14:07:04.507Z | 2024-11-22T14:07:04.507Z |
5567666 | 5567666 | 20241121104934_nBLwy | NZ0046 | 2024-11-22T14:06:47.789Z | 2024-11-22T14:06:47.789Z |
5560975 | 5560975 | 20241120154057_G0bqr | NZ0046 | 2024-11-21T14:10:07.512Z | 2024-11-22T14:19:21.775Z |
5560866 | 5560866 | 20241120145913_G22pS | NZ0046 | 2024-11-21T14:09:53.685Z | 2024-11-22T14:19:21.749Z |
5560350 | 5560350 | 20241120124052_6ySXC | NZ0046 | 2024-11-21T14:08:42.444Z | 2024-11-22T14:19:21.642Z |
5560229 | 5560229 | 20241120122036_wYDYU | NZ0046 | 2024-11-21T14:08:19.738Z | 2024-11-22T14:19:21.615Z |
5560208 | 5560208 | 20241120121810_dKlFF | NZ0046 | 2024-11-21T14:08:16.862Z | 2024-11-22T14:19:21.612Z |
5559832 | 5559832 | 20241120112221_veMFv | NZ0046 | 2024-11-21T14:07:17.936Z | 2024-11-22T14:19:21.533Z |
5559562 | 5559562 | 20241120104351_d7m5U | NZ0046 | 2024-11-21T14:06:36.548Z | 2024-11-22T14:19:21.474Z |
5555601 | 5555601 | 20241119140341_OvcmW | NZ0046 | 2024-11-20T14:06:04.750Z | 2024-11-22T14:20:10.744Z |
5555565 | 5555565 | 20241119135403_DI3LV | NZ0046 | 2024-11-20T14:06:00.533Z | 2024-11-22T14:20:09.778Z |
5555486 | 5555486 | 20241119132904_5s42N | NZ0046 | 2024-11-20T14:05:50.537Z | 2024-11-22T14:20:07.466Z |
5555316 | 5555316 | 20241119124008_MGeHP | NZ0046 | 2024-11-20T14:05:10.427Z | 2024-11-22T14:20:03.777Z |
5551936 | 5551936 | 20241118154520_58H22 | NZ0046 | 2024-11-19T14:05:49.145Z | 2024-11-22T14:22:13.077Z |
5551882 | 5551882 | 20241118153220_2p5O7 | NZ0046 | 2024-11-19T14:05:45.710Z | 2024-11-22T14:22:12.858Z |
5551874 | 5551874 | 20241118153132_HcZfV | NZ0046 | 2024-11-19T14:05:44.785Z | 2024-11-22T14:22:12.823Z |
5551798 | 5551798 | 20241118151719_BSebL | NZ0046 | 2024-11-19T14:05:32.406Z | 2024-11-22T14:22:12.531Z |
5551778 | 5551778 | 20241118151225_1SGn0 | NZ0046 | 2024-11-19T14:05:29.474Z | 2024-11-22T14:22:12.478Z |
5551769 | 5551769 | 20241118150759_YATvY | NZ0046 | 2024-11-19T14:05:27.099Z | 2024-11-22T14:22:12.432Z |
5551765 | 5551765 | 20241118150653_Lbn03 | NZ0046 | 2024-11-19T14:05:26.458Z | 2024-11-22T14:22:12.421Z |
5551651 | 5551651 | 20241118143551_Hq3NR | NZ0046 | 2024-11-19T14:05:07.448Z | 2024-11-22T14:22:11.918Z |
5551618 | 5551618 | 20241118142826_Br9QL | NZ0046 | 2024-11-19T14:05:05.025Z | 2024-11-22T14:22:11.720Z |
5551456 | 5551456 | 20241118134105_8U5Fs | NZ0046 | 2024-11-19T14:04:48.835Z | 2024-11-22T14:22:10.774Z |
5551059 | 5551059 | 20241118121633_c2UCg | NZ0046 | 2024-11-19T14:03:51.000Z | 2024-11-22T14:22:07.971Z |
5550853 | 5550853 | 20241118113642_myxj2 | NZ0046 | 2024-11-19T14:03:12.823Z | 2024-11-22T14:22:06.193Z |
5550811 | 5550811 | 20241118113053_BM51V | NZ0046 | 2024-11-19T14:03:08.830Z | 2024-11-22T14:22:05.890Z |
5550725 | 5550725 | 20241118111524_Uc36n | NZ0046 | 2024-11-19T14:02:58.699Z | 2024-11-22T14:22:05.079Z |
5550721 | 5550721 | 20241118111449_3MXAX | NZ0046 | 2024-11-19T14:02:58.427Z | 2024-11-22T14:22:05.064Z |
5550696 | 5550696 | 20241118111102_EJE36 | NZ0046 | 2024-11-19T14:02:55.991Z | 2024-11-22T14:22:04.889Z |
5550385 | 5550385 | 20241118101124_sy9bb | NZ0046 | 2024-11-19T14:02:16.209Z | 2024-11-22T14:22:02.597Z |
5550367 | 5550367 | 20241118100942_4eJTW | NZ0046 | 2024-11-19T14:02:14.625Z | 2024-11-22T14:22:01.732Z |
5550188 | 5550188 | 20241118094412_07H6l | NZ0046 | 2024-11-19T14:01:43.131Z | 2024-11-22T14:21:59.474Z |
5550139 | 5550139 | 20241118093711_nKaAo | NZ0046 | 2024-11-19T14:01:37.227Z | 2024-11-22T14:21:58.761Z |
5550078 | 5550078 | 20241118092716_3SVFx | NZ0046 | 2024-11-19T14:01:32.708Z | 2024-11-22T14:21:57.798Z |
5549997 | 5549997 | 20241118090428_JInYS | NZ0046 | 2024-11-19T14:01:25.343Z | 2024-11-22T14:21:56.540Z |
5549887 | 5549887 | 20241118083015_UKo6Z | NZ0046 | 2024-11-19T14:01:07.897Z | 2024-11-22T14:21:54.709Z |
5549862 | 5549862 | 20241118081744_4Mwny | NZ0046 | 2024-11-19T14:01:00.836Z | 2024-11-22T14:21:54.172Z |
5546613 | 5546613 | 20241117115435_w323H | NZ0046 | 2024-11-18T14:03:39.321Z | 2024-11-22T14:22:33.402Z |
5546422 | 5546422 | 20241117105035_rSgn3 | NZ0046 | 2024-11-18T14:03:04.380Z | 2024-11-22T14:22:31.910Z |
5546409 | 5546409 | 20241117104705_bPI12 | NZ0046 | 2024-11-18T14:03:02.437Z | 2024-11-22T14:22:31.815Z |
5546363 | 5546363 | 20241117103150_fc6qT | NZ0046 | 2024-11-18T14:02:55.687Z | 2024-11-22T14:22:31.357Z |
5546346 | 5546346 | 20241117102956_U3kJa | NZ0046 | 2024-11-18T14:02:53.783Z | 2024-11-22T14:22:31.240Z |
5546337 | 5546337 | 20241117102759_wp2qL | NZ0046 | 2024-11-18T14:02:52.191Z | 2024-11-22T14:22:31.212Z |
5544810 | 5544810 | 20241116154147_bbaR9 | NZ0046 | 2024-11-17T14:02:11.249Z | 2024-11-22T14:23:06.348Z |
5544693 | 5544693 | 20241116142841_1P7HZ | NZ0046 | 2024-11-17T14:01:52.125Z | 2024-11-22T14:23:05.586Z |
5544453 | 5544453 | 20241116111903_FxcaG | NZ0046 | 2024-11-17T14:01:12.488Z | 2024-11-22T14:23:02.947Z |
5526500 | 5526500 | 20241112093349_XGacO | NZ0046 | 2024-11-13T14:03:20.076Z | 2024-11-21T14:25:35.990Z |
5520448 | 5520448 | 20241111155810_8JxaN | NZ0046 | 2024-11-12T14:06:21.814Z | 2024-11-20T14:25:10.048Z |
5520431 | 5520431 | 20241111154739_Rby9g | NZ0046 | 2024-11-12T14:06:19.766Z | 2024-11-20T14:25:08.789Z |
5520402 | 5520402 | 20241111153507_qrpT9 | NZ0046 | 2024-11-12T14:06:15.585Z | 2024-11-20T14:25:07.881Z |
5520383 | 5520383 | 20241111153227_ASotO | NZ0046 | 2024-11-12T14:06:14.489Z | 2024-11-20T14:25:07.720Z |
5520259 | 5520259 | 20241111150925_AdiXX | NZ0046 | 2024-11-12T14:06:02.673Z | 2024-11-20T14:25:06.341Z |
5520166 | 5520166 | 20241111145306_0t21r | NZ0046 | 2024-11-12T14:05:46.841Z | 2024-11-20T14:25:05.299Z |
5520157 | 5520157 | 20241111145123_SsMOu | NZ0046 | 2024-11-12T14:05:45.941Z | 2024-11-20T14:25:04.961Z |
5520151 | 5520151 | 20241111144752_XhUR5 | NZ0046 | 2024-11-12T14:05:44.967Z | 2024-11-20T14:25:04.646Z |
5520147 | 5520147 | 20241111144714_m8msq | NZ0046 | 2024-11-12T14:05:42.949Z | 2024-11-20T14:25:04.521Z |
5519988 | 5519988 | 20241111141115_R2WrB | NZ0046 | 2024-11-12T14:05:25.452Z | 2024-11-20T14:25:01.402Z |
5519943 | 5519943 | 20241111140153_Q89JE | NZ0046 | 2024-11-12T14:05:21.554Z | 2024-11-20T14:25:00.958Z |
5519861 | 5519861 | 20241111133525_l6MuI | NZ0046 | 2024-11-12T14:05:11.750Z | 2024-11-20T14:24:59.973Z |
5519855 | 5519855 | 20241111133524_pt9Rc | NZ0046 | 2024-11-12T14:05:11.308Z | 2024-11-20T14:24:59.970Z |
5519826 | 5519826 | 20241111132727_aMiy2 | NZ0046 | 2024-11-12T14:05:06.348Z | 2024-11-20T14:24:58.434Z |
5519713 | 5519713 | 20241111123656_s6sNf | NZ0046 | 2024-11-12T14:04:48.596Z | 2024-11-20T14:24:55.817Z |
5519705 | 5519705 | 20241111123515_5hTgQ | NZ0046 | 2024-11-12T14:04:47.979Z | 2024-11-20T14:24:55.695Z |
5519544 | 5519544 | 20241111115409_7gXHH | NZ0046 | 2024-11-12T14:04:27.807Z | 2024-11-20T14:24:51.982Z |
5519186 | 5519186 | 20241111103545_XJquG | NZ0046 | 2024-11-12T14:03:16.972Z | 2024-11-20T14:24:46.342Z |
5507687 | 5507687 | 20241109120914_z5dC7 | NZ0046 | 2024-11-10T14:05:47.415Z | 2024-11-18T14:26:13.217Z |
5500508 | 5500508 | 20241108155321_CTD9l | NZ0046 | 2024-11-09T14:06:23.319Z | 2024-11-17T14:23:23.066Z |
5500465 | 5500465 | 20241108154814_o8V5x | NZ0046 | 2024-11-09T14:06:18.986Z | 2024-11-17T14:23:22.817Z |
5500450 | 5500450 | 20241108154511_uh5hv | NZ0046 | 2024-11-09T14:06:17.937Z | 2024-11-17T14:23:22.726Z |
5500432 | 5500432 | 20241108154211_Qsq2K | NZ0046 | 2024-11-09T14:06:16.385Z | 2024-11-17T14:23:22.570Z |
5500366 | 5500366 | 20241108152941_AF3gE | NZ0046 | 2024-11-09T14:06:10.720Z | 2024-11-17T14:23:22.203Z |
5500362 | 5500362 | 20241108152716_Cev36 | NZ0046 | 2024-11-09T14:06:10.294Z | 2024-11-17T14:23:22.113Z |
5500321 | 5500321 | 20241108151843_bycYs | NZ0046 | 2024-11-09T14:06:06.252Z | 2024-11-17T14:23:21.509Z |
5500245 | 5500245 | 20241108150737_2qB0e | NZ0046 | 2024-11-09T14:06:00.789Z | 2024-11-17T14:23:20.338Z |
5500223 | 5500223 | 20241108150557_2ot3C | NZ0046 | 2024-11-09T14:05:59.385Z | 2024-11-17T14:23:20.224Z |
5500217 | 5500217 | 20241108150511_kHM37 | NZ0046 | 2024-11-09T14:05:59.242Z | 2024-11-17T14:23:20.203Z |
5500204 | 5500204 | 20241108150402_TX45H | NZ0046 | 2024-11-09T14:05:58.326Z | 2024-11-17T14:23:20.058Z |
5500044 | 5500044 | 20241108143245_IyHQp | NZ0046 | 2024-11-09T14:05:34.356Z | 2024-11-17T14:23:18.226Z |
5499987 | 5499987 | 20241108141909_VdhTt | NZ0046 | 2024-11-09T14:05:27.351Z | 2024-11-17T14:23:17.863Z |
5498814 | 5498814 | 20241108100828_IjT1L | NZ0046 | 2024-11-09T14:02:28.063Z | 2024-11-17T14:23:00.178Z |
5498791 | 5498791 | 20241108095952_N32bO | NZ0046 | 2024-11-09T14:02:24.987Z | 2024-11-17T14:22:59.921Z |
5498684 | 5498684 | 20241108093624_mWOyR | NZ0046 | 2024-11-09T14:02:11.027Z | 2024-11-17T14:22:58.890Z |
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);