participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,601 rows where station_code = "NZ0032" 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 |
---|---|---|---|---|---|
5560998 | 5560998 | 20241120155355_UKY3o | NZ0032 | 2024-11-21T14:10:11.522Z | 2024-11-22T14:19:21.781Z |
5560860 | 5560860 | 20241120145700_U4jfL | NZ0032 | 2024-11-21T14:09:53.348Z | 2024-11-22T14:19:21.749Z |
5560809 | 5560809 | 20241120143255_KSxAa | NZ0032 | 2024-11-21T14:09:47.239Z | 2024-11-22T14:19:21.737Z |
5560707 | 5560707 | 20241120140045_XToNe | NZ0032 | 2024-11-21T14:09:33.375Z | 2024-11-22T14:19:21.718Z |
5560654 | 5560654 | 20241120134550_O15SL | NZ0032 | 2024-11-21T14:09:22.248Z | 2024-11-22T14:19:21.707Z |
5560610 | 5560610 | 20241120132315_9AK4z | NZ0032 | 2024-11-21T14:09:15.034Z | 2024-11-22T14:19:21.696Z |
5560543 | 5560543 | 20241120130803_NhfUG | NZ0032 | 2024-11-21T14:09:04.008Z | 2024-11-22T14:19:21.682Z |
5560513 | 5560513 | 20241120130451_bV2Q7 | NZ0032 | 2024-11-21T14:09:00.193Z | 2024-11-22T14:19:21.676Z |
5560500 | 5560500 | 20241120130107_WKAZH | NZ0032 | 2024-11-21T14:08:58.313Z | 2024-11-22T14:19:21.672Z |
5560436 | 5560436 | 20241120125205_LAZg7 | NZ0032 | 2024-11-21T14:08:51.545Z | 2024-11-22T14:19:21.658Z |
5560425 | 5560425 | 20241120125056_Ig13Z | NZ0032 | 2024-11-21T14:08:50.299Z | 2024-11-22T14:19:21.656Z |
5560409 | 5560409 | 20241120124843_wpK0c | NZ0032 | 2024-11-21T14:08:48.338Z | 2024-11-22T14:19:21.653Z |
5560354 | 5560354 | 20241120124146_rR2Xc | NZ0032 | 2024-11-21T14:08:43.252Z | 2024-11-22T14:19:21.643Z |
5560273 | 5560273 | 20241120122910_dreIW | NZ0032 | 2024-11-21T14:08:28.385Z | 2024-11-22T14:19:21.626Z |
5560247 | 5560247 | 20241120122418_LHy3d | NZ0032 | 2024-11-21T14:08:24.203Z | 2024-11-22T14:19:21.620Z |
5560091 | 5560091 | 20241120115759_Qp2JL | NZ0032 | 2024-11-21T14:08:01.896Z | 2024-11-22T14:19:21.586Z |
5559311 | 5559311 | 20241120100231_F9srm | NZ0032 | 2024-11-21T14:05:56.597Z | 2024-11-22T14:19:21.415Z |
5558965 | 5558965 | 20241120090002_VpWkX | NZ0032 | 2024-11-21T14:04:54.814Z | 2024-11-22T14:19:21.337Z |
5555756 | 5555756 | 20241119154052_mSElt | NZ0032 | 2024-11-20T14:06:32.563Z | 2024-11-22T14:20:13.569Z |
5555725 | 5555725 | 20241119150218_XZv2o | NZ0032 | 2024-11-20T14:06:29.147Z | 2024-11-22T14:20:13.061Z |
5555711 | 5555711 | 20241119145631_fCTZV | NZ0032 | 2024-11-20T14:06:27.656Z | 2024-11-22T14:20:12.693Z |
5555632 | 5555632 | 20241119141210_tgBqo | NZ0032 | 2024-11-20T14:06:11.404Z | 2024-11-22T14:20:11.434Z |
5555580 | 5555580 | 20241119135705_ppKB4 | NZ0032 | 2024-11-20T14:06:02.507Z | 2024-11-22T14:20:10.411Z |
5555558 | 5555558 | 20241119135213_lqnIq | NZ0032 | 2024-11-20T14:05:59.243Z | 2024-11-22T14:20:09.729Z |
5555467 | 5555467 | 20241119132458_CwWhg | NZ0032 | 2024-11-20T14:05:43.009Z | 2024-11-22T14:20:06.921Z |
5555452 | 5555452 | 20241119132106_iznYU | NZ0032 | 2024-11-20T14:05:40.274Z | 2024-11-22T14:20:06.675Z |
5555353 | 5555353 | 20241119125420_iy26f | NZ0032 | 2024-11-20T14:05:16.392Z | 2024-11-22T14:20:04.664Z |
5554562 | 5554562 | 20241119093615_v2l6m | NZ0032 | 2024-11-20T14:02:28.825Z | 2024-11-22T14:19:44.087Z |
5554497 | 5554497 | 20241119091833_5gIP6 | NZ0032 | 2024-11-20T14:02:18.334Z | 2024-11-22T14:19:42.111Z |
5554425 | 5554425 | 20241119085543_9v9sl | NZ0032 | 2024-11-20T14:02:00.655Z | 2024-11-22T14:19:40.560Z |
5551883 | 5551883 | 20241118153229_C3zZ9 | NZ0032 | 2024-11-19T14:05:45.938Z | 2024-11-22T14:22:12.884Z |
5551877 | 5551877 | 20241118153201_ZxDqx | NZ0032 | 2024-11-19T14:05:45.413Z | 2024-11-22T14:22:12.857Z |
5551809 | 5551809 | 20241118151946_3bOgz | NZ0032 | 2024-11-19T14:05:34.763Z | 2024-11-22T14:22:12.590Z |
5551656 | 5551656 | 20241118143630_dhbg6 | NZ0032 | 2024-11-19T14:05:07.844Z | 2024-11-22T14:22:11.937Z |
5551633 | 5551633 | 20241118143137_OVyS3 | NZ0032 | 2024-11-19T14:05:06.230Z | 2024-11-22T14:22:11.834Z |
5551619 | 5551619 | 20241118142856_Mgsvh | NZ0032 | 2024-11-19T14:05:05.256Z | 2024-11-22T14:22:11.727Z |
5551611 | 5551611 | 20241118142826_OMsW2 | NZ0032 | 2024-11-19T14:05:04.684Z | 2024-11-22T14:22:11.709Z |
5551365 | 5551365 | 20241118131619_p0cEN | NZ0032 | 2024-11-19T14:04:37.451Z | 2024-11-22T14:22:10.361Z |
5551145 | 5551145 | 20241118123305_U2l75 | NZ0032 | 2024-11-19T14:03:59.448Z | 2024-11-22T14:22:08.700Z |
5551118 | 5551118 | 20241118122829_290yx | NZ0032 | 2024-11-19T14:03:56.259Z | 2024-11-22T14:22:08.452Z |
5551091 | 5551091 | 20241118122428_rmUB3 | NZ0032 | 2024-11-19T14:03:53.990Z | 2024-11-22T14:22:08.206Z |
5551011 | 5551011 | 20241118120913_MCiZC | NZ0032 | 2024-11-19T14:03:46.468Z | 2024-11-22T14:22:07.558Z |
5550986 | 5550986 | 20241118120700_9picy | NZ0032 | 2024-11-19T14:03:44.410Z | 2024-11-22T14:22:07.415Z |
5550738 | 5550738 | 20241118111914_tCU4Z | NZ0032 | 2024-11-19T14:03:00.068Z | 2024-11-22T14:22:05.264Z |
5550567 | 5550567 | 20241118104855_mx3fG | NZ0032 | 2024-11-19T14:02:37.224Z | 2024-11-22T14:22:03.996Z |
5547177 | 5547177 | 20241117150344_G1fzq | NZ0032 | 2024-11-18T14:05:13.718Z | 2024-11-22T14:22:37.832Z |
5547111 | 5547111 | 20241117144727_kEBau | NZ0032 | 2024-11-18T14:05:05.176Z | 2024-11-22T14:22:37.125Z |
5546914 | 5546914 | 20241117132316_cy7lt | NZ0032 | 2024-11-18T14:04:27.349Z | 2024-11-22T14:22:35.415Z |
5546696 | 5546696 | 20241117121736_8ONRS | NZ0032 | 2024-11-18T14:03:52.303Z | 2024-11-22T14:22:33.970Z |
5546516 | 5546516 | 20241117112345_vFbUb | NZ0032 | 2024-11-18T14:03:16.682Z | 2024-11-22T14:22:32.387Z |
5546189 | 5546189 | 20241117093913_dm2ay | NZ0032 | 2024-11-18T14:02:24.862Z | 2024-11-22T14:22:29.924Z |
5544791 | 5544791 | 20241116152426_Ch2TD | NZ0032 | 2024-11-17T14:02:07.186Z | 2024-11-22T14:23:06.294Z |
5544735 | 5544735 | 20241116145506_prIhR | NZ0032 | 2024-11-17T14:01:58.232Z | 2024-11-22T14:23:05.958Z |
5544711 | 5544711 | 20241116144204_0Y5nQ | NZ0032 | 2024-11-17T14:01:53.863Z | 2024-11-22T14:23:05.905Z |
5536008 | 5536008 | 20241112151719_rOC2a | NZ0032 | 2024-11-14T14:09:05.947Z | 2024-11-21T14:25:56.075Z |
5535764 | 5535764 | 20241112141452_tSxlf | NZ0032 | 2024-11-14T14:08:47.243Z | 2024-11-21T14:25:52.900Z |
5520421 | 5520421 | 20241111154527_Loemj | NZ0032 | 2024-11-12T14:06:18.402Z | 2024-11-20T14:25:08.668Z |
5520343 | 5520343 | 20241111152428_6jOX3 | NZ0032 | 2024-11-12T14:06:11.176Z | 2024-11-20T14:25:07.113Z |
5520242 | 5520242 | 20241111150214_JhEn1 | NZ0032 | 2024-11-12T14:06:01.200Z | 2024-11-20T14:25:06.264Z |
5520193 | 5520193 | 20241111145659_ufmNX | NZ0032 | 2024-11-12T14:05:56.300Z | 2024-11-20T14:25:05.714Z |
5520077 | 5520077 | 20241111143215_UWtYG | NZ0032 | 2024-11-12T14:05:33.872Z | 2024-11-20T14:25:03.116Z |
5520062 | 5520062 | 20241111142733_H2x3r | NZ0032 | 2024-11-12T14:05:32.305Z | 2024-11-20T14:25:02.864Z |
5520023 | 5520023 | 20241111142242_CUy8e | NZ0032 | 2024-11-12T14:05:29.256Z | 2024-11-20T14:25:02.500Z |
5520016 | 5520016 | 20241111142025_bVtgU | NZ0032 | 2024-11-12T14:05:28.355Z | 2024-11-20T14:25:01.986Z |
5519991 | 5519991 | 20241111141220_ptuz6 | NZ0032 | 2024-11-12T14:05:26.171Z | 2024-11-20T14:25:01.503Z |
5519926 | 5519926 | 20241111135510_S7Rdy | NZ0032 | 2024-11-12T14:05:19.895Z | 2024-11-20T14:25:00.646Z |
5519912 | 5519912 | 20241111135436_F2m2n | NZ0032 | 2024-11-12T14:05:19.166Z | 2024-11-20T14:25:00.624Z |
5519892 | 5519892 | 20241111135023_qWDNe | NZ0032 | 2024-11-12T14:05:17.769Z | 2024-11-20T14:25:00.489Z |
5519870 | 5519870 | 20241111133908_uqsbC | NZ0032 | 2024-11-12T14:05:14.137Z | 2024-11-20T14:25:00.270Z |
5519847 | 5519847 | 20241111133357_LKSgP | NZ0032 | 2024-11-12T14:05:10.709Z | 2024-11-20T14:24:59.856Z |
5519841 | 5519841 | 20241111133240_lxTVi | NZ0032 | 2024-11-12T14:05:09.950Z | 2024-11-20T14:24:59.789Z |
5519838 | 5519838 | 20241111132956_j7z3f | NZ0032 | 2024-11-12T14:05:09.260Z | 2024-11-20T14:24:58.973Z |
5519803 | 5519803 | 20241111130833_57jJo | NZ0032 | 2024-11-12T14:05:03.371Z | 2024-11-20T14:24:58.096Z |
5519729 | 5519729 | 20241111124316_MCI32 | NZ0032 | 2024-11-12T14:04:51.495Z | 2024-11-20T14:24:56.259Z |
5514369 | 5514369 | 20241110153950_PravH | NZ0032 | 2024-11-11T14:06:33.144Z | 2024-11-19T14:21:46.844Z |
5514328 | 5514328 | 20241110153109_iPgkf | NZ0032 | 2024-11-11T14:06:29.705Z | 2024-11-19T14:21:46.385Z |
5514191 | 5514191 | 20241110150404_u1VmX | NZ0032 | 2024-11-11T14:06:19.667Z | 2024-11-19T14:21:44.707Z |
5514132 | 5514132 | 20241110143926_bJM1a | NZ0032 | 2024-11-11T14:06:14.993Z | 2024-11-19T14:21:43.997Z |
5514087 | 5514087 | 20241110141904_2A6Mt | NZ0032 | 2024-11-11T14:06:04.903Z | 2024-11-19T14:21:43.284Z |
5513849 | 5513849 | 20241110123029_3kWWt | NZ0032 | 2024-11-11T14:05:32.566Z | 2024-11-19T14:21:38.805Z |
5513278 | 5513278 | 20241110110902_YsvAp | NZ0032 | 2024-11-11T14:04:20.350Z | 2024-11-19T14:21:32.653Z |
5513173 | 5513173 | 20241110105104_tzlGS | NZ0032 | 2024-11-11T14:04:02.251Z | 2024-11-19T14:21:31.769Z |
5493987 | 5493987 | 20241107150452_huW9q | NZ0032 | 2024-11-08T14:05:12.659Z | 2024-11-16T14:27:44.451Z |
5493968 | 5493968 | 20241107145432_Y2q0g | NZ0032 | 2024-11-08T14:05:07.036Z | 2024-11-16T14:27:43.938Z |
5493937 | 5493937 | 20241107144224_4Qphq | NZ0032 | 2024-11-08T14:04:59.760Z | 2024-11-16T14:27:43.459Z |
5493926 | 5493926 | 20241107143818_k5tUa | NZ0032 | 2024-11-08T14:04:56.718Z | 2024-11-16T14:27:43.305Z |
5493722 | 5493722 | 20241107131055_606jS | NZ0032 | 2024-11-08T14:04:32.130Z | 2024-11-16T14:27:39.633Z |
5493691 | 5493691 | 20241107130318_9oCsd | NZ0032 | 2024-11-08T14:04:30.195Z | 2024-11-16T14:27:39.087Z |
5493687 | 5493687 | 20241107130145_TTNmD | NZ0032 | 2024-11-08T14:04:29.821Z | 2024-11-16T14:27:39.072Z |
5493569 | 5493569 | 20241107123722_35ui5 | NZ0032 | 2024-11-08T14:04:06.445Z | 2024-11-16T14:27:36.119Z |
5493516 | 5493516 | 20241107122343_G35DV | NZ0032 | 2024-11-08T14:03:56.381Z | 2024-11-16T14:27:35.233Z |
5493279 | 5493279 | 20241107113319_7hzkB | NZ0032 | 2024-11-08T14:03:27.591Z | 2024-11-16T14:27:33.275Z |
5493218 | 5493218 | 20241107111904_I0ruc | NZ0032 | 2024-11-08T14:03:11.428Z | 2024-11-16T14:27:33.044Z |
5493163 | 5493163 | 20241107111140_9PA3E | NZ0032 | 2024-11-08T14:03:00.194Z | 2024-11-16T14:27:32.634Z |
5493132 | 5493132 | 20241107110132_3r7bN | NZ0032 | 2024-11-08T14:02:56.242Z | 2024-11-16T14:27:32.211Z |
5493057 | 5493057 | 20241107104555_5YSy3 | NZ0032 | 2024-11-08T14:02:47.372Z | 2024-11-16T14:27:31.768Z |
5492990 | 5492990 | 20241107103118_Ewhme | NZ0032 | 2024-11-08T14:02:40.678Z | 2024-11-16T14:27:31.370Z |
5492644 | 5492644 | 20241107092336_1tUv6 | NZ0032 | 2024-11-08T14:01:43.427Z | 2024-11-16T14:27:27.188Z |
5492609 | 5492609 | 20241107091608_vsp5z | NZ0032 | 2024-11-08T14:01:33.425Z | 2024-11-16T14:27:27.021Z |
5492603 | 5492603 | 20241107091413_dAwVz | NZ0032 | 2024-11-08T14:01:32.438Z | 2024-11-16T14:27:27.000Z |
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);