participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,719 rows where station_code = "NZ0041" 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 |
---|---|---|---|---|---|
5137092 | 5137092 | 20240919075506_SR2W9 | NZ0041 | 2024-09-20T12:03:49.859Z | 2024-09-20T12:06:55.061Z |
5137084 | 5137084 | 20240919075327_RYKeq | NZ0041 | 2024-09-20T12:03:49.045Z | 2024-09-20T12:06:55.059Z |
5135250 | 5135250 | 20240916171849_JbDDp | NZ0041 | 2024-09-19T12:18:17.223Z | 2024-09-20T12:14:46.472Z |
5135234 | 5135234 | 20240916171256_xehCx | NZ0041 | 2024-09-19T12:18:16.995Z | 2024-09-20T12:14:46.279Z |
5135101 | 5135101 | 20240916162012_JLDXE | NZ0041 | 2024-09-19T12:18:14.625Z | 2024-09-20T12:14:44.469Z |
5135053 | 5135053 | 20240916154539_4SPJU | NZ0041 | 2024-09-19T12:18:13.516Z | 2024-09-20T12:14:43.629Z |
5135035 | 5135035 | 20240916153600_VI2Sk | NZ0041 | 2024-09-19T12:18:13.207Z | 2024-09-20T12:14:43.327Z |
5135005 | 5135005 | 20240916151547_DjLOS | NZ0041 | 2024-09-19T12:18:12.400Z | 2024-09-20T12:14:42.741Z |
5135001 | 5135001 | 20240916151528_GX2FY | NZ0041 | 2024-09-19T12:18:12.305Z | 2024-09-20T12:14:42.691Z |
5134995 | 5134995 | 20240916151157_2M3wU | NZ0041 | 2024-09-19T12:18:12.188Z | 2024-09-20T12:14:42.597Z |
5134993 | 5134993 | 20240916150929_oV741 | NZ0041 | 2024-09-19T12:18:12.164Z | 2024-09-20T12:14:42.582Z |
5134987 | 5134987 | 20240916150417_tlsrC | NZ0041 | 2024-09-19T12:18:11.979Z | 2024-09-20T12:14:42.499Z |
5130963 | 5130963 | 20240917170316_KLK2D | NZ0041 | 2024-09-19T12:14:01.555Z | 2024-09-20T12:12:12.281Z |
5130915 | 5130915 | 20240917162824_ltman | NZ0041 | 2024-09-19T12:13:58.568Z | 2024-09-20T12:12:11.143Z |
5130864 | 5130864 | 20240917155843_UScVX | NZ0041 | 2024-09-19T12:13:54.348Z | 2024-09-20T12:12:09.626Z |
5130792 | 5130792 | 20240917152235_2xJEw | NZ0041 | 2024-09-19T12:13:50.233Z | 2024-09-20T12:12:08.220Z |
5130788 | 5130788 | 20240917152225_GE81T | NZ0041 | 2024-09-19T12:13:50.090Z | 2024-09-20T12:12:08.154Z |
5118823 | 5118823 | 20240915111612_wSrju | NZ0041 | 2024-09-18T12:09:05.079Z | 2024-09-20T12:17:39.937Z |
5118404 | 5118404 | 20240915093809_L4Uq3 | NZ0041 | 2024-09-18T12:08:42.596Z | 2024-09-20T12:17:29.745Z |
5109033 | 5109033 | 20240913083052_PWXGp | NZ0041 | 2024-09-17T12:14:26.780Z | 2024-09-20T12:20:58.746Z |
5083687 | 5083687 | 20240911141056_cY5lM | NZ0041 | 2024-09-15T12:18:45.495Z | 2024-09-19T12:21:49.799Z |
5083643 | 5083643 | 20240911140255_lcEbS | NZ0041 | 2024-09-15T12:18:44.975Z | 2024-09-19T12:21:49.744Z |
5083620 | 5083620 | 20240911135800_LulOC | NZ0041 | 2024-09-15T12:18:44.619Z | 2024-09-19T12:21:49.725Z |
5083586 | 5083586 | 20240911135339_Vcuut | NZ0041 | 2024-09-15T12:18:44.242Z | 2024-09-19T12:21:49.700Z |
5083565 | 5083565 | 20240911134958_S2ZQ2 | NZ0041 | 2024-09-15T12:18:43.989Z | 2024-09-19T12:21:49.685Z |
5083551 | 5083551 | 20240911134705_K7AlT | NZ0041 | 2024-09-15T12:18:43.667Z | 2024-09-19T12:21:49.663Z |
5083520 | 5083520 | 20240911134046_QlhfR | NZ0041 | 2024-09-15T12:18:43.144Z | 2024-09-19T12:21:49.617Z |
5083512 | 5083512 | 20240911134004_CdvQH | NZ0041 | 2024-09-15T12:18:43.020Z | 2024-09-19T12:21:49.615Z |
5083464 | 5083464 | 20240911132553_fsly3 | NZ0041 | 2024-09-15T12:18:42.281Z | 2024-09-19T12:21:49.591Z |
5083427 | 5083427 | 20240911131644_LHqmp | NZ0041 | 2024-09-15T12:18:41.904Z | 2024-09-19T12:21:49.578Z |
5083415 | 5083415 | 20240911131335_ALqO2 | NZ0041 | 2024-09-15T12:18:41.690Z | 2024-09-19T12:21:49.566Z |
5083322 | 5083322 | 20240911125427_d33Iy | NZ0041 | 2024-09-15T12:18:38.829Z | 2024-09-19T12:21:49.479Z |
5083214 | 5083214 | 20240911122909_KZgZn | NZ0041 | 2024-09-15T12:18:37.019Z | 2024-09-19T12:21:49.376Z |
5083091 | 5083091 | 20240911115551_yq5dK | NZ0041 | 2024-09-15T12:18:35.244Z | 2024-09-19T12:21:49.279Z |
5082836 | 5082836 | 20240911111116_O71P6 | NZ0041 | 2024-09-15T12:18:26.996Z | 2024-09-19T12:21:48.753Z |
5082732 | 5082732 | 20240911105021_7W9IK | NZ0041 | 2024-09-15T12:18:24.016Z | 2024-09-19T12:21:48.490Z |
5082576 | 5082576 | 20240911102824_eOVIu | NZ0041 | 2024-09-15T12:18:20.317Z | 2024-09-19T12:21:48.118Z |
5082483 | 5082483 | 20240911101449_NQ26a | NZ0041 | 2024-09-15T12:18:16.108Z | 2024-09-19T12:21:47.987Z |
5082464 | 5082464 | 20240911101110_dcnsN | NZ0041 | 2024-09-15T12:18:15.494Z | 2024-09-19T12:21:47.979Z |
5082453 | 5082453 | 20240911101107_PyzHm | NZ0041 | 2024-09-15T12:18:15.436Z | 2024-09-19T12:21:47.976Z |
5082398 | 5082398 | 20240911100219_iSyV2 | NZ0041 | 2024-09-15T12:18:13.174Z | 2024-09-19T12:21:47.939Z |
5081963 | 5081963 | 20240911090616_fDfxN | NZ0041 | 2024-09-15T12:17:56.247Z | 2024-09-19T12:21:46.820Z |
5081862 | 5081862 | 20240911085509_3hvtj | NZ0041 | 2024-09-15T12:17:52.341Z | 2024-09-19T12:21:46.572Z |
5081551 | 5081551 | 20240911080015_Tuv96 | NZ0041 | 2024-09-15T12:17:37.686Z | 2024-09-19T12:21:45.719Z |
5081497 | 5081497 | 20240911075027_UN6fS | NZ0041 | 2024-09-15T12:17:35.853Z | 2024-09-19T12:21:45.569Z |
5081377 | 5081377 | 20240911073223_oix7j | NZ0041 | 2024-09-15T12:17:31.764Z | 2024-09-19T12:21:45.212Z |
5070684 | 5070684 | 20240911145349_ZyWAv | NZ0041 | 2024-09-15T12:00:34.109Z | 2024-09-20T12:21:16.329Z |
5070549 | 5070549 | 20240911143057_Rnhrh | NZ0041 | 2024-09-15T12:00:17.138Z | 2024-09-20T12:21:15.593Z |
5070495 | 5070495 | 20240908110048_FQwpC | NZ0041 | 2024-09-14T12:22:00.458Z | 2024-09-16T12:21:26.478Z |
5070412 | 5070412 | 20240908164140_2BKif | NZ0041 | 2024-09-14T12:20:37.907Z | 2024-09-17T12:18:56.094Z |
5070407 | 5070407 | 20240908151807_lXyJ1 | NZ0041 | 2024-09-14T12:20:34.532Z | 2024-09-17T12:18:54.707Z |
5069071 | 5069071 | 20240910133826_Lo5dH | NZ0041 | 2024-09-14T12:19:25.142Z | 2024-09-18T12:15:27.095Z |
5068808 | 5068808 | 20240910122945_LLgWY | NZ0041 | 2024-09-14T12:19:21.674Z | 2024-09-18T12:15:26.701Z |
5068323 | 5068323 | 20240910112024_j01eG | NZ0041 | 2024-09-14T12:19:12.077Z | 2024-09-18T12:15:25.917Z |
5059317 | 5059317 | 20240910173004_AhAp3 | NZ0041 | 2024-09-14T12:05:42.509Z | 2024-09-19T12:21:30.514Z |
5059088 | 5059088 | 20240910171211_MYJo7 | NZ0041 | 2024-09-14T12:05:13.555Z | 2024-09-19T12:21:30.349Z |
5059050 | 5059050 | 20240910170907_HfvqL | NZ0041 | 2024-09-14T12:05:08.793Z | 2024-09-19T12:21:30.324Z |
5059007 | 5059007 | 20240910170733_rGGG4 | NZ0041 | 2024-09-14T12:05:05.744Z | 2024-09-19T12:21:30.301Z |
5058987 | 5058987 | 20240910170649_K38GN | NZ0041 | 2024-09-14T12:05:04.545Z | 2024-09-19T12:21:30.298Z |
5058962 | 5058962 | 20240910170356_wxc0N | NZ0041 | 2024-09-14T12:05:00.801Z | 2024-09-19T12:21:30.264Z |
5058898 | 5058898 | 20240910165543_Nzi6i | NZ0041 | 2024-09-14T12:04:46.767Z | 2024-09-19T12:21:30.221Z |
5058854 | 5058854 | 20240910165259_75Scn | NZ0041 | 2024-09-14T12:04:39.285Z | 2024-09-19T12:21:30.174Z |
5058781 | 5058781 | 20240910164612_nSsX2 | NZ0041 | 2024-09-14T12:04:31.436Z | 2024-09-19T12:21:30.088Z |
5058572 | 5058572 | 20240910162818_rkD94 | NZ0041 | 2024-09-14T12:04:01.992Z | 2024-09-19T12:21:29.750Z |
5058259 | 5058259 | 20240910155927_Y0cjK | NZ0041 | 2024-09-14T12:03:17.056Z | 2024-09-19T12:21:29.394Z |
5057689 | 5057689 | 20240910150430_r4edx | NZ0041 | 2024-09-14T12:01:44.280Z | 2024-09-19T12:21:28.581Z |
5057677 | 5057677 | 20240910150318_yF2Fx | NZ0041 | 2024-09-14T12:01:42.855Z | 2024-09-19T12:21:28.561Z |
5057289 | 5057289 | 20240910140714_9Nl2m | NZ0041 | 2024-09-14T12:00:45.038Z | 2024-09-19T12:21:27.504Z |
5057200 | 5057200 | 20240910135720_x35SH | NZ0041 | 2024-09-14T12:00:29.385Z | 2024-09-19T12:21:27.254Z |
5057076 | 5057076 | 20240908120716_iG3ra | NZ0041 | 2024-09-13T12:17:44.429Z | 2024-09-16T12:21:28.736Z |
5056850 | 5056850 | 20240908113110_2YM0F | NZ0041 | 2024-09-13T12:17:39.929Z | 2024-09-16T12:21:27.549Z |
5056829 | 5056829 | 20240908112926_0m5Jw | NZ0041 | 2024-09-13T12:17:39.771Z | 2024-09-16T12:21:27.462Z |
5056779 | 5056779 | 20240908112316_yG2Do | NZ0041 | 2024-09-13T12:17:39.222Z | 2024-09-16T12:21:27.278Z |
5056597 | 5056597 | 20240908104844_0Ry3z | NZ0041 | 2024-09-13T12:17:36.019Z | 2024-09-16T12:21:26.049Z |
5056518 | 5056518 | 20240908103717_r3Jhh | NZ0041 | 2024-09-13T12:17:34.423Z | 2024-09-16T12:21:25.727Z |
5056514 | 5056514 | 20240908103717_qWQ7B | NZ0041 | 2024-09-13T12:17:34.258Z | 2024-09-16T12:21:25.715Z |
5056246 | 5056246 | 20240908100006_HgJ8e | NZ0041 | 2024-09-13T12:17:28.856Z | 2024-09-16T12:21:24.029Z |
5056085 | 5056085 | 20240908093828_Dl9wl | NZ0041 | 2024-09-13T12:17:27.406Z | 2024-09-16T12:21:23.272Z |
5056042 | 5056042 | 20240908093308_t3tMF | NZ0041 | 2024-09-13T12:17:26.940Z | 2024-09-16T12:21:23.054Z |
5055895 | 5055895 | 20240908091450_KtQA8 | NZ0041 | 2024-09-13T12:17:25.300Z | 2024-09-16T12:21:22.527Z |
5055831 | 5055831 | 20240908090809_WK0Zg | NZ0041 | 2024-09-13T12:17:23.683Z | 2024-09-16T12:21:22.159Z |
5055623 | 5055623 | 20240908082913_hoSV2 | NZ0041 | 2024-09-13T12:17:18.822Z | 2024-09-16T12:21:21.211Z |
5051432 | 5051432 | 20240907172613_AK5pB | NZ0041 | 2024-09-13T12:14:14.102Z | 2024-09-16T12:21:00.414Z |
5051365 | 5051365 | 20240907172027_Yzm28 | NZ0041 | 2024-09-13T12:14:12.194Z | 2024-09-16T12:21:00.217Z |
5051348 | 5051348 | 20240907171944_RnhQQ | NZ0041 | 2024-09-13T12:14:11.651Z | 2024-09-16T12:21:00.156Z |
5051129 | 5051129 | 20240907165136_cVEjK | NZ0041 | 2024-09-13T12:14:03.168Z | 2024-09-16T12:20:59.621Z |
5050579 | 5050579 | 20240907154220_MhUnx | NZ0041 | 2024-09-13T12:13:37.529Z | 2024-09-16T12:20:58.044Z |
5050513 | 5050513 | 20240907153223_Da20K | NZ0041 | 2024-09-13T12:13:34.797Z | 2024-09-16T12:20:57.896Z |
5050295 | 5050295 | 20240907150453_dZbm8 | NZ0041 | 2024-09-13T12:13:22.906Z | 2024-09-16T12:20:56.961Z |
5045525 | 5045525 | 20240908171714_btH4V | NZ0041 | 2024-09-13T12:04:16.312Z | 2024-09-17T12:18:56.686Z |
5045382 | 5045382 | 20240908165924_vKZc3 | NZ0041 | 2024-09-13T12:04:04.460Z | 2024-09-17T12:18:56.448Z |
5045334 | 5045334 | 20240908165244_h53xL | NZ0041 | 2024-09-13T12:04:00.201Z | 2024-09-17T12:18:56.378Z |
5045324 | 5045324 | 20240908165232_jLT7r | NZ0041 | 2024-09-13T12:03:58.456Z | 2024-09-17T12:18:56.375Z |
5045279 | 5045279 | 20240908164852_Za6bf | NZ0041 | 2024-09-13T12:03:50.183Z | 2024-09-17T12:18:56.328Z |
5045238 | 5045238 | 20240908163906_moj9Q | NZ0041 | 2024-09-13T12:03:44.977Z | 2024-09-17T12:18:56.079Z |
5045220 | 5045220 | 20240908163543_Igvyg | NZ0041 | 2024-09-13T12:03:43.059Z | 2024-09-17T12:18:56.060Z |
5045133 | 5045133 | 20240908162500_ijJym | NZ0041 | 2024-09-13T12:03:35.205Z | 2024-09-17T12:18:55.949Z |
5045114 | 5045114 | 20240908162043_Z0gea | NZ0041 | 2024-09-13T12:03:33.767Z | 2024-09-17T12:18:55.918Z |
5044951 | 5044951 | 20240908155730_EO86h | NZ0041 | 2024-09-13T12:03:15.355Z | 2024-09-17T12:18:55.463Z |
5044945 | 5044945 | 20240908155724_NgcjR | NZ0041 | 2024-09-13T12:03:14.830Z | 2024-09-17T12:18:55.454Z |
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);