participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,564 rows where station_code = "NZ0015" 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 |
---|---|---|---|---|---|
5603437 | 5603437 | 20241125152936_KRXrv | NZ0015 | 2024-11-26T14:11:06.978Z | 2024-11-26T14:11:06.978Z |
5603400 | 5603400 | 20241125152047_Mtmtr | NZ0015 | 2024-11-26T14:11:03.696Z | 2024-11-26T14:11:03.696Z |
5603319 | 5603319 | 20241125150243_24ra2 | NZ0015 | 2024-11-26T14:10:56.106Z | 2024-11-26T14:10:56.106Z |
5603171 | 5603171 | 20241125143034_RAWRJ | NZ0015 | 2024-11-26T14:10:27.421Z | 2024-11-26T14:10:27.421Z |
5603153 | 5603153 | 20241125142616_j80Hz | NZ0015 | 2024-11-26T14:10:24.430Z | 2024-11-26T14:10:24.430Z |
5603044 | 5603044 | 20241125135449_Xt7e8 | NZ0015 | 2024-11-26T14:10:10.726Z | 2024-11-26T14:10:10.726Z |
5603017 | 5603017 | 20241125134945_XEnAk | NZ0015 | 2024-11-26T14:10:08.103Z | 2024-11-26T14:10:08.103Z |
5602847 | 5602847 | 20241125131458_1EtCO | NZ0015 | 2024-11-26T14:09:40.780Z | 2024-11-26T14:09:40.780Z |
5602796 | 5602796 | 20241125130158_gX8UJ | NZ0015 | 2024-11-26T14:09:34.210Z | 2024-11-26T14:09:34.210Z |
5602784 | 5602784 | 20241125125749_Ce34o | NZ0015 | 2024-11-26T14:09:32.769Z | 2024-11-26T14:09:32.769Z |
5602629 | 5602629 | 20241125122823_z2oxO | NZ0015 | 2024-11-26T14:09:05.065Z | 2024-11-26T14:09:05.065Z |
5602395 | 5602395 | 20241125114748_BBD5o | NZ0015 | 2024-11-26T14:08:31.196Z | 2024-11-26T14:08:31.196Z |
5602360 | 5602360 | 20241125114329_RdYxz | NZ0015 | 2024-11-26T14:08:27.335Z | 2024-11-26T14:08:27.335Z |
5602266 | 5602266 | 20241125112247_H7bB7 | NZ0015 | 2024-11-26T14:08:03.584Z | 2024-11-26T14:08:03.584Z |
5601976 | 5601976 | 20241125104240_i4hqK | NZ0015 | 2024-11-26T14:07:17.043Z | 2024-11-26T14:07:17.043Z |
5601872 | 5601872 | 20241125102035_fs45u | NZ0015 | 2024-11-26T14:07:01.424Z | 2024-11-26T14:07:01.424Z |
5597336 | 5597336 | 20241124151831_nwSQy | NZ0015 | 2024-11-25T14:11:23.379Z | 2024-11-26T14:18:44.580Z |
5597324 | 5597324 | 20241124151830_343nm | NZ0015 | 2024-11-25T14:11:23.093Z | 2024-11-26T14:18:44.580Z |
5597072 | 5597072 | 20241124145934_NnTO5 | NZ0015 | 2024-11-25T14:11:03.256Z | 2024-11-26T14:18:44.542Z |
5597000 | 5597000 | 20241124145313_N4E3T | NZ0015 | 2024-11-25T14:10:56.770Z | 2024-11-26T14:18:44.531Z |
5596888 | 5596888 | 20241124144308_Rcu2b | NZ0015 | 2024-11-25T14:10:44.993Z | 2024-11-26T14:18:44.502Z |
5596651 | 5596651 | 20241124141129_rNLhQ | NZ0015 | 2024-11-25T14:10:25.974Z | 2024-11-26T14:18:44.461Z |
5596623 | 5596623 | 20241124141005_vdlC6 | NZ0015 | 2024-11-25T14:10:24.105Z | 2024-11-26T14:18:44.457Z |
5596523 | 5596523 | 20241124135949_2lqF3 | NZ0015 | 2024-11-25T14:10:16.154Z | 2024-11-26T14:18:44.440Z |
5596405 | 5596405 | 20241124134758_w55ad | NZ0015 | 2024-11-25T14:09:56.187Z | 2024-11-26T14:18:44.422Z |
5596294 | 5596294 | 20241124133322_0CkE7 | NZ0015 | 2024-11-25T14:09:47.217Z | 2024-11-26T14:18:44.407Z |
5596016 | 5596016 | 20241124130704_F2ipX | NZ0015 | 2024-11-25T14:09:22.025Z | 2024-11-26T14:18:44.361Z |
5595976 | 5595976 | 20241124130437_gS43o | NZ0015 | 2024-11-25T14:09:14.914Z | 2024-11-26T14:18:44.354Z |
5595865 | 5595865 | 20241124125636_pLOZP | NZ0015 | 2024-11-25T14:09:03.149Z | 2024-11-26T14:18:44.339Z |
5595518 | 5595518 | 20241124122714_dEcw2 | NZ0015 | 2024-11-25T14:08:28.137Z | 2024-11-26T14:18:44.281Z |
5594777 | 5594777 | 20241124110525_8xZjo | NZ0015 | 2024-11-25T14:06:31.324Z | 2024-11-26T14:18:44.146Z |
5594147 | 5594147 | 20241124094829_kEmgS | NZ0015 | 2024-11-25T14:04:50.824Z | 2024-11-26T14:18:44.029Z |
5587124 | 5587124 | 20241123152019_h3q4n | NZ0015 | 2024-11-24T14:09:44.883Z | 2024-11-26T14:20:36.275Z |
5586873 | 5586873 | 20241123141621_lysk2 | NZ0015 | 2024-11-24T14:09:05.382Z | 2024-11-26T14:20:31.077Z |
5586851 | 5586851 | 20241123141226_esv90 | NZ0015 | 2024-11-24T14:09:03.394Z | 2024-11-26T14:20:30.646Z |
5586788 | 5586788 | 20241123134616_1XNyU | NZ0015 | 2024-11-24T14:08:56.495Z | 2024-11-26T14:20:28.843Z |
5586704 | 5586704 | 20241123131344_qiQdm | NZ0015 | 2024-11-24T14:08:41.976Z | 2024-11-26T14:20:25.694Z |
5586701 | 5586701 | 20241123131238_WH0Ic | NZ0015 | 2024-11-24T14:08:39.815Z | 2024-11-26T14:20:25.653Z |
5586685 | 5586685 | 20241123130826_jLY1e | NZ0015 | 2024-11-24T14:08:36.784Z | 2024-11-26T14:20:25.163Z |
5586496 | 5586496 | 20241123121939_hzOeg | NZ0015 | 2024-11-24T14:08:05.460Z | 2024-11-26T14:20:18.664Z |
5586438 | 5586438 | 20241123121055_N9U2D | NZ0015 | 2024-11-24T14:07:58.140Z | 2024-11-26T14:20:16.104Z |
5586287 | 5586287 | 20241123114503_cwRaa | NZ0015 | 2024-11-24T14:07:27.397Z | 2024-11-26T14:20:11.848Z |
5586267 | 5586267 | 20241123114107_nfL9Z | NZ0015 | 2024-11-24T14:07:23.948Z | 2024-11-26T14:20:11.328Z |
5583395 | 5583395 | 20241119133044_LzAw1 | NZ0015 | 2024-11-23T14:24:14.507Z | 2024-11-26T14:27:21.240Z |
5583063 | 5583063 | 20241120150816_7NNaW | NZ0015 | 2024-11-23T14:22:45.294Z | 2024-11-26T14:26:08.396Z |
5577160 | 5577160 | 20241121112858_YKspi | NZ0015 | 2024-11-23T14:13:27.262Z | 2024-11-26T14:24:23.272Z |
5576784 | 5576784 | 20241122132423_wPp2D | NZ0015 | 2024-11-23T14:10:25.834Z | 2024-11-26T14:22:52.435Z |
5576750 | 5576750 | 20241122130804_2b0HD | NZ0015 | 2024-11-23T14:10:18.298Z | 2024-11-26T14:22:52.085Z |
5576703 | 5576703 | 20241122125657_6XLAY | NZ0015 | 2024-11-23T14:10:13.195Z | 2024-11-26T14:22:51.768Z |
5576641 | 5576641 | 20241122124442_W24sJ | NZ0015 | 2024-11-23T14:09:58.313Z | 2024-11-26T14:22:51.289Z |
5576561 | 5576561 | 20241122123228_gmbFp | NZ0015 | 2024-11-23T14:09:49.841Z | 2024-11-23T14:09:49.841Z |
5576397 | 5576397 | 20241122115845_V2hbi | NZ0015 | 2024-11-23T14:09:22.199Z | 2024-11-26T14:22:48.792Z |
5576363 | 5576363 | 20241122115358_bgK5C | NZ0015 | 2024-11-23T14:09:19.010Z | 2024-11-26T14:22:48.578Z |
5576308 | 5576308 | 20241122114538_vknqF | NZ0015 | 2024-11-23T14:09:10.645Z | 2024-11-26T14:22:48.143Z |
5575807 | 5575807 | 20241122102308_SV4tm | NZ0015 | 2024-11-23T14:07:38.886Z | 2024-11-26T14:22:44.113Z |
5569229 | 5569229 | 20241121145418_BayuD | NZ0015 | 2024-11-22T14:10:40.939Z | 2024-11-26T14:24:33.422Z |
5568894 | 5568894 | 20241121135921_sIiCT | NZ0015 | 2024-11-22T14:10:02.511Z | 2024-11-26T14:24:31.323Z |
5568250 | 5568250 | 20241121121456_KURwV | NZ0015 | 2024-11-22T14:08:35.383Z | 2024-11-26T14:24:26.343Z |
5568209 | 5568209 | 20241121120616_zUTk9 | NZ0015 | 2024-11-22T14:08:27.772Z | 2024-11-26T14:24:25.542Z |
5568196 | 5568196 | 20241121120438_QWylZ | NZ0015 | 2024-11-22T14:08:24.298Z | 2024-11-26T14:24:25.401Z |
5567975 | 5567975 | 20241121113718_2D53Y | NZ0015 | 2024-11-22T14:07:53.075Z | 2024-11-26T14:24:23.831Z |
5567720 | 5567720 | 20241121105716_boUXV | NZ0015 | 2024-11-22T14:07:08.031Z | 2024-11-26T14:24:20.966Z |
5560477 | 5560477 | 20241120125525_FsPec | NZ0015 | 2024-11-21T14:08:56.298Z | 2024-11-26T14:26:06.659Z |
5560429 | 5560429 | 20241120125119_FOVg1 | NZ0015 | 2024-11-21T14:08:50.538Z | 2024-11-26T14:26:06.339Z |
5560031 | 5560031 | 20241120114853_LzrF4 | NZ0015 | 2024-11-21T14:07:54.172Z | 2024-11-26T14:26:02.841Z |
5559888 | 5559888 | 20241120113029_MKXDy | NZ0015 | 2024-11-21T14:07:28.888Z | 2024-11-26T14:26:01.903Z |
5555519 | 5555519 | 20241119134130_qRVOg | NZ0015 | 2024-11-20T14:05:55.036Z | 2024-11-26T14:27:21.339Z |
5550981 | 5550981 | 20241118120649_YuYZW | NZ0015 | 2024-11-19T14:03:44.078Z | 2024-11-26T14:28:05.386Z |
5550487 | 5550487 | 20241118102845_jj4BR | NZ0015 | 2024-11-19T14:02:25.432Z | 2024-11-26T14:28:01.716Z |
5550430 | 5550430 | 20241118102033_SQvnx | NZ0015 | 2024-11-19T14:02:19.908Z | 2024-11-26T14:28:01.546Z |
5547228 | 5547228 | 20241117151203_a50kG | NZ0015 | 2024-11-18T14:05:18.898Z | 2024-11-26T14:28:37.759Z |
5547203 | 5547203 | 20241117150518_uwB0v | NZ0015 | 2024-11-18T14:05:16.418Z | 2024-11-26T14:28:37.664Z |
5547190 | 5547190 | 20241117150421_KKJA3 | NZ0015 | 2024-11-18T14:05:15.751Z | 2024-11-26T14:28:37.657Z |
5546905 | 5546905 | 20241117132119_3khF2 | NZ0015 | 2024-11-18T14:04:26.854Z | 2024-11-26T14:28:34.356Z |
5546867 | 5546867 | 20241117130912_NM2XL | NZ0015 | 2024-11-18T14:04:23.056Z | 2024-11-26T14:28:34.193Z |
5546823 | 5546823 | 20241117125104_Ac25m | NZ0015 | 2024-11-18T14:04:17.500Z | 2024-11-26T14:28:33.963Z |
5546779 | 5546779 | 20241117124308_l3P58 | NZ0015 | 2024-11-18T14:04:13.883Z | 2024-11-26T14:28:33.810Z |
5546252 | 5546252 | 20241117100613_jdZq5 | NZ0015 | 2024-11-18T14:02:35.354Z | 2024-11-26T14:28:26.142Z |
5546238 | 5546238 | 20241117100406_wCqgI | NZ0015 | 2024-11-18T14:02:33.010Z | 2024-11-26T14:28:26.035Z |
5544723 | 5544723 | 20241116144845_zAb2C | NZ0015 | 2024-11-17T14:01:55.989Z | 2024-11-25T14:22:40.242Z |
5544700 | 5544700 | 20241116143138_mHX1y | NZ0015 | 2024-11-17T14:01:52.916Z | 2024-11-25T14:22:40.192Z |
5544669 | 5544669 | 20241116140218_bYy43 | NZ0015 | 2024-11-17T14:01:49.247Z | 2024-11-25T14:22:39.966Z |
5544646 | 5544646 | 20241116134403_2OXA8 | NZ0015 | 2024-11-17T14:01:45.530Z | 2024-11-25T14:22:39.919Z |
5544638 | 5544638 | 20241116133454_mGSFl | NZ0015 | 2024-11-17T14:01:44.613Z | 2024-11-25T14:22:39.913Z |
5544519 | 5544519 | 20241116121041_R3sR2 | NZ0015 | 2024-11-17T14:01:24.033Z | 2024-11-25T14:22:39.391Z |
5534579 | 5534579 | 20241113124821_fwNPF | NZ0015 | 2024-11-14T14:04:37.402Z | 2024-11-22T14:24:14.678Z |
5520373 | 5520373 | 20241111153014_DmsQQ | NZ0015 | 2024-11-12T14:06:13.923Z | 2024-11-20T14:25:07.638Z |
5520026 | 5520026 | 20241111142538_8uto2 | NZ0015 | 2024-11-12T14:05:29.630Z | 2024-11-20T14:25:02.545Z |
5519981 | 5519981 | 20241111141035_l8HiS | NZ0015 | 2024-11-12T14:05:25.019Z | 2024-11-20T14:25:01.373Z |
5519965 | 5519965 | 20241111140648_jDhko | NZ0015 | 2024-11-12T14:05:24.109Z | 2024-11-20T14:25:01.293Z |
5519865 | 5519865 | 20241111133755_gmdxE | NZ0015 | 2024-11-12T14:05:13.604Z | 2024-11-20T14:25:00.122Z |
5519778 | 5519778 | 20241111125923_o6E2S | NZ0015 | 2024-11-12T14:04:58.574Z | 2024-11-20T14:24:57.810Z |
5519490 | 5519490 | 20241111113640_MtDwx | NZ0015 | 2024-11-12T14:04:14.986Z | 2024-11-20T14:24:51.110Z |
5514449 | 5514449 | 20241110155234_vG8CM | NZ0015 | 2024-11-11T14:06:39.390Z | 2024-11-19T14:21:48.044Z |
5514419 | 5514419 | 20241110154928_n0Zex | NZ0015 | 2024-11-11T14:06:36.731Z | 2024-11-19T14:21:47.737Z |
5514402 | 5514402 | 20241110154357_TpkrH | NZ0015 | 2024-11-11T14:06:34.774Z | 2024-11-19T14:21:47.383Z |
5514355 | 5514355 | 20241110153615_oyDQw | NZ0015 | 2024-11-11T14:06:32.202Z | 2024-11-19T14:21:46.600Z |
5514322 | 5514322 | 20241110153033_g1N32 | NZ0015 | 2024-11-11T14:06:29.258Z | 2024-11-19T14:21:46.343Z |
5514230 | 5514230 | 20241110151537_ADdpv | NZ0015 | 2024-11-11T14:06:22.668Z | 2024-11-19T14:21:45.245Z |
5511505 | 5511505 | 20241105105507_tFg2L | NZ0015 | 2024-11-10T14:22:34.949Z | 2024-11-14T14:23:00.846Z |
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);