participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,842 rows where station_code = "NZ004D" 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 |
---|---|---|---|---|---|
5597566 | 5597566 | 20241124154014_8Utfq | NZ004D | 2024-11-25T14:11:37.999Z | 2024-11-25T14:11:37.999Z |
5597451 | 5597451 | 20241124152457_legGv | NZ004D | 2024-11-25T14:11:29.746Z | 2024-11-25T14:11:29.746Z |
5597278 | 5597278 | 20241124151503_EYnNR | NZ004D | 2024-11-25T14:11:20.314Z | 2024-11-25T14:11:20.314Z |
5596894 | 5596894 | 20241124144342_vpJFi | NZ004D | 2024-11-25T14:10:45.470Z | 2024-11-25T14:10:45.470Z |
5596815 | 5596815 | 20241124142956_WtSgJ | NZ004D | 2024-11-25T14:10:37.226Z | 2024-11-25T14:10:37.226Z |
5596782 | 5596782 | 20241124142623_NroNZ | NZ004D | 2024-11-25T14:10:34.476Z | 2024-11-25T14:10:34.476Z |
5596498 | 5596498 | 20241124135704_6iqME | NZ004D | 2024-11-25T14:10:10.337Z | 2024-11-25T14:10:10.337Z |
5596495 | 5596495 | 20241124135641_sdpIv | NZ004D | 2024-11-25T14:10:09.750Z | 2024-11-25T14:10:09.750Z |
5596490 | 5596490 | 20241124135640_BYaJX | NZ004D | 2024-11-25T14:10:09.242Z | 2024-11-25T14:10:09.242Z |
5596471 | 5596471 | 20241124135429_Mbr6i | NZ004D | 2024-11-25T14:10:03.234Z | 2024-11-25T14:10:03.234Z |
5596427 | 5596427 | 20241124135108_D7m3h | NZ004D | 2024-11-25T14:09:58.333Z | 2024-11-25T14:09:58.333Z |
5596370 | 5596370 | 20241124134244_2Xnkj | NZ004D | 2024-11-25T14:09:53.601Z | 2024-11-25T14:09:53.601Z |
5596276 | 5596276 | 20241124133137_QFf3b | NZ004D | 2024-11-25T14:09:44.954Z | 2024-11-25T14:09:44.954Z |
5596273 | 5596273 | 20241124133125_JsrL3 | NZ004D | 2024-11-25T14:09:44.593Z | 2024-11-25T14:09:44.593Z |
5596158 | 5596158 | 20241124132134_lMbES | NZ004D | 2024-11-25T14:09:35.107Z | 2024-11-25T14:09:35.107Z |
5595915 | 5595915 | 20241124125839_642RI | NZ004D | 2024-11-25T14:09:09.326Z | 2024-11-25T14:09:09.326Z |
5595650 | 5595650 | 20241124123657_gePoA | NZ004D | 2024-11-25T14:08:39.503Z | 2024-11-25T14:08:39.503Z |
5595642 | 5595642 | 20241124123626_n140L | NZ004D | 2024-11-25T14:08:39.047Z | 2024-11-25T14:08:39.047Z |
5595559 | 5595559 | 20241124123223_ib0GK | NZ004D | 2024-11-25T14:08:32.450Z | 2024-11-25T14:08:32.450Z |
5595540 | 5595540 | 20241124122916_VKWsN | NZ004D | 2024-11-25T14:08:29.553Z | 2024-11-25T14:08:29.553Z |
5595396 | 5595396 | 20241124121312_aBYP9 | NZ004D | 2024-11-25T14:08:07.170Z | 2024-11-25T14:08:07.170Z |
5595289 | 5595289 | 20241124120251_X4Xxg | NZ004D | 2024-11-25T14:07:54.590Z | 2024-11-25T14:07:54.590Z |
5595182 | 5595182 | 20241124115201_w32n2 | NZ004D | 2024-11-25T14:07:43.497Z | 2024-11-25T14:07:43.497Z |
5595088 | 5595088 | 20241124114052_b1rDB | NZ004D | 2024-11-25T14:07:21.636Z | 2024-11-25T14:07:21.636Z |
5594958 | 5594958 | 20241124112325_JoQPs | NZ004D | 2024-11-25T14:07:02.251Z | 2024-11-25T14:07:02.251Z |
5594750 | 5594750 | 20241124110229_rE6L2 | NZ004D | 2024-11-25T14:06:28.078Z | 2024-11-25T14:06:28.078Z |
5594658 | 5594658 | 20241124105636_4YCxD | NZ004D | 2024-11-25T14:06:18.426Z | 2024-11-25T14:06:18.426Z |
5594654 | 5594654 | 20241124105607_6eMw9 | NZ004D | 2024-11-25T14:06:18.059Z | 2024-11-25T14:06:18.059Z |
5594598 | 5594598 | 20241124105245_vbQv8 | NZ004D | 2024-11-25T14:06:13.566Z | 2024-11-25T14:06:13.566Z |
5594457 | 5594457 | 20241124102935_IcrLj | NZ004D | 2024-11-25T14:05:46.593Z | 2024-11-25T14:05:46.593Z |
5594355 | 5594355 | 20241124101925_kmR2d | NZ004D | 2024-11-25T14:05:30.792Z | 2024-11-25T14:05:30.792Z |
5593875 | 5593875 | 20241124090209_jJH2P | NZ004D | 2024-11-25T14:03:59.093Z | 2024-11-25T14:03:59.093Z |
5583967 | 5583967 | 20241117090645_oH5VD | NZ004D | 2024-11-23T14:25:15.662Z | 2024-11-25T14:22:22.285Z |
5582958 | 5582958 | 20241120101342_n0f3c | NZ004D | 2024-11-23T14:22:15.132Z | 2024-11-25T14:21:03.015Z |
5560740 | 5560740 | 20241120141106_iKvm0 | NZ004D | 2024-11-21T14:09:40.997Z | 2024-11-25T14:21:07.679Z |
5560657 | 5560657 | 20241120134550_O15SL | NZ004D | 2024-11-21T14:09:22.248Z | 2024-11-25T14:21:07.475Z |
5560601 | 5560601 | 20241120132040_RMJmF | NZ004D | 2024-11-21T14:09:12.671Z | 2024-11-25T14:21:07.364Z |
5560587 | 5560587 | 20241120131801_UF2je | NZ004D | 2024-11-21T14:09:09.857Z | 2024-11-25T14:21:07.343Z |
5560568 | 5560568 | 20241120131038_Xm0RH | NZ004D | 2024-11-21T14:09:06.404Z | 2024-11-25T14:21:07.203Z |
5560275 | 5560275 | 20241120122910_dreIW | NZ004D | 2024-11-21T14:08:28.385Z | 2024-11-25T14:21:06.105Z |
5560094 | 5560094 | 20241120115759_Qp2JL | NZ004D | 2024-11-21T14:08:01.896Z | 2024-11-25T14:21:05.143Z |
5559961 | 5559961 | 20241120113913_DUWY7 | NZ004D | 2024-11-21T14:07:41.834Z | 2024-11-25T14:21:04.805Z |
5559883 | 5559883 | 20241120112939_2F38o | NZ004D | 2024-11-21T14:07:27.127Z | 2024-11-25T14:21:04.613Z |
5559777 | 5559777 | 20241120111652_lIuU8 | NZ004D | 2024-11-21T14:07:10.531Z | 2024-11-25T14:21:04.306Z |
5559776 | 5559776 | 20241120111642_3xSIm | NZ004D | 2024-11-21T14:07:10.223Z | 2024-11-25T14:21:04.305Z |
5559631 | 5559631 | 20241120105202_TIVgU | NZ004D | 2024-11-21T14:06:47.716Z | 2024-11-25T14:21:03.682Z |
5559624 | 5559624 | 20241120105131_g7r8H | NZ004D | 2024-11-21T14:06:46.111Z | 2024-11-25T14:21:03.647Z |
5559378 | 5559378 | 20241120101322_ieZI0 | NZ004D | 2024-11-21T14:06:11.836Z | 2024-11-25T14:21:02.992Z |
5559103 | 5559103 | 20241120092430_QAwvQ | NZ004D | 2024-11-21T14:05:22.195Z | 2024-11-25T14:21:02.009Z |
5555727 | 5555727 | 20241119150218_XZv2o | NZ004D | 2024-11-20T14:06:29.147Z | 2024-11-25T14:21:44.139Z |
5555718 | 5555718 | 20241119145833_vJ05j | NZ004D | 2024-11-20T14:06:28.245Z | 2024-11-25T14:21:44.136Z |
5555713 | 5555713 | 20241119145631_fCTZV | NZ004D | 2024-11-20T14:06:27.656Z | 2024-11-25T14:21:44.117Z |
5555635 | 5555635 | 20241119141214_FU07w | NZ004D | 2024-11-20T14:06:11.767Z | 2024-11-25T14:21:43.913Z |
5555591 | 5555591 | 20241119135930_joalQ | NZ004D | 2024-11-20T14:06:03.586Z | 2024-11-25T14:21:43.787Z |
5555559 | 5555559 | 20241119135213_lqnIq | NZ004D | 2024-11-20T14:05:59.243Z | 2024-11-25T14:21:43.739Z |
5555529 | 5555529 | 20241119134144_C5Uvk | NZ004D | 2024-11-20T14:05:55.361Z | 2024-11-25T14:21:43.687Z |
5555470 | 5555470 | 20241119132458_CwWhg | NZ004D | 2024-11-20T14:05:43.009Z | 2024-11-25T14:21:43.591Z |
5555444 | 5555444 | 20241119131504_yews8 | NZ004D | 2024-11-20T14:05:38.445Z | 2024-11-25T14:21:43.564Z |
5555402 | 5555402 | 20241119130339_3J2nY | NZ004D | 2024-11-20T14:05:29.928Z | 2024-11-25T14:21:43.470Z |
5555298 | 5555298 | 20241119123620_qEZPI | NZ004D | 2024-11-20T14:05:07.183Z | 2024-11-25T14:21:43.238Z |
5555291 | 5555291 | 20241119123548_1OXUq | NZ004D | 2024-11-20T14:05:06.824Z | 2024-11-25T14:21:43.232Z |
5555226 | 5555226 | 20241119121959_KBC3d | NZ004D | 2024-11-20T14:04:52.175Z | 2024-11-25T14:21:43.077Z |
5555172 | 5555172 | 20241119120058_a2Gry | NZ004D | 2024-11-20T14:04:38.515Z | 2024-11-25T14:21:42.925Z |
5554428 | 5554428 | 20241119085543_9v9sl | NZ004D | 2024-11-20T14:02:00.655Z | 2024-11-25T14:21:40.139Z |
5551555 | 5551555 | 20241118141231_hjZvp | NZ004D | 2024-11-19T14:04:59.375Z | 2024-11-25T14:22:14.407Z |
5551418 | 5551418 | 20241118133058_byzyk | NZ004D | 2024-11-19T14:04:45.675Z | 2024-11-25T14:22:14.214Z |
5551406 | 5551406 | 20241118132707_FbJXq | NZ004D | 2024-11-19T14:04:44.459Z | 2024-11-25T14:22:14.209Z |
5551395 | 5551395 | 20241118132510_haubB | NZ004D | 2024-11-19T14:04:43.990Z | 2024-11-25T14:22:14.207Z |
5551372 | 5551372 | 20241118131903_NBesV | NZ004D | 2024-11-19T14:04:39.727Z | 2024-11-25T14:22:14.198Z |
5551182 | 5551182 | 20241118124029_P9mVl | NZ004D | 2024-11-19T14:04:03.784Z | 2024-11-25T14:22:13.884Z |
5551092 | 5551092 | 20241118122428_rmUB3 | NZ004D | 2024-11-19T14:03:53.990Z | 2024-11-25T14:22:13.509Z |
5550924 | 5550924 | 20241118115000_UktmI | NZ004D | 2024-11-19T14:03:29.417Z | 2024-11-25T14:22:13.049Z |
5550866 | 5550866 | 20241118113904_3gbwC | NZ004D | 2024-11-19T14:03:14.259Z | 2024-11-25T14:22:12.857Z |
5550813 | 5550813 | 20241118113120_bPyye | NZ004D | 2024-11-19T14:03:09.347Z | 2024-11-25T14:22:12.597Z |
5550608 | 5550608 | 20241118105542_gWKU5 | NZ004D | 2024-11-19T14:02:48.289Z | 2024-11-25T14:22:11.893Z |
5550397 | 5550397 | 20241118101639_JOO12 | NZ004D | 2024-11-19T14:02:17.057Z | 2024-11-25T14:22:11.484Z |
5550326 | 5550326 | 20241118100752_oCJjW | NZ004D | 2024-11-19T14:02:11.778Z | 2024-11-25T14:22:11.356Z |
5550169 | 5550169 | 20241118094308_UvXA1 | NZ004D | 2024-11-19T14:01:40.742Z | 2024-11-25T14:22:10.804Z |
5546916 | 5546916 | 20241117132316_cy7lt | NZ004D | 2024-11-18T14:04:27.349Z | 2024-11-25T14:22:24.587Z |
5546817 | 5546817 | 20241117124931_PCgnY | NZ004D | 2024-11-18T14:04:16.784Z | 2024-11-25T14:22:24.236Z |
5546772 | 5546772 | 20241117124012_Zl3zX | NZ004D | 2024-11-18T14:04:12.312Z | 2024-11-25T14:22:24.199Z |
5546648 | 5546648 | 20241117120255_0FUJR | NZ004D | 2024-11-18T14:03:43.930Z | 2024-11-25T14:22:23.858Z |
5546518 | 5546518 | 20241117112345_vFbUb | NZ004D | 2024-11-18T14:03:16.682Z | 2024-11-25T14:22:23.525Z |
5546462 | 5546462 | 20241117110546_Wqtep | NZ004D | 2024-11-18T14:03:08.979Z | 2024-11-25T14:22:23.450Z |
5546113 | 5546113 | 20241117091632_R1T5D | NZ004D | 2024-11-18T14:02:06.438Z | 2024-11-25T14:22:22.381Z |
5546084 | 5546084 | 20241117090645_Hsxih | NZ004D | 2024-11-18T14:01:58.526Z | 2024-11-22T14:22:28.869Z |
5544801 | 5544801 | 20241116153712_5l2E8 | NZ004D | 2024-11-17T14:02:09.312Z | 2024-11-25T14:22:40.349Z |
5536108 | 5536108 | 20241112154033_3gB8T | NZ004D | 2024-11-14T14:09:11.870Z | 2024-11-21T14:25:56.725Z |
5536063 | 5536063 | 20241112153227_7Tb53 | NZ004D | 2024-11-14T14:09:09.651Z | 2024-11-21T14:25:56.447Z |
5536023 | 5536023 | 20241112152357_bOdYU | NZ004D | 2024-11-14T14:09:07.075Z | 2024-11-21T14:25:56.176Z |
5535880 | 5535880 | 20241112144005_dgXY2 | NZ004D | 2024-11-14T14:08:56.559Z | 2024-11-21T14:25:54.221Z |
5535832 | 5535832 | 20241112143505_wTfcY | NZ004D | 2024-11-14T14:08:53.212Z | 2024-11-21T14:25:53.702Z |
5520413 | 5520413 | 20241111154055_M5TUi | NZ004D | 2024-11-12T14:06:16.546Z | 2024-11-20T14:25:08.585Z |
5520350 | 5520350 | 20241111152656_3e8uH | NZ004D | 2024-11-12T14:06:11.756Z | 2024-11-20T14:25:07.279Z |
5520306 | 5520306 | 20241111151658_uvnyc | NZ004D | 2024-11-12T14:06:07.485Z | 2024-11-20T14:25:06.636Z |
5520290 | 5520290 | 20241111151333_Qsrpf | NZ004D | 2024-11-12T14:06:05.531Z | 2024-11-20T14:25:06.452Z |
5520282 | 5520282 | 20241111151121_FrUzL | NZ004D | 2024-11-12T14:06:04.387Z | 2024-11-20T14:25:06.403Z |
5520265 | 5520265 | 20241111150951_varWj | NZ004D | 2024-11-12T14:06:03.064Z | 2024-11-20T14:25:06.351Z |
5520244 | 5520244 | 20241111150214_JhEn1 | NZ004D | 2024-11-12T14:06:01.200Z | 2024-11-20T14:25:06.264Z |
5520203 | 5520203 | 20241111145736_n127H | NZ004D | 2024-11-12T14:05:57.345Z | 2024-11-20T14:25:05.753Z |
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);