participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,191 rows where station_code = "NZ0012" 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 |
---|---|---|---|---|---|
5560928 | 5560928 | 20241120152423_MEHy2 | NZ0012 | 2024-11-21T14:09:59.125Z | 2024-11-22T14:19:21.762Z |
5560807 | 5560807 | 20241120143255_KSxAa | NZ0012 | 2024-11-21T14:09:47.239Z | 2024-11-22T14:19:21.737Z |
5560780 | 5560780 | 20241120142230_cXa3L | NZ0012 | 2024-11-21T14:09:44.607Z | 2024-11-22T14:19:21.732Z |
5560771 | 5560771 | 20241120142151_Unbc0 | NZ0012 | 2024-11-21T14:09:44.002Z | 2024-11-22T14:19:21.730Z |
5560750 | 5560750 | 20241120141558_A2QQe | NZ0012 | 2024-11-21T14:09:42.349Z | 2024-11-22T14:19:21.727Z |
5560675 | 5560675 | 20241120135435_7AVoU | NZ0012 | 2024-11-21T14:09:24.654Z | 2024-11-22T14:19:21.711Z |
5560653 | 5560653 | 20241120134550_O15SL | NZ0012 | 2024-11-21T14:09:22.248Z | 2024-11-22T14:19:21.707Z |
5560611 | 5560611 | 20241120132504_Ls2A8 | NZ0012 | 2024-11-21T14:09:15.472Z | 2024-11-22T14:19:21.696Z |
5560609 | 5560609 | 20241120132315_9AK4z | NZ0012 | 2024-11-21T14:09:15.034Z | 2024-11-22T14:19:21.696Z |
5560564 | 5560564 | 20241120131038_Xm0RH | NZ0012 | 2024-11-21T14:09:06.404Z | 2024-11-22T14:19:21.686Z |
5560533 | 5560533 | 20241120130756_Qh7BI | NZ0012 | 2024-11-21T14:09:03.520Z | 2024-11-22T14:19:21.681Z |
5560391 | 5560391 | 20241120124634_nUuNv | NZ0012 | 2024-11-21T14:08:47.018Z | 2024-11-22T14:19:21.650Z |
5560379 | 5560379 | 20241120124534_0bCW8 | NZ0012 | 2024-11-21T14:08:46.515Z | 2024-11-22T14:19:21.649Z |
5560353 | 5560353 | 20241120124146_rR2Xc | NZ0012 | 2024-11-21T14:08:43.252Z | 2024-11-22T14:19:21.643Z |
5560271 | 5560271 | 20241120122910_dreIW | NZ0012 | 2024-11-21T14:08:28.385Z | 2024-11-22T14:19:21.626Z |
5560250 | 5560250 | 20241120122512_vE5DZ | NZ0012 | 2024-11-21T14:08:24.488Z | 2024-11-22T14:19:21.621Z |
5560016 | 5560016 | 20241120114629_falW7 | NZ0012 | 2024-11-21T14:07:52.170Z | 2024-11-22T14:19:21.569Z |
5560013 | 5560013 | 20241120114627_M5MDz | NZ0012 | 2024-11-21T14:07:51.841Z | 2024-11-22T14:19:21.568Z |
5559876 | 5559876 | 20241120112853_Vi5j5 | NZ0012 | 2024-11-21T14:07:25.493Z | 2024-11-22T14:19:21.541Z |
5559800 | 5559800 | 20241120111850_3K3Lp | NZ0012 | 2024-11-21T14:07:12.891Z | 2024-11-22T14:19:21.527Z |
5559703 | 5559703 | 20241120110146_PLxqn | NZ0012 | 2024-11-21T14:07:00.523Z | 2024-11-22T14:19:21.506Z |
5559643 | 5559643 | 20241120105335_UUGeo | NZ0012 | 2024-11-21T14:06:51.487Z | 2024-11-22T14:19:21.493Z |
5555585 | 5555585 | 20241119135717_3ddu3 | NZ0012 | 2024-11-20T14:06:03.178Z | 2024-11-22T14:20:10.557Z |
5554560 | 5554560 | 20241119093615_v2l6m | NZ0012 | 2024-11-20T14:02:28.802Z | 2024-11-22T14:19:44.087Z |
5551148 | 5551148 | 20241118123331_tlUyo | NZ0012 | 2024-11-19T14:03:59.755Z | 2024-11-22T14:22:08.711Z |
5551135 | 5551135 | 20241118123032_lY3yi | NZ0012 | 2024-11-19T14:03:57.937Z | 2024-11-22T14:22:08.634Z |
5551088 | 5551088 | 20241118122428_rmUB3 | NZ0012 | 2024-11-19T14:03:53.990Z | 2024-11-22T14:22:08.206Z |
5550736 | 5550736 | 20241118111914_tCU4Z | NZ0012 | 2024-11-19T14:03:00.068Z | 2024-11-22T14:22:05.264Z |
5550391 | 5550391 | 20241118101549_j1QoN | NZ0012 | 2024-11-19T14:02:16.775Z | 2024-11-22T14:22:02.659Z |
5550345 | 5550345 | 20241118100840_VjDhF | NZ0012 | 2024-11-19T14:02:13.276Z | 2024-11-22T14:22:01.612Z |
5546459 | 5546459 | 20241117110546_Wqtep | NZ0012 | 2024-11-18T14:03:08.979Z | 2024-11-22T14:22:32.136Z |
5546046 | 5546046 | 20241117085829_WiFCc | NZ0012 | 2024-11-18T14:01:50.459Z | 2024-11-22T14:22:28.451Z |
5520403 | 5520403 | 20241111153735_3Nnqp | NZ0012 | 2024-11-12T14:06:16.001Z | 2024-11-20T14:25:08.161Z |
5520241 | 5520241 | 20241111150214_JhEn1 | NZ0012 | 2024-11-12T14:06:01.200Z | 2024-11-20T14:25:06.264Z |
5520209 | 5520209 | 20241111145829_hhRtS | NZ0012 | 2024-11-12T14:05:58.257Z | 2024-11-20T14:25:05.823Z |
5520172 | 5520172 | 20241111145348_Dhq6s | NZ0012 | 2024-11-12T14:05:48.690Z | 2024-11-20T14:25:05.355Z |
5520152 | 5520152 | 20241111144816_S8Be8 | NZ0012 | 2024-11-12T14:05:45.447Z | 2024-11-20T14:25:04.658Z |
5520138 | 5520138 | 20241111144520_ty5TS | NZ0012 | 2024-11-12T14:05:41.721Z | 2024-11-20T14:25:04.493Z |
5520088 | 5520088 | 20241111143527_JTzjA | NZ0012 | 2024-11-12T14:05:35.664Z | 2024-11-20T14:25:03.598Z |
5520076 | 5520076 | 20241111143215_UWtYG | NZ0012 | 2024-11-12T14:05:33.872Z | 2024-11-20T14:25:03.116Z |
5520071 | 5520071 | 20241111143046_MgK0w | NZ0012 | 2024-11-12T14:05:33.208Z | 2024-11-20T14:25:03.061Z |
5520061 | 5520061 | 20241111142733_H2x3r | NZ0012 | 2024-11-12T14:05:32.305Z | 2024-11-20T14:25:02.864Z |
5520022 | 5520022 | 20241111142242_CUy8e | NZ0012 | 2024-11-12T14:05:29.256Z | 2024-11-20T14:25:02.500Z |
5519998 | 5519998 | 20241111141450_A827M | NZ0012 | 2024-11-12T14:05:27.074Z | 2024-11-20T14:25:01.546Z |
5519964 | 5519964 | 20241111140648_jDhko | NZ0012 | 2024-11-12T14:05:24.109Z | 2024-11-20T14:25:01.293Z |
5519869 | 5519869 | 20241111133908_uqsbC | NZ0012 | 2024-11-12T14:05:14.137Z | 2024-11-20T14:25:00.270Z |
5519846 | 5519846 | 20241111133357_LKSgP | NZ0012 | 2024-11-12T14:05:10.709Z | 2024-11-20T14:24:59.856Z |
5519840 | 5519840 | 20241111133240_lxTVi | NZ0012 | 2024-11-12T14:05:09.949Z | 2024-11-20T14:24:59.789Z |
5519802 | 5519802 | 20241111130833_57jJo | NZ0012 | 2024-11-12T14:05:03.371Z | 2024-11-20T14:24:58.096Z |
5519597 | 5519597 | 20241111121032_I5DHI | NZ0012 | 2024-11-12T14:04:34.532Z | 2024-11-20T14:24:53.359Z |
5514377 | 5514377 | 20241110154035_5SObG | NZ0012 | 2024-11-11T14:06:33.782Z | 2024-11-19T14:21:46.909Z |
5514371 | 5514371 | 20241110154009_8VOpu | NZ0012 | 2024-11-11T14:06:33.386Z | 2024-11-19T14:21:46.885Z |
5514363 | 5514363 | 20241110153832_QAgeL | NZ0012 | 2024-11-11T14:06:32.848Z | 2024-11-19T14:21:46.741Z |
5514314 | 5514314 | 20241110153011_RVGgR | NZ0012 | 2024-11-11T14:06:28.821Z | 2024-11-19T14:21:46.329Z |
5514262 | 5514262 | 20241110152011_hCovw | NZ0012 | 2024-11-11T14:06:24.477Z | 2024-11-19T14:21:45.539Z |
5514242 | 5514242 | 20241110151746_e3XEd | NZ0012 | 2024-11-11T14:06:23.483Z | 2024-11-19T14:21:45.291Z |
5514235 | 5514235 | 20241110151710_aSg5g | NZ0012 | 2024-11-11T14:06:22.780Z | 2024-11-19T14:21:45.269Z |
5514200 | 5514200 | 20241110150618_Nznfz | NZ0012 | 2024-11-11T14:06:20.092Z | 2024-11-19T14:21:44.792Z |
5514189 | 5514189 | 20241110150404_u1VmX | NZ0012 | 2024-11-11T14:06:19.667Z | 2024-11-19T14:21:44.707Z |
5514178 | 5514178 | 20241110150223_Y4iNb | NZ0012 | 2024-11-11T14:06:19.175Z | 2024-11-19T14:21:44.694Z |
5514154 | 5514154 | 20241110145138_f0m0z | NZ0012 | 2024-11-11T14:06:16.628Z | 2024-11-19T14:21:44.333Z |
5514124 | 5514124 | 20241110143656_XBr31 | NZ0012 | 2024-11-11T14:06:14.714Z | 2024-11-19T14:21:43.946Z |
5514058 | 5514058 | 20241110140257_xdwI3 | NZ0012 | 2024-11-11T14:05:58.573Z | 2024-11-19T14:21:42.825Z |
5514045 | 5514045 | 20241110135749_yoIBq | NZ0012 | 2024-11-11T14:05:56.120Z | 2024-11-19T14:21:42.549Z |
5514008 | 5514008 | 20241110133339_pnOrP | NZ0012 | 2024-11-11T14:05:47.560Z | 2024-11-19T14:21:41.704Z |
5513171 | 5513171 | 20241110105104_tzlGS | NZ0012 | 2024-11-11T14:04:02.218Z | 2024-11-19T14:21:31.769Z |
5494075 | 5494075 | 20241107152906_k1NBr | NZ0012 | 2024-11-08T14:05:20.593Z | 2024-11-16T14:27:46.439Z |
5493986 | 5493986 | 20241107150452_huW9q | NZ0012 | 2024-11-08T14:05:12.659Z | 2024-11-16T14:27:44.451Z |
5493931 | 5493931 | 20241107144055_IyYwj | NZ0012 | 2024-11-08T14:04:58.401Z | 2024-11-16T14:27:43.315Z |
5493910 | 5493910 | 20241107143253_aZWzn | NZ0012 | 2024-11-08T14:04:52.508Z | 2024-11-16T14:27:42.952Z |
5493902 | 5493902 | 20241107143110_nDiJL | NZ0012 | 2024-11-08T14:04:50.990Z | 2024-11-16T14:27:42.919Z |
5493866 | 5493866 | 20241107142256_bGd0I | NZ0012 | 2024-11-08T14:04:47.895Z | 2024-11-16T14:27:42.747Z |
5493859 | 5493859 | 20241107142135_CuYhC | NZ0012 | 2024-11-08T14:04:46.995Z | 2024-11-16T14:27:42.635Z |
5493836 | 5493836 | 20241107140238_YqDuP | NZ0012 | 2024-11-08T14:04:42.919Z | 2024-11-16T14:27:42.100Z |
5493831 | 5493831 | 20241107140135_abRvW | NZ0012 | 2024-11-08T14:04:42.769Z | 2024-11-16T14:27:41.976Z |
5493702 | 5493702 | 20241107130628_7K3V3 | NZ0012 | 2024-11-08T14:04:30.713Z | 2024-11-16T14:27:39.396Z |
5493696 | 5493696 | 20241107130501_hu0rS | NZ0012 | 2024-11-08T14:04:30.490Z | 2024-11-16T14:27:39.121Z |
5493679 | 5493679 | 20241107130036_tI8Sw | NZ0012 | 2024-11-08T14:04:28.995Z | 2024-11-16T14:27:38.938Z |
5493667 | 5493667 | 20241107125812_wPnzL | NZ0012 | 2024-11-08T14:04:27.793Z | 2024-11-16T14:27:38.260Z |
5493602 | 5493602 | 20241107124452_66mDI | NZ0012 | 2024-11-08T14:04:15.663Z | 2024-11-16T14:27:36.850Z |
5493568 | 5493568 | 20241107123722_35ui5 | NZ0012 | 2024-11-08T14:04:06.445Z | 2024-11-16T14:27:36.119Z |
5493543 | 5493543 | 20241107123139_VfRW2 | NZ0012 | 2024-11-08T14:04:01.912Z | 2024-11-16T14:27:35.611Z |
5493510 | 5493510 | 20241107122339_LlJxb | NZ0012 | 2024-11-08T14:03:55.254Z | 2024-11-16T14:27:35.195Z |
5493495 | 5493495 | 20241107122300_fCJpK | NZ0012 | 2024-11-08T14:03:53.269Z | 2024-11-16T14:27:35.012Z |
5493375 | 5493375 | 20241107115932_2nz24 | NZ0012 | 2024-11-08T14:03:38.816Z | 2024-11-16T14:27:33.837Z |
5493300 | 5493300 | 20241107114508_ssPuR | NZ0012 | 2024-11-08T14:03:30.551Z | 2024-11-16T14:27:33.411Z |
5493295 | 5493295 | 20241107114351_UrkxL | NZ0012 | 2024-11-08T14:03:30.218Z | 2024-11-16T14:27:33.391Z |
5493277 | 5493277 | 20241107113319_7hzkB | NZ0012 | 2024-11-08T14:03:27.591Z | 2024-11-16T14:27:33.274Z |
5493231 | 5493231 | 20241107112107_FkH4e | NZ0012 | 2024-11-08T14:03:14.702Z | 2024-11-16T14:27:33.099Z |
5493216 | 5493216 | 20241107111904_I0ruc | NZ0012 | 2024-11-08T14:03:11.428Z | 2024-11-16T14:27:33.044Z |
5493169 | 5493169 | 20241107111220_coJui | NZ0012 | 2024-11-08T14:03:01.387Z | 2024-11-16T14:27:32.661Z |
5493130 | 5493130 | 20241107110132_3r7bN | NZ0012 | 2024-11-08T14:02:56.242Z | 2024-11-16T14:27:32.211Z |
5493075 | 5493075 | 20241107104948_bMyA0 | NZ0012 | 2024-11-08T14:02:49.057Z | 2024-11-16T14:27:31.916Z |
5493017 | 5493017 | 20241107103735_jk0cP | NZ0012 | 2024-11-08T14:02:43.631Z | 2024-11-16T14:27:31.500Z |
5492988 | 5492988 | 20241107103118_Ewhme | NZ0012 | 2024-11-08T14:02:40.678Z | 2024-11-16T14:27:31.370Z |
5492963 | 5492963 | 20241107102647_LAiPS | NZ0012 | 2024-11-08T14:02:38.774Z | 2024-11-16T14:27:31.202Z |
5492939 | 5492939 | 20241107102256_8V8Nn | NZ0012 | 2024-11-08T14:02:36.552Z | 2024-11-16T14:27:31.114Z |
5492880 | 5492880 | 20241107101432_bhf3U | NZ0012 | 2024-11-08T14:02:23.243Z | 2024-11-16T14:27:30.171Z |
5492791 | 5492791 | 20241107095645_dtYz1 | NZ0012 | 2024-11-08T14:02:06.068Z | 2024-11-16T14:27:28.788Z |
5473761 | 5473761 | 20241103150021_dLPNY | NZ0012 | 2024-11-05T14:09:42.288Z | 2024-11-12T14:27:49.993Z |
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);