participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,979 rows where station_code = "NZ004N" 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 |
---|---|---|---|---|---|
5135613 | 5135613 | 20240915163448_iTEkE | NZ004N | 2024-09-19T12:19:34.029Z | 2024-09-19T12:19:34.029Z |
5135513 | 5135513 | 20240915150936_qrbQF | NZ004N | 2024-09-19T12:19:32.616Z | 2024-09-19T12:19:32.616Z |
5135355 | 5135355 | 20240915125629_todN7 | NZ004N | 2024-09-19T12:19:29.124Z | 2024-09-19T12:19:29.124Z |
5135328 | 5135328 | 20240915122453_EUnp9 | NZ004N | 2024-09-19T12:19:28.511Z | 2024-09-19T12:19:28.511Z |
5135243 | 5135243 | 20240916171630_vE2P9 | NZ004N | 2024-09-19T12:18:17.100Z | 2024-09-19T12:18:17.100Z |
5135211 | 5135211 | 20240916170142_nisQV | NZ004N | 2024-09-19T12:18:16.652Z | 2024-09-19T12:18:16.652Z |
5135195 | 5135195 | 20240916165717_itj7v | NZ004N | 2024-09-19T12:18:16.378Z | 2024-09-19T12:18:16.378Z |
5135179 | 5135179 | 20240916165237_gWJYv | NZ004N | 2024-09-19T12:18:16.126Z | 2024-09-19T12:18:16.126Z |
5135116 | 5135116 | 20240916162505_jfzuo | NZ004N | 2024-09-19T12:18:14.935Z | 2024-09-19T12:18:14.935Z |
5135081 | 5135081 | 20240916160529_EFINj | NZ004N | 2024-09-19T12:18:14.187Z | 2024-09-19T12:18:14.187Z |
5135050 | 5135050 | 20240916154348_4UU3f | NZ004N | 2024-09-19T12:18:13.453Z | 2024-09-19T12:18:13.453Z |
5134961 | 5134961 | 20240916145119_5yq02 | NZ004N | 2024-09-19T12:18:11.276Z | 2024-09-19T12:18:11.276Z |
5134903 | 5134903 | 20240916135525_Z6iN1 | NZ004N | 2024-09-19T12:18:09.373Z | 2024-09-19T12:18:09.373Z |
5134862 | 5134862 | 20240916130742_HJyxM | NZ004N | 2024-09-19T12:18:08.479Z | 2024-09-19T12:18:08.479Z |
5130900 | 5130900 | 20240917161545_OQy9P | NZ004N | 2024-09-19T12:13:56.626Z | 2024-09-19T12:13:56.626Z |
5130870 | 5130870 | 20240917160321_0S2AJ | NZ004N | 2024-09-19T12:13:54.615Z | 2024-09-19T12:13:54.615Z |
5130849 | 5130849 | 20240917155330_iSwXW | NZ004N | 2024-09-19T12:13:53.614Z | 2024-09-19T12:13:53.614Z |
5130784 | 5130784 | 20240917152152_AK5FM | NZ004N | 2024-09-19T12:13:49.870Z | 2024-09-19T12:13:49.870Z |
5130729 | 5130729 | 20240917145317_dXkAp | NZ004N | 2024-09-19T12:13:46.577Z | 2024-09-19T12:13:46.577Z |
5130721 | 5130721 | 20240917145212_yzYrR | NZ004N | 2024-09-19T12:13:46.354Z | 2024-09-19T12:13:46.354Z |
5130715 | 5130715 | 20240917145009_vFDzS | NZ004N | 2024-09-19T12:13:46.225Z | 2024-09-19T12:13:46.225Z |
5130711 | 5130711 | 20240917144851_jJfEr | NZ004N | 2024-09-19T12:13:46.120Z | 2024-09-19T12:13:46.120Z |
5130707 | 5130707 | 20240917144610_81qdH | NZ004N | 2024-09-19T12:13:45.984Z | 2024-09-19T12:13:45.984Z |
5130663 | 5130663 | 20240917141249_YG882 | NZ004N | 2024-09-19T12:13:43.013Z | 2024-09-19T12:13:43.013Z |
5130613 | 5130613 | 20240917135037_LZH3Y | NZ004N | 2024-09-19T12:13:39.682Z | 2024-09-19T12:13:39.682Z |
5130602 | 5130602 | 20240917134337_JJa9y | NZ004N | 2024-09-19T12:13:38.952Z | 2024-09-19T12:13:38.952Z |
5130567 | 5130567 | 20240917131631_KLH2S | NZ004N | 2024-09-19T12:13:36.314Z | 2024-09-19T12:13:36.314Z |
5130554 | 5130554 | 20240917130653_PB9nc | NZ004N | 2024-09-19T12:13:35.069Z | 2024-09-19T12:13:35.069Z |
5130537 | 5130537 | 20240917130329_Cl2Rx | NZ004N | 2024-09-19T12:13:32.362Z | 2024-09-19T12:13:32.362Z |
5130480 | 5130480 | 20240917122051_v5s7E | NZ004N | 2024-09-19T12:13:22.282Z | 2024-09-19T12:13:22.282Z |
5130429 | 5130429 | 20240917115649_yWaE8 | NZ004N | 2024-09-19T12:13:14.870Z | 2024-09-19T12:13:14.870Z |
5126609 | 5126609 | 20240918161808_fP94f | NZ004N | 2024-09-19T12:06:32.585Z | 2024-09-19T12:06:42.235Z |
5126604 | 5126604 | 20240918161143_c494k | NZ004N | 2024-09-19T12:06:31.886Z | 2024-09-19T12:06:42.234Z |
5126576 | 5126576 | 20240918152137_xOa2K | NZ004N | 2024-09-19T12:06:24.716Z | 2024-09-19T12:06:42.228Z |
5126555 | 5126555 | 20240918144149_iQH5p | NZ004N | 2024-09-19T12:06:18.432Z | 2024-09-19T12:06:42.224Z |
5126553 | 5126553 | 20240918142911_13mg4 | NZ004N | 2024-09-19T12:06:17.648Z | 2024-09-19T12:06:42.224Z |
5119012 | 5119012 | 20240915120421_ApsxY | NZ004N | 2024-09-18T12:09:18.093Z | 2024-09-19T12:19:28.182Z |
5118367 | 5118367 | 20240915092920_ugGj3 | NZ004N | 2024-09-18T12:08:40.215Z | 2024-09-19T12:19:22.368Z |
5109444 | 5109444 | 20240913095544_T4Ofk | NZ004N | 2024-09-17T12:14:38.282Z | 2024-09-19T12:20:53.343Z |
5098343 | 5098343 | 20240913162230_3ndpN | NZ004N | 2024-09-17T12:00:16.764Z | 2024-09-19T12:19:36.386Z |
5096980 | 5096980 | 20240912132128_3aGvk | NZ004N | 2024-09-16T12:16:41.276Z | 2024-09-19T12:21:24.429Z |
5096934 | 5096934 | 20240912123113_ExNI6 | NZ004N | 2024-09-16T12:16:38.398Z | 2024-09-19T12:21:24.254Z |
5096337 | 5096337 | 20240912103523_NjgCy | NZ004N | 2024-09-16T12:16:20.669Z | 2024-09-19T12:21:22.142Z |
5096238 | 5096238 | 20240912102251_7A6HF | NZ004N | 2024-09-16T12:16:16.615Z | 2024-09-19T12:21:21.945Z |
5095992 | 5095992 | 20240912093837_pVfbu | NZ004N | 2024-09-16T12:16:04.379Z | 2024-09-19T12:21:20.809Z |
5095947 | 5095947 | 20240912093121_kOfGJ | NZ004N | 2024-09-16T12:16:02.905Z | 2024-09-19T12:21:20.699Z |
5095381 | 5095381 | 20240912072327_IHsPG | NZ004N | 2024-09-16T12:15:38.071Z | 2024-09-19T12:21:18.376Z |
5083709 | 5083709 | 20240911141240_3Vt3f | NZ004N | 2024-09-15T12:18:45.628Z | 2024-09-19T12:21:49.817Z |
5083690 | 5083690 | 20240911141204_Si0Tk | NZ004N | 2024-09-15T12:18:45.499Z | 2024-09-19T12:21:49.802Z |
5083675 | 5083675 | 20240911141024_A2pBw | NZ004N | 2024-09-15T12:18:45.396Z | 2024-09-19T12:21:49.794Z |
5083613 | 5083613 | 20240911135715_xkjIf | NZ004N | 2024-09-15T12:18:44.578Z | 2024-09-19T12:21:49.724Z |
5083456 | 5083456 | 20240911132552_xLONI | NZ004N | 2024-09-15T12:18:42.253Z | 2024-09-19T12:21:49.589Z |
5083433 | 5083433 | 20240911131705_KQ2i8 | NZ004N | 2024-09-15T12:18:41.909Z | 2024-09-19T12:21:49.581Z |
5083386 | 5083386 | 20240911130718_QVgLe | NZ004N | 2024-09-15T12:18:40.622Z | 2024-09-19T12:21:49.536Z |
5083247 | 5083247 | 20240911123737_tyAXu | NZ004N | 2024-09-15T12:18:37.653Z | 2024-09-19T12:21:49.434Z |
5083229 | 5083229 | 20240911123314_v5dvX | NZ004N | 2024-09-15T12:18:37.077Z | 2024-09-19T12:21:49.417Z |
5083221 | 5083221 | 20240911123205_S5ZtW | NZ004N | 2024-09-15T12:18:37.045Z | 2024-09-19T12:21:49.416Z |
5083142 | 5083142 | 20240911121420_l1xvU | NZ004N | 2024-09-15T12:18:36.137Z | 2024-09-19T12:21:49.356Z |
5083128 | 5083128 | 20240911121301_4OSPj | NZ004N | 2024-09-15T12:18:35.997Z | 2024-09-19T12:21:49.353Z |
5083032 | 5083032 | 20240911114850_z2HZH | NZ004N | 2024-09-15T12:18:33.791Z | 2024-09-19T12:21:49.142Z |
5082698 | 5082698 | 20240911104449_jsGfO | NZ004N | 2024-09-15T12:18:22.792Z | 2024-09-19T12:21:48.344Z |
5082646 | 5082646 | 20240911103914_zoNsv | NZ004N | 2024-09-15T12:18:21.666Z | 2024-09-19T12:21:48.288Z |
5082522 | 5082522 | 20240911101949_RQQqT | NZ004N | 2024-09-15T12:18:17.103Z | 2024-09-19T12:21:48.035Z |
5082272 | 5082272 | 20240911094556_xIK4H | NZ004N | 2024-09-15T12:18:09.732Z | 2024-09-19T12:21:47.622Z |
5082234 | 5082234 | 20240911094154_4uK0C | NZ004N | 2024-09-15T12:18:08.792Z | 2024-09-19T12:21:47.541Z |
5082120 | 5082120 | 20240911092510_bgMQZ | NZ004N | 2024-09-15T12:18:04.000Z | 2024-09-19T12:21:47.215Z |
5082107 | 5082107 | 20240911092401_GDUZ7 | NZ004N | 2024-09-15T12:18:03.714Z | 2024-09-19T12:21:47.184Z |
5082090 | 5082090 | 20240911092010_ZVchJ | NZ004N | 2024-09-15T12:18:02.710Z | 2024-09-19T12:21:47.175Z |
5082023 | 5082023 | 20240911091414_jCjeJ | NZ004N | 2024-09-15T12:17:59.560Z | 2024-09-19T12:21:47.052Z |
5081891 | 5081891 | 20240911085938_OW3j2 | NZ004N | 2024-09-15T12:17:53.448Z | 2024-09-19T12:21:46.662Z |
5081756 | 5081756 | 20240911083912_5AIIX | NZ004N | 2024-09-15T12:17:46.158Z | 2024-09-19T12:21:46.385Z |
5081684 | 5081684 | 20240911082402_6MbbD | NZ004N | 2024-09-15T12:17:41.472Z | 2024-09-19T12:21:46.065Z |
5071540 | 5071540 | 20240911171337_JGYEl | NZ004N | 2024-09-15T12:02:51.845Z | 2024-09-19T12:21:02.083Z |
5071473 | 5071473 | 20240911165952_im3ZG | NZ004N | 2024-09-15T12:02:38.754Z | 2024-09-19T12:21:01.980Z |
5071345 | 5071345 | 20240911163554_xYSkP | NZ004N | 2024-09-15T12:02:20.513Z | 2024-09-19T12:21:01.745Z |
5071284 | 5071284 | 20240911162930_Vgevb | NZ004N | 2024-09-15T12:02:10.107Z | 2024-09-19T12:21:01.378Z |
5071088 | 5071088 | 20240911155911_YY3pe | NZ004N | 2024-09-15T12:01:37.567Z | 2024-09-19T12:21:00.889Z |
5071012 | 5071012 | 20240911154135_1xyg1 | NZ004N | 2024-09-15T12:01:21.212Z | 2024-09-19T12:21:00.734Z |
5071008 | 5071008 | 20240911154053_S1lxI | NZ004N | 2024-09-15T12:01:20.774Z | 2024-09-19T12:21:00.725Z |
5070852 | 5070852 | 20240911151546_APycO | NZ004N | 2024-09-15T12:01:00.381Z | 2024-09-19T12:21:00.414Z |
5070806 | 5070806 | 20240911151123_FI0Ja | NZ004N | 2024-09-15T12:00:54.081Z | 2024-09-19T12:21:00.314Z |
5070779 | 5070779 | 20240911151044_q3h7a | NZ004N | 2024-09-15T12:00:48.386Z | 2024-09-19T12:21:00.240Z |
5070734 | 5070734 | 20240911150145_o5F3o | NZ004N | 2024-09-15T12:00:43.233Z | 2024-09-19T12:21:00.144Z |
5070707 | 5070707 | 20240911145640_Kj1OV | NZ004N | 2024-09-15T12:00:38.717Z | 2024-09-19T12:21:00.080Z |
5070698 | 5070698 | 20240911145608_1CfWA | NZ004N | 2024-09-15T12:00:36.550Z | 2024-09-19T12:21:00.055Z |
5070637 | 5070637 | 20240911144354_kf5Dp | NZ004N | 2024-09-15T12:00:27.310Z | 2024-09-19T12:20:59.628Z |
5070625 | 5070625 | 20240911144234_m20Qk | NZ004N | 2024-09-15T12:00:25.679Z | 2024-09-19T12:20:59.454Z |
5070575 | 5070575 | 20240911143413_ldNi8 | NZ004N | 2024-09-15T12:00:20.203Z | 2024-09-19T12:20:59.300Z |
5070511 | 5070511 | 20240911142615_wqe4K | NZ004N | 2024-09-15T12:00:11.124Z | 2024-09-19T12:20:59.168Z |
5070499 | 5070499 | 20240911142335_2CWtj | NZ004N | 2024-09-15T12:00:09.200Z | 2024-09-19T12:20:59.139Z |
5070415 | 5070415 | 20240908170605_w9R7L | NZ004N | 2024-09-14T12:20:38.531Z | 2024-09-17T12:18:56.592Z |
5069030 | 5069030 | 20240910132517_CwUgF | NZ004N | 2024-09-14T12:19:24.138Z | 2024-09-18T12:15:27.025Z |
5068994 | 5068994 | 20240910132007_Ch14F | NZ004N | 2024-09-14T12:19:23.556Z | 2024-09-18T12:15:26.970Z |
5068920 | 5068920 | 20240910130142_cfZLY | NZ004N | 2024-09-14T12:19:22.922Z | 2024-09-18T12:15:26.850Z |
5068904 | 5068904 | 20240910125746_iCMhv | NZ004N | 2024-09-14T12:19:22.792Z | 2024-09-18T12:15:26.809Z |
5068029 | 5068029 | 20240910104323_kUwmZ | NZ004N | 2024-09-14T12:19:07.169Z | 2024-09-18T12:15:25.390Z |
5067228 | 5067228 | 20240910090910_d9kDk | NZ004N | 2024-09-14T12:18:36.539Z | 2024-09-18T12:15:23.630Z |
5066993 | 5066993 | 20240910084022_9uwjG | NZ004N | 2024-09-14T12:18:25.590Z | 2024-09-18T12:15:23.141Z |
5066990 | 5066990 | 20240910083933_ekAnB | NZ004N | 2024-09-14T12:18:25.487Z | 2024-09-18T12:15:23.137Z |
5062311 | 5062311 | 20240909171017_J6xHZ | NZ004N | 2024-09-14T12:12:08.581Z | 2024-09-18T12:15:10.845Z |
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);