participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,119 rows where station_code = "NZ004X" 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 |
---|---|---|---|---|---|
5573275 | 5573275 | 20241119132136_B23nR | NZ004X | 2024-11-22T14:20:06.770Z | 2024-11-22T14:20:06.770Z |
5560999 | 5560999 | 20241120155355_UKY3o | NZ004X | 2024-11-21T14:10:11.522Z | 2024-11-22T14:19:21.781Z |
5560960 | 5560960 | 20241120152901_2lhcP | NZ004X | 2024-11-21T14:10:05.778Z | 2024-11-22T14:19:21.771Z |
5560861 | 5560861 | 20241120145700_U4jfL | NZ004X | 2024-11-21T14:09:53.348Z | 2024-11-22T14:19:21.749Z |
5560851 | 5560851 | 20241120145219_krNc6 | NZ004X | 2024-11-21T14:09:52.133Z | 2024-11-22T14:19:21.746Z |
5560844 | 5560844 | 20241120144933_zsai9 | NZ004X | 2024-11-21T14:09:51.040Z | 2024-11-22T14:19:21.744Z |
5560788 | 5560788 | 20241120142319_idTR6 | NZ004X | 2024-11-21T14:09:44.800Z | 2024-11-22T14:19:21.732Z |
5560747 | 5560747 | 20241120141329_fCgEt | NZ004X | 2024-11-21T14:09:41.967Z | 2024-11-22T14:19:21.726Z |
5560741 | 5560741 | 20241120141106_iKvm0 | NZ004X | 2024-11-21T14:09:40.997Z | 2024-11-22T14:19:21.724Z |
5560735 | 5560735 | 20241120141105_xeKq2 | NZ004X | 2024-11-21T14:09:40.557Z | 2024-11-22T14:19:21.724Z |
5560723 | 5560723 | 20241120140324_0SWBl | NZ004X | 2024-11-21T14:09:35.906Z | 2024-11-22T14:19:21.720Z |
5560659 | 5560659 | 20241120134550_O15SL | NZ004X | 2024-11-21T14:09:22.248Z | 2024-11-22T14:19:21.707Z |
5560603 | 5560603 | 20241120132040_RMJmF | NZ004X | 2024-11-21T14:09:12.671Z | 2024-11-22T14:19:21.693Z |
5560547 | 5560547 | 20241120130803_NhfUG | NZ004X | 2024-11-21T14:09:04.008Z | 2024-11-22T14:19:21.682Z |
5560502 | 5560502 | 20241120130107_WKAZH | NZ004X | 2024-11-21T14:08:58.313Z | 2024-11-22T14:19:21.672Z |
5560276 | 5560276 | 20241120122910_dreIW | NZ004X | 2024-11-21T14:08:28.385Z | 2024-11-22T14:19:21.626Z |
5560141 | 5560141 | 20241120120727_tw0Ul | NZ004X | 2024-11-21T14:08:07.422Z | 2024-11-22T14:19:21.597Z |
5560095 | 5560095 | 20241120115759_Qp2JL | NZ004X | 2024-11-21T14:08:01.896Z | 2024-11-22T14:19:21.586Z |
5559884 | 5559884 | 20241120112939_2F38o | NZ004X | 2024-11-21T14:07:27.127Z | 2024-11-22T14:19:21.543Z |
5559770 | 5559770 | 20241120111518_cGeur | NZ004X | 2024-11-21T14:07:09.399Z | 2024-11-22T14:19:21.521Z |
5559625 | 5559625 | 20241120105131_g7r8H | NZ004X | 2024-11-21T14:06:46.111Z | 2024-11-22T14:19:21.488Z |
5559547 | 5559547 | 20241120103954_fHWpk | NZ004X | 2024-11-21T14:06:34.637Z | 2024-11-22T14:19:21.470Z |
5559379 | 5559379 | 20241120101322_ieZI0 | NZ004X | 2024-11-21T14:06:11.836Z | 2024-11-22T14:19:21.432Z |
5559313 | 5559313 | 20241120100231_F9srm | NZ004X | 2024-11-21T14:05:56.597Z | 2024-11-22T14:19:21.415Z |
5559104 | 5559104 | 20241120092430_QAwvQ | NZ004X | 2024-11-21T14:05:22.195Z | 2024-11-22T14:19:21.365Z |
5555745 | 5555745 | 20241119152357_W0KUq | NZ004X | 2024-11-20T14:06:31.335Z | 2024-11-22T14:20:13.390Z |
5555728 | 5555728 | 20241119150218_XZv2o | NZ004X | 2024-11-20T14:06:29.147Z | 2024-11-22T14:20:13.061Z |
5555719 | 5555719 | 20241119145833_vJ05j | NZ004X | 2024-11-20T14:06:28.245Z | 2024-11-22T14:20:12.775Z |
5555714 | 5555714 | 20241119145631_fCTZV | NZ004X | 2024-11-20T14:06:27.656Z | 2024-11-22T14:20:12.693Z |
5555678 | 5555678 | 20241119143720_RFcot | NZ004X | 2024-11-20T14:06:23.630Z | 2024-11-22T14:20:12.282Z |
5555592 | 5555592 | 20241119135930_joalQ | NZ004X | 2024-11-20T14:06:03.586Z | 2024-11-22T14:20:10.571Z |
5555560 | 5555560 | 20241119135213_lqnIq | NZ004X | 2024-11-20T14:05:59.243Z | 2024-11-22T14:20:09.729Z |
5555556 | 5555556 | 20241119135057_uiIpx | NZ004X | 2024-11-20T14:05:58.760Z | 2024-11-22T14:20:09.651Z |
5555545 | 5555545 | 20241119134721_ZgChy | NZ004X | 2024-11-20T14:05:56.823Z | 2024-11-22T14:20:09.322Z |
5555542 | 5555542 | 20241119134429_rCHJk | NZ004X | 2024-11-20T14:05:56.358Z | 2024-11-22T14:20:09.261Z |
5555530 | 5555530 | 20241119134144_C5Uvk | NZ004X | 2024-11-20T14:05:55.361Z | 2024-11-22T14:20:09.108Z |
5555496 | 5555496 | 20241119133302_B6t3m | NZ004X | 2024-11-20T14:05:51.573Z | 2024-11-22T14:20:07.510Z |
5555484 | 5555484 | 20241119132850_tRYA3 | NZ004X | 2024-11-20T14:05:49.513Z | 2024-11-22T14:20:07.434Z |
5555471 | 5555471 | 20241119132458_CwWhg | NZ004X | 2024-11-20T14:05:43.009Z | 2024-11-22T14:20:06.921Z |
5555463 | 5555463 | 20241119132354_FmUpQ | NZ004X | 2024-11-20T14:05:42.148Z | 2024-11-22T14:20:06.853Z |
5555456 | 5555456 | 20241119132136_ee7EQ | NZ004X | 2024-11-20T14:05:40.784Z | 2024-11-21T14:18:53.280Z |
5555449 | 5555449 | 20241119131535_s0obA | NZ004X | 2024-11-20T14:05:39.422Z | 2024-11-22T14:20:06.556Z |
5555356 | 5555356 | 20241119125420_iy26f | NZ004X | 2024-11-20T14:05:16.392Z | 2024-11-22T14:20:04.664Z |
5555334 | 5555334 | 20241119124750_PKhzS | NZ004X | 2024-11-20T14:05:13.033Z | 2024-11-22T14:20:04.307Z |
5555292 | 5555292 | 20241119123548_1OXUq | NZ004X | 2024-11-20T14:05:06.824Z | 2024-11-22T14:20:03.218Z |
5555227 | 5555227 | 20241119121959_KBC3d | NZ004X | 2024-11-20T14:04:52.175Z | 2024-11-22T14:20:01.761Z |
5554499 | 5554499 | 20241119091833_5gIP6 | NZ004X | 2024-11-20T14:02:18.334Z | 2024-11-22T14:19:42.112Z |
5554429 | 5554429 | 20241119085543_9v9sl | NZ004X | 2024-11-20T14:02:00.655Z | 2024-11-22T14:19:40.560Z |
5551891 | 5551891 | 20241118153459_l2Hqo | NZ004X | 2024-11-19T14:05:46.465Z | 2024-11-22T14:22:12.917Z |
5551443 | 5551443 | 20241118133649_cCpDN | NZ004X | 2024-11-19T14:04:47.579Z | 2024-11-22T14:22:10.707Z |
5551407 | 5551407 | 20241118132707_FbJXq | NZ004X | 2024-11-19T14:04:44.459Z | 2024-11-22T14:22:10.535Z |
5551378 | 5551378 | 20241118131932_mUL2D | NZ004X | 2024-11-19T14:04:41.741Z | 2024-11-22T14:22:10.427Z |
5551373 | 5551373 | 20241118131903_NBesV | NZ004X | 2024-11-19T14:04:39.727Z | 2024-11-22T14:22:10.396Z |
5551368 | 5551368 | 20241118131619_p0cEN | NZ004X | 2024-11-19T14:04:37.451Z | 2024-11-22T14:22:10.361Z |
5551288 | 5551288 | 20241118125516_nsrcT | NZ004X | 2024-11-19T14:04:15.645Z | 2024-11-22T14:22:09.689Z |
5551147 | 5551147 | 20241118123305_U2l75 | NZ004X | 2024-11-19T14:03:59.448Z | 2024-11-22T14:22:08.700Z |
5551093 | 5551093 | 20241118122428_rmUB3 | NZ004X | 2024-11-19T14:03:53.990Z | 2024-11-22T14:22:08.206Z |
5551014 | 5551014 | 20241118120913_MCiZC | NZ004X | 2024-11-19T14:03:46.469Z | 2024-11-22T14:22:07.558Z |
5550955 | 5550955 | 20241118120216_gvzyY | NZ004X | 2024-11-19T14:03:36.732Z | 2024-11-22T14:22:07.068Z |
5550814 | 5550814 | 20241118113120_bPyye | NZ004X | 2024-11-19T14:03:09.347Z | 2024-11-22T14:22:05.905Z |
5550740 | 5550740 | 20241118111914_tCU4Z | NZ004X | 2024-11-19T14:03:00.069Z | 2024-11-22T14:22:05.264Z |
5550570 | 5550570 | 20241118104855_mx3fG | NZ004X | 2024-11-19T14:02:37.224Z | 2024-11-22T14:22:03.996Z |
5550327 | 5550327 | 20241118100752_oCJjW | NZ004X | 2024-11-19T14:02:11.778Z | 2024-11-22T14:22:01.448Z |
5550170 | 5550170 | 20241118094308_UvXA1 | NZ004X | 2024-11-19T14:01:40.742Z | 2024-11-22T14:21:59.193Z |
5547337 | 5547337 | 20241117154332_An29S | NZ004X | 2024-11-18T14:05:32.005Z | 2024-11-22T14:22:39.006Z |
5547282 | 5547282 | 20241117152448_NK3T0 | NZ004X | 2024-11-18T14:05:24.799Z | 2024-11-22T14:22:38.323Z |
5547250 | 5547250 | 20241117151600_DgYGU | NZ004X | 2024-11-18T14:05:21.385Z | 2024-11-22T14:22:38.206Z |
5547181 | 5547181 | 20241117150344_G1fzq | NZ004X | 2024-11-18T14:05:13.718Z | 2024-11-22T14:22:37.832Z |
5547173 | 5547173 | 20241117150336_RrsAn | NZ004X | 2024-11-18T14:05:13.582Z | 2024-11-22T14:22:37.828Z |
5547113 | 5547113 | 20241117144727_kEBau | NZ004X | 2024-11-18T14:05:05.177Z | 2024-11-22T14:22:37.125Z |
5547106 | 5547106 | 20241117144527_LGhTj | NZ004X | 2024-11-18T14:05:02.302Z | 2024-11-22T14:22:36.938Z |
5547063 | 5547063 | 20241117143101_DfQhn | NZ004X | 2024-11-18T14:04:52.463Z | 2024-11-22T14:22:36.624Z |
5547032 | 5547032 | 20241117142218_X35bd | NZ004X | 2024-11-18T14:04:44.678Z | 2024-11-22T14:22:36.556Z |
5546975 | 5546975 | 20241117134937_fhqMc | NZ004X | 2024-11-18T14:04:35.397Z | 2024-11-22T14:22:35.979Z |
5546917 | 5546917 | 20241117132316_cy7lt | NZ004X | 2024-11-18T14:04:27.349Z | 2024-11-22T14:22:35.415Z |
5546846 | 5546846 | 20241117130119_UmJv4 | NZ004X | 2024-11-18T14:04:20.510Z | 2024-11-22T14:22:34.971Z |
5546818 | 5546818 | 20241117124931_PCgnY | NZ004X | 2024-11-18T14:04:16.784Z | 2024-11-22T14:22:34.748Z |
5546617 | 5546617 | 20241117115638_Whida | NZ004X | 2024-11-18T14:03:39.724Z | 2024-11-22T14:22:33.407Z |
5546458 | 5546458 | 20241117110428_4fkAW | NZ004X | 2024-11-18T14:03:08.571Z | 2024-11-22T14:22:32.116Z |
5546230 | 5546230 | 20241117095716_3rU2Z | NZ004X | 2024-11-18T14:02:30.737Z | 2024-11-22T14:22:30.402Z |
5546192 | 5546192 | 20241117093913_dm2ay | NZ004X | 2024-11-18T14:02:24.862Z | 2024-11-22T14:22:29.924Z |
5544802 | 5544802 | 20241116153712_5l2E8 | NZ004X | 2024-11-17T14:02:09.312Z | 2024-11-22T14:23:06.312Z |
5544793 | 5544793 | 20241116152426_Ch2TD | NZ004X | 2024-11-17T14:02:07.186Z | 2024-11-22T14:23:06.294Z |
5544790 | 5544790 | 20241116152148_5YrIz | NZ004X | 2024-11-17T14:02:06.610Z | 2024-11-22T14:23:06.293Z |
5544760 | 5544760 | 20241116150409_w2yrp | NZ004X | 2024-11-17T14:02:01.491Z | 2024-11-22T14:23:06.158Z |
5544737 | 5544737 | 20241116145506_prIhR | NZ004X | 2024-11-17T14:01:58.232Z | 2024-11-22T14:23:05.958Z |
5520433 | 5520433 | 20241111154934_pl5hW | NZ004X | 2024-11-12T14:06:20.051Z | 2024-11-20T14:25:08.865Z |
5520414 | 5520414 | 20241111154055_M5TUi | NZ004X | 2024-11-12T14:06:16.546Z | 2024-11-20T14:25:08.585Z |
5520394 | 5520394 | 20241111153307_UuzuK | NZ004X | 2024-11-12T14:06:15.199Z | 2024-11-20T14:25:07.746Z |
5520325 | 5520325 | 20241111152202_8TiLV | NZ004X | 2024-11-12T14:06:09.200Z | 2024-11-20T14:25:06.762Z |
5520283 | 5520283 | 20241111151121_FrUzL | NZ004X | 2024-11-12T14:06:04.387Z | 2024-11-20T14:25:06.403Z |
5520266 | 5520266 | 20241111150951_varWj | NZ004X | 2024-11-12T14:06:03.064Z | 2024-11-20T14:25:06.351Z |
5520245 | 5520245 | 20241111150214_JhEn1 | NZ004X | 2024-11-12T14:06:01.200Z | 2024-11-20T14:25:06.264Z |
5520204 | 5520204 | 20241111145736_n127H | NZ004X | 2024-11-12T14:05:57.346Z | 2024-11-20T14:25:05.753Z |
5520178 | 5520178 | 20241111145405_w30Wq | NZ004X | 2024-11-12T14:05:49.530Z | 2024-11-20T14:25:05.385Z |
5520155 | 5520155 | 20241111144816_S8Be8 | NZ004X | 2024-11-12T14:05:45.447Z | 2024-11-20T14:25:04.658Z |
5520066 | 5520066 | 20241111142733_H2x3r | NZ004X | 2024-11-12T14:05:32.305Z | 2024-11-20T14:25:02.864Z |
5519970 | 5519970 | 20241111140648_jDhko | NZ004X | 2024-11-12T14:05:24.109Z | 2024-11-20T14:25:01.293Z |
5519941 | 5519941 | 20241111140013_yG2TE | NZ004X | 2024-11-12T14:05:21.232Z | 2024-11-20T14:25:00.933Z |
5519929 | 5519929 | 20241111135727_Cy0Yn | NZ004X | 2024-11-12T14:05:20.237Z | 2024-11-20T14:25:00.871Z |
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);