participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,804 rows where station_code = "NZ0045" 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 |
---|---|---|---|---|---|
5573274 | 5573274 | 20241119132136_B23nR | NZ0045 | 2024-11-22T14:20:06.770Z | 2024-11-22T14:20:06.770Z |
5560959 | 5560959 | 20241120152901_2lhcP | NZ0045 | 2024-11-21T14:10:05.778Z | 2024-11-22T14:19:21.771Z |
5560850 | 5560850 | 20241120145219_krNc6 | NZ0045 | 2024-11-21T14:09:52.133Z | 2024-11-22T14:19:21.746Z |
5560843 | 5560843 | 20241120144933_zsai9 | NZ0045 | 2024-11-21T14:09:51.040Z | 2024-11-22T14:19:21.744Z |
5560746 | 5560746 | 20241120141329_fCgEt | NZ0045 | 2024-11-21T14:09:41.967Z | 2024-11-22T14:19:21.726Z |
5560739 | 5560739 | 20241120141106_iKvm0 | NZ0045 | 2024-11-21T14:09:40.997Z | 2024-11-22T14:19:21.724Z |
5560734 | 5560734 | 20241120141105_xeKq2 | NZ0045 | 2024-11-21T14:09:40.557Z | 2024-11-22T14:19:21.724Z |
5560722 | 5560722 | 20241120140324_0SWBl | NZ0045 | 2024-11-21T14:09:35.906Z | 2024-11-22T14:19:21.720Z |
5560718 | 5560718 | 20241120140233_jHreh | NZ0045 | 2024-11-21T14:09:34.938Z | 2024-11-22T14:19:21.720Z |
5560709 | 5560709 | 20241120140045_XToNe | NZ0045 | 2024-11-21T14:09:33.375Z | 2024-11-22T14:19:21.718Z |
5560656 | 5560656 | 20241120134550_O15SL | NZ0045 | 2024-11-21T14:09:22.248Z | 2024-11-22T14:19:21.707Z |
5560600 | 5560600 | 20241120132040_RMJmF | NZ0045 | 2024-11-21T14:09:12.671Z | 2024-11-22T14:19:21.693Z |
5560545 | 5560545 | 20241120130803_NhfUG | NZ0045 | 2024-11-21T14:09:04.008Z | 2024-11-22T14:19:21.682Z |
5560501 | 5560501 | 20241120130107_WKAZH | NZ0045 | 2024-11-21T14:08:58.313Z | 2024-11-22T14:19:21.672Z |
5560438 | 5560438 | 20241120125205_LAZg7 | NZ0045 | 2024-11-21T14:08:51.545Z | 2024-11-22T14:19:21.658Z |
5560427 | 5560427 | 20241120125056_Ig13Z | NZ0045 | 2024-11-21T14:08:50.299Z | 2024-11-22T14:19:21.656Z |
5560274 | 5560274 | 20241120122910_dreIW | NZ0045 | 2024-11-21T14:08:28.385Z | 2024-11-22T14:19:21.626Z |
5560140 | 5560140 | 20241120120727_tw0Ul | NZ0045 | 2024-11-21T14:08:07.422Z | 2024-11-22T14:19:21.597Z |
5560093 | 5560093 | 20241120115759_Qp2JL | NZ0045 | 2024-11-21T14:08:01.896Z | 2024-11-22T14:19:21.586Z |
5559882 | 5559882 | 20241120112939_2F38o | NZ0045 | 2024-11-21T14:07:27.127Z | 2024-11-22T14:19:21.543Z |
5559769 | 5559769 | 20241120111518_cGeur | NZ0045 | 2024-11-21T14:07:09.399Z | 2024-11-22T14:19:21.521Z |
5559630 | 5559630 | 20241120105202_TIVgU | NZ0045 | 2024-11-21T14:06:47.716Z | 2024-11-22T14:19:21.489Z |
5559623 | 5559623 | 20241120105131_g7r8H | NZ0045 | 2024-11-21T14:06:46.111Z | 2024-11-22T14:19:21.488Z |
5559546 | 5559546 | 20241120103954_fHWpk | NZ0045 | 2024-11-21T14:06:34.637Z | 2024-11-22T14:19:21.470Z |
5555726 | 5555726 | 20241119150218_XZv2o | NZ0045 | 2024-11-20T14:06:29.147Z | 2024-11-22T14:20:13.061Z |
5555712 | 5555712 | 20241119145631_fCTZV | NZ0045 | 2024-11-20T14:06:27.656Z | 2024-11-22T14:20:12.693Z |
5555661 | 5555661 | 20241119142415_CLJJM | NZ0045 | 2024-11-20T14:06:21.292Z | 2024-11-22T14:20:11.883Z |
5555590 | 5555590 | 20241119135930_joalQ | NZ0045 | 2024-11-20T14:06:03.586Z | 2024-11-22T14:20:10.571Z |
5555555 | 5555555 | 20241119135057_uiIpx | NZ0045 | 2024-11-20T14:05:58.760Z | 2024-11-22T14:20:09.651Z |
5555544 | 5555544 | 20241119134721_ZgChy | NZ0045 | 2024-11-20T14:05:56.823Z | 2024-11-22T14:20:09.322Z |
5555541 | 5555541 | 20241119134429_rCHJk | NZ0045 | 2024-11-20T14:05:56.358Z | 2024-11-22T14:20:09.261Z |
5555528 | 5555528 | 20241119134144_C5Uvk | NZ0045 | 2024-11-20T14:05:55.361Z | 2024-11-22T14:20:09.108Z |
5555495 | 5555495 | 20241119133302_B6t3m | NZ0045 | 2024-11-20T14:05:51.573Z | 2024-11-22T14:20:07.510Z |
5555483 | 5555483 | 20241119132850_tRYA3 | NZ0045 | 2024-11-20T14:05:49.513Z | 2024-11-22T14:20:07.434Z |
5555469 | 5555469 | 20241119132458_CwWhg | NZ0045 | 2024-11-20T14:05:43.009Z | 2024-11-22T14:20:06.921Z |
5555462 | 5555462 | 20241119132354_FmUpQ | NZ0045 | 2024-11-20T14:05:42.148Z | 2024-11-22T14:20:06.853Z |
5555455 | 5555455 | 20241119132136_ee7EQ | NZ0045 | 2024-11-20T14:05:40.784Z | 2024-11-21T14:18:53.280Z |
5555453 | 5555453 | 20241119132106_iznYU | NZ0045 | 2024-11-20T14:05:40.274Z | 2024-11-22T14:20:06.675Z |
5555448 | 5555448 | 20241119131535_s0obA | NZ0045 | 2024-11-20T14:05:39.422Z | 2024-11-22T14:20:06.556Z |
5555443 | 5555443 | 20241119131504_yews8 | NZ0045 | 2024-11-20T14:05:38.445Z | 2024-11-22T14:20:06.510Z |
5555417 | 5555417 | 20241119130810_skGfI | NZ0045 | 2024-11-20T14:05:35.022Z | 2024-11-22T14:20:05.712Z |
5555355 | 5555355 | 20241119125420_iy26f | NZ0045 | 2024-11-20T14:05:16.392Z | 2024-11-22T14:20:04.664Z |
5555290 | 5555290 | 20241119123548_1OXUq | NZ0045 | 2024-11-20T14:05:06.824Z | 2024-11-22T14:20:03.218Z |
5555225 | 5555225 | 20241119121959_KBC3d | NZ0045 | 2024-11-20T14:04:52.175Z | 2024-11-22T14:20:01.761Z |
5554498 | 5554498 | 20241119091833_5gIP6 | NZ0045 | 2024-11-20T14:02:18.334Z | 2024-11-22T14:19:42.111Z |
5554427 | 5554427 | 20241119085543_9v9sl | NZ0045 | 2024-11-20T14:02:00.655Z | 2024-11-22T14:19:40.560Z |
5551405 | 5551405 | 20241118132707_FbJXq | NZ0045 | 2024-11-19T14:04:44.459Z | 2024-11-22T14:22:10.535Z |
5551377 | 5551377 | 20241118131932_mUL2D | NZ0045 | 2024-11-19T14:04:41.741Z | 2024-11-22T14:22:10.427Z |
5551371 | 5551371 | 20241118131903_NBesV | NZ0045 | 2024-11-19T14:04:39.727Z | 2024-11-22T14:22:10.396Z |
5551367 | 5551367 | 20241118131619_p0cEN | NZ0045 | 2024-11-19T14:04:37.451Z | 2024-11-22T14:22:10.361Z |
5551356 | 5551356 | 20241118131104_iv87e | NZ0045 | 2024-11-19T14:04:34.782Z | 2024-11-22T14:22:10.327Z |
5551287 | 5551287 | 20241118125516_nsrcT | NZ0045 | 2024-11-19T14:04:15.645Z | 2024-11-22T14:22:09.689Z |
5551181 | 5551181 | 20241118124029_P9mVl | NZ0045 | 2024-11-19T14:04:03.784Z | 2024-11-22T14:22:09.003Z |
5551146 | 5551146 | 20241118123305_U2l75 | NZ0045 | 2024-11-19T14:03:59.448Z | 2024-11-22T14:22:08.700Z |
5551013 | 5551013 | 20241118120913_MCiZC | NZ0045 | 2024-11-19T14:03:46.469Z | 2024-11-22T14:22:07.558Z |
5550954 | 5550954 | 20241118120216_gvzyY | NZ0045 | 2024-11-19T14:03:36.732Z | 2024-11-22T14:22:07.068Z |
5550569 | 5550569 | 20241118104855_mx3fG | NZ0045 | 2024-11-19T14:02:37.224Z | 2024-11-22T14:22:03.996Z |
5550325 | 5550325 | 20241118100752_oCJjW | NZ0045 | 2024-11-19T14:02:11.778Z | 2024-11-22T14:22:01.447Z |
5550214 | 5550214 | 20241118094625_kwsbL | NZ0045 | 2024-11-19T14:01:46.640Z | 2024-11-22T14:21:59.725Z |
5550168 | 5550168 | 20241118094308_UvXA1 | NZ0045 | 2024-11-19T14:01:40.742Z | 2024-11-22T14:21:59.193Z |
5547336 | 5547336 | 20241117154332_An29S | NZ0045 | 2024-11-18T14:05:32.005Z | 2024-11-22T14:22:39.006Z |
5547281 | 5547281 | 20241117152448_NK3T0 | NZ0045 | 2024-11-18T14:05:24.799Z | 2024-11-22T14:22:38.323Z |
5547200 | 5547200 | 20241117150458_HjEyT | NZ0045 | 2024-11-18T14:05:16.044Z | 2024-11-22T14:22:37.894Z |
5547180 | 5547180 | 20241117150344_G1fzq | NZ0045 | 2024-11-18T14:05:13.718Z | 2024-11-22T14:22:37.832Z |
5547003 | 5547003 | 20241117140750_q7fw0 | NZ0045 | 2024-11-18T14:04:41.187Z | 2024-11-22T14:22:36.324Z |
5546974 | 5546974 | 20241117134937_fhqMc | NZ0045 | 2024-11-18T14:04:35.397Z | 2024-11-22T14:22:35.979Z |
5546915 | 5546915 | 20241117132316_cy7lt | NZ0045 | 2024-11-18T14:04:27.349Z | 2024-11-22T14:22:35.415Z |
5546816 | 5546816 | 20241117124931_PCgnY | NZ0045 | 2024-11-18T14:04:16.784Z | 2024-11-22T14:22:34.748Z |
5546785 | 5546785 | 20241117124308_l3P58 | NZ0045 | 2024-11-18T14:04:13.883Z | 2024-11-22T14:22:34.610Z |
5546517 | 5546517 | 20241117112345_vFbUb | NZ0045 | 2024-11-18T14:03:16.682Z | 2024-11-22T14:22:32.387Z |
5546457 | 5546457 | 20241117110428_4fkAW | NZ0045 | 2024-11-18T14:03:08.571Z | 2024-11-22T14:22:32.116Z |
5546229 | 5546229 | 20241117095716_3rU2Z | NZ0045 | 2024-11-18T14:02:30.737Z | 2024-11-22T14:22:30.402Z |
5546191 | 5546191 | 20241117093913_dm2ay | NZ0045 | 2024-11-18T14:02:24.862Z | 2024-11-22T14:22:29.924Z |
5546112 | 5546112 | 20241117091632_R1T5D | NZ0045 | 2024-11-18T14:02:06.438Z | 2024-11-22T14:22:29.195Z |
5546083 | 5546083 | 20241117090645_Hsxih | NZ0045 | 2024-11-18T14:01:58.526Z | 2024-11-22T14:22:28.869Z |
5544808 | 5544808 | 20241116153903_WB3cw | NZ0045 | 2024-11-17T14:02:10.122Z | 2024-11-22T14:23:06.314Z |
5544789 | 5544789 | 20241116152148_5YrIz | NZ0045 | 2024-11-17T14:02:06.610Z | 2024-11-22T14:23:06.293Z |
5544759 | 5544759 | 20241116150409_w2yrp | NZ0045 | 2024-11-17T14:02:01.491Z | 2024-11-22T14:23:06.158Z |
5544755 | 5544755 | 20241116150352_Zvh1D | NZ0045 | 2024-11-17T14:02:01.109Z | 2024-11-22T14:23:06.151Z |
5544736 | 5544736 | 20241116145506_prIhR | NZ0045 | 2024-11-17T14:01:58.232Z | 2024-11-22T14:23:05.958Z |
5536106 | 5536106 | 20241112154033_3gB8T | NZ0045 | 2024-11-14T14:09:11.870Z | 2024-11-21T14:25:56.725Z |
5536009 | 5536009 | 20241112151719_rOC2a | NZ0045 | 2024-11-14T14:09:05.947Z | 2024-11-21T14:25:56.075Z |
5520412 | 5520412 | 20241111154055_M5TUi | NZ0045 | 2024-11-12T14:06:16.546Z | 2024-11-20T14:25:08.585Z |
5520393 | 5520393 | 20241111153307_UuzuK | NZ0045 | 2024-11-12T14:06:15.199Z | 2024-11-20T14:25:07.746Z |
5520324 | 5520324 | 20241111152202_8TiLV | NZ0045 | 2024-11-12T14:06:09.200Z | 2024-11-20T14:25:06.761Z |
5520281 | 5520281 | 20241111151121_FrUzL | NZ0045 | 2024-11-12T14:06:04.387Z | 2024-11-20T14:25:06.403Z |
5520264 | 5520264 | 20241111150951_varWj | NZ0045 | 2024-11-12T14:06:03.064Z | 2024-11-20T14:25:06.351Z |
5520243 | 5520243 | 20241111150214_JhEn1 | NZ0045 | 2024-11-12T14:06:01.200Z | 2024-11-20T14:25:06.264Z |
5520218 | 5520218 | 20241111145839_uzkip | NZ0045 | 2024-11-12T14:05:58.655Z | 2024-11-20T14:25:05.845Z |
5520202 | 5520202 | 20241111145736_n127H | NZ0045 | 2024-11-12T14:05:57.345Z | 2024-11-20T14:25:05.753Z |
5520176 | 5520176 | 20241111145405_w30Wq | NZ0045 | 2024-11-12T14:05:49.530Z | 2024-11-20T14:25:05.385Z |
5520153 | 5520153 | 20241111144816_S8Be8 | NZ0045 | 2024-11-12T14:05:45.447Z | 2024-11-20T14:25:04.658Z |
5520064 | 5520064 | 20241111142733_H2x3r | NZ0045 | 2024-11-12T14:05:32.305Z | 2024-11-20T14:25:02.864Z |
5520032 | 5520032 | 20241111142538_8uto2 | NZ0045 | 2024-11-12T14:05:29.630Z | 2024-11-20T14:25:02.545Z |
5519959 | 5519959 | 20241111140607_TcBAu | NZ0045 | 2024-11-12T14:05:23.103Z | 2024-11-20T14:25:01.228Z |
5519928 | 5519928 | 20241111135727_Cy0Yn | NZ0045 | 2024-11-12T14:05:20.237Z | 2024-11-20T14:25:00.870Z |
5519914 | 5519914 | 20241111135436_F2m2n | NZ0045 | 2024-11-12T14:05:19.166Z | 2024-11-20T14:25:00.624Z |
5519894 | 5519894 | 20241111135023_qWDNe | NZ0045 | 2024-11-12T14:05:17.769Z | 2024-11-20T14:25:00.489Z |
5519877 | 5519877 | 20241111134402_h2Y5U | NZ0045 | 2024-11-12T14:05:14.939Z | 2024-11-20T14:25:00.385Z |
5519849 | 5519849 | 20241111133357_LKSgP | NZ0045 | 2024-11-12T14:05:10.709Z | 2024-11-20T14:24:59.856Z |
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);