participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,585 rows where station_code = "NZ001J" 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 |
---|---|---|---|---|---|
4869980 | 4869980 | 20240806174016_6a3lX | NZ001J | 2024-08-19T12:07:26.478Z | 2024-08-27T12:08:25.843Z |
4869905 | 4869905 | 20240806173641_o23u2 | NZ001J | 2024-08-19T12:07:23.400Z | 2024-08-27T12:08:23.991Z |
4869628 | 4869628 | 20240806172435_OuQMa | NZ001J | 2024-08-19T12:07:14.135Z | 2024-08-27T12:08:14.142Z |
4869550 | 4869550 | 20240806172158_X0YQ0 | NZ001J | 2024-08-19T12:07:12.288Z | 2024-08-27T12:08:12.189Z |
4869492 | 4869492 | 20240806172015_XaNvY | NZ001J | 2024-08-19T12:07:10.445Z | 2024-08-27T12:08:10.610Z |
4869479 | 4869479 | 20240806171926_nNPgW | NZ001J | 2024-08-19T12:07:09.917Z | 2024-08-27T12:08:10.077Z |
4869129 | 4869129 | 20240806170213_QDGqW | NZ001J | 2024-08-19T12:06:49.388Z | 2024-08-27T12:07:56.303Z |
4867664 | 4867664 | 20240806165638_V2Rrz | NZ001J | 2024-08-18T12:08:52.865Z | 2024-08-27T12:07:48.047Z |
4867640 | 4867640 | 20240806165553_3pQd8 | NZ001J | 2024-08-18T12:08:51.645Z | 2024-08-27T12:07:47.126Z |
4867508 | 4867508 | 20240806164739_LgGJS | NZ001J | 2024-08-18T12:08:47.566Z | 2024-08-27T12:07:40.332Z |
4867309 | 4867309 | 20240806163504_zeHqH | NZ001J | 2024-08-18T12:08:40.082Z | 2024-08-27T12:07:32.518Z |
4867245 | 4867245 | 20240806163246_dNJ7v | NZ001J | 2024-08-18T12:08:38.184Z | 2024-08-27T12:07:30.585Z |
4867204 | 4867204 | 20240806163047_2Uk80 | NZ001J | 2024-08-18T12:08:35.470Z | 2024-08-27T12:07:29.569Z |
4867056 | 4867056 | 20240806162202_EKTB3 | NZ001J | 2024-08-18T12:08:21.046Z | 2024-08-27T12:07:24.355Z |
4866365 | 4866365 | 20240806154351_r4a2p | NZ001J | 2024-08-18T12:07:32.490Z | 2024-08-27T12:06:53.872Z |
4866076 | 4866076 | 20240806152851_gm4MH | NZ001J | 2024-08-18T12:07:22.186Z | 2024-08-27T12:06:40.809Z |
4865976 | 4865976 | 20240806152425_tmqMm | NZ001J | 2024-08-18T12:07:19.283Z | 2024-08-27T12:06:37.226Z |
4865962 | 4865962 | 20240806152411_9arLT | NZ001J | 2024-08-18T12:07:19.008Z | 2024-08-27T12:06:36.967Z |
4865888 | 4865888 | 20240806151916_vP6yL | NZ001J | 2024-08-18T12:07:17.060Z | 2024-08-27T12:06:35.125Z |
4865823 | 4865823 | 20240806151547_6m4vJ | NZ001J | 2024-08-18T12:07:15.060Z | 2024-08-27T12:06:31.512Z |
4865619 | 4865619 | 20240806150811_BCLpa | NZ001J | 2024-08-18T12:07:08.943Z | 2024-08-27T12:06:25.879Z |
4865348 | 4865348 | 20240806145619_wD6SI | NZ001J | 2024-08-18T12:06:46.922Z | 2024-08-27T12:06:17.417Z |
4864855 | 4864855 | 20240806143518_peSj7 | NZ001J | 2024-08-18T12:06:20.236Z | 2024-08-27T12:05:51.681Z |
4864823 | 4864823 | 20240806143323_Rawoi | NZ001J | 2024-08-18T12:06:18.835Z | 2024-08-27T12:05:50.427Z |
4864599 | 4864599 | 20240806142454_HJR3I | NZ001J | 2024-08-18T12:06:11.530Z | 2024-08-27T12:05:44.003Z |
4864447 | 4864447 | 20240806141751_kc3mG | NZ001J | 2024-08-18T12:06:05.714Z | 2024-08-27T12:05:38.546Z |
4864289 | 4864289 | 20240806141014_hIehF | NZ001J | 2024-08-18T12:06:00.545Z | 2024-08-27T12:05:33.151Z |
4864097 | 4864097 | 20240806135732_Aj5rw | NZ001J | 2024-08-18T12:05:40.548Z | 2024-08-27T12:05:20.569Z |
4864025 | 4864025 | 20240806135419_001uK | NZ001J | 2024-08-18T12:05:34.290Z | 2024-08-27T12:05:17.380Z |
4863619 | 4863619 | 20240806133242_TSZG3 | NZ001J | 2024-08-18T12:05:18.689Z | 2024-08-27T12:05:03.164Z |
4863539 | 4863539 | 20240806132854_n0jbU | NZ001J | 2024-08-18T12:05:15.889Z | 2024-08-27T12:04:59.408Z |
4863501 | 4863501 | 20240806132721_3tVtj | NZ001J | 2024-08-18T12:05:14.830Z | 2024-08-27T12:04:55.748Z |
4863493 | 4863493 | 20240806132710_ESbfa | NZ001J | 2024-08-18T12:05:14.630Z | 2024-08-27T12:04:55.565Z |
4863403 | 4863403 | 20240806132215_0EdkR | NZ001J | 2024-08-18T12:05:11.933Z | 2024-08-27T12:04:53.101Z |
4862748 | 4862748 | 20240806125055_agAek | NZ001J | 2024-08-18T12:04:38.571Z | 2024-08-27T12:04:28.866Z |
4862639 | 4862639 | 20240806124349_J2mDY | NZ001J | 2024-08-18T12:04:34.751Z | 2024-08-27T12:04:23.332Z |
4862370 | 4862370 | 20240806122722_K4YHn | NZ001J | 2024-08-18T12:04:24.646Z | 2024-08-27T12:04:11.046Z |
4862189 | 4862189 | 20240806121955_zzKYI | NZ001J | 2024-08-18T12:04:19.266Z | 2024-08-27T12:04:05.095Z |
4861878 | 4861878 | 20240806120228_OBxhr | NZ001J | 2024-08-18T12:03:59.635Z | 2024-08-27T12:03:52.216Z |
4861860 | 4861860 | 20240806120144_C8aeu | NZ001J | 2024-08-18T12:03:58.793Z | 2024-08-27T12:03:51.584Z |
4861718 | 4861718 | 20240806115039_u3AA8 | NZ001J | 2024-08-18T12:03:52.506Z | 2024-08-27T12:03:45.504Z |
4861626 | 4861626 | 20240806114452_lXXn1 | NZ001J | 2024-08-18T12:03:48.544Z | 2024-08-27T12:03:41.331Z |
4861584 | 4861584 | 20240806114329_DAVi7 | NZ001J | 2024-08-18T12:03:47.453Z | 2024-08-27T12:03:40.083Z |
4860934 | 4860934 | 20240806111110_rRoYK | NZ001J | 2024-08-18T12:03:14.061Z | 2024-08-27T12:03:12.543Z |
4860913 | 4860913 | 20240806110932_co8t5 | NZ001J | 2024-08-18T12:03:13.552Z | 2024-08-27T12:03:12.036Z |
4860352 | 4860352 | 20240806103548_UqsT3 | NZ001J | 2024-08-18T12:02:40.624Z | 2024-08-27T12:02:42.267Z |
4860299 | 4860299 | 20240806103017_zzmet | NZ001J | 2024-08-18T12:02:38.036Z | 2024-08-27T12:02:38.715Z |
4860206 | 4860206 | 20240806102532_rzhsS | NZ001J | 2024-08-18T12:02:34.846Z | 2024-08-27T12:02:34.927Z |
4859934 | 4859934 | 20240806100931_6mW01 | NZ001J | 2024-08-18T12:02:19.785Z | 2024-08-27T12:02:22.056Z |
4859922 | 4859922 | 20240806100915_jVITj | NZ001J | 2024-08-18T12:02:19.664Z | 2024-08-27T12:02:21.925Z |
4859594 | 4859594 | 20240806094929_hHJAb | NZ001J | 2024-08-18T12:01:58.967Z | 2024-08-27T12:02:03.756Z |
4859333 | 4859333 | 20240806093344_6sA0e | NZ001J | 2024-08-18T12:01:45.983Z | 2024-08-27T12:01:51.604Z |
4859120 | 4859120 | 20240806091616_P8y3M | NZ001J | 2024-08-18T12:01:30.644Z | 2024-08-27T12:01:39.210Z |
4858002 | 4858002 | 20240806074554_2PWVc | NZ001J | 2024-08-18T12:00:18.694Z | 2024-08-27T12:00:28.870Z |
4849617 | 4849617 | 20240805175705_XmoTy | NZ001J | 2024-08-17T12:12:00.765Z | 2024-08-19T12:22:23.472Z |
4849353 | 4849353 | 20240805174456_5FF8J | NZ001J | 2024-08-17T12:11:37.435Z | 2024-08-19T12:22:10.193Z |
4849005 | 4849005 | 20240805173055_w9ZWf | NZ001J | 2024-08-17T12:11:15.844Z | 2024-08-19T12:21:51.067Z |
4848939 | 4848939 | 20240805172755_ChUA7 | NZ001J | 2024-08-17T12:11:07.139Z | 2024-08-19T12:21:48.537Z |
4848800 | 4848800 | 20240805172300_2OU9l | NZ001J | 2024-08-17T12:10:58.820Z | 2024-08-19T12:21:42.612Z |
4848721 | 4848721 | 20240805171917_WscHG | NZ001J | 2024-08-17T12:10:54.210Z | 2024-08-19T12:21:39.229Z |
4848695 | 4848695 | 20240805171822_GG64A | NZ001J | 2024-08-17T12:10:52.713Z | 2024-08-19T12:21:37.661Z |
4846582 | 4846582 | 20240805162031_4Lpr8 | NZ001J | 2024-08-16T12:10:25.494Z | 2024-08-19T12:20:56.850Z |
4846448 | 4846448 | 20240805161442_AmDPz | NZ001J | 2024-08-16T12:10:16.846Z | 2024-08-19T12:20:54.196Z |
4844783 | 4844783 | 20240805151320_AAYkU | NZ001J | 2024-08-16T12:08:36.796Z | 2024-08-19T12:19:48.756Z |
4844440 | 4844440 | 20240805150133_IDl6W | NZ001J | 2024-08-16T12:08:17.190Z | 2024-08-19T12:19:31.721Z |
4844300 | 4844300 | 20240805145741_vsUYa | NZ001J | 2024-08-16T12:08:09.164Z | 2024-08-19T12:19:26.720Z |
4843698 | 4843698 | 20240805143516_1F3Au | NZ001J | 2024-08-16T12:07:37.668Z | 2024-08-19T12:18:59.261Z |
4843627 | 4843627 | 20240805143045_iSKMr | NZ001J | 2024-08-16T12:07:35.710Z | 2024-08-19T12:18:56.886Z |
4843578 | 4843578 | 20240805142833_cc9Bb | NZ001J | 2024-08-16T12:07:33.652Z | 2024-08-19T12:18:55.941Z |
4843537 | 4843537 | 20240805142702_FwJmy | NZ001J | 2024-08-16T12:07:31.812Z | 2024-08-19T12:18:55.114Z |
4843464 | 4843464 | 20240805142202_vxM1O | NZ001J | 2024-08-16T12:07:25.272Z | 2024-08-19T12:18:53.736Z |
4843351 | 4843351 | 20240805141658_sB1m7 | NZ001J | 2024-08-16T12:07:12.848Z | 2024-08-19T12:18:49.310Z |
4842935 | 4842935 | 20240805140057_2NGDn | NZ001J | 2024-08-16T12:06:48.087Z | 2024-08-19T12:18:40.675Z |
4842687 | 4842687 | 20240805134857_H7hca | NZ001J | 2024-08-16T12:06:39.561Z | 2024-08-19T12:18:37.066Z |
4842633 | 4842633 | 20240805134524_sd3rs | NZ001J | 2024-08-16T12:06:36.297Z | 2024-08-19T12:18:36.348Z |
4842511 | 4842511 | 20240805134001_I0vTn | NZ001J | 2024-08-16T12:06:25.494Z | 2024-08-19T12:18:34.018Z |
4842443 | 4842443 | 20240805133531_HPHvI | NZ001J | 2024-08-16T12:06:23.237Z | 2024-08-19T12:18:33.192Z |
4842388 | 4842388 | 20240805133255_52zrX | NZ001J | 2024-08-16T12:06:21.594Z | 2024-08-19T12:18:32.432Z |
4842362 | 4842362 | 20240805133229_zuIAs | NZ001J | 2024-08-16T12:06:20.862Z | 2024-08-19T12:18:32.084Z |
4842024 | 4842024 | 20240805131407_opv2E | NZ001J | 2024-08-16T12:06:03.487Z | 2024-08-19T12:18:23.508Z |
4841946 | 4841946 | 20240805131001_ibmV9 | NZ001J | 2024-08-16T12:05:59.460Z | 2024-08-19T12:18:19.314Z |
4841868 | 4841868 | 20240805130450_3Tu83 | NZ001J | 2024-08-16T12:05:55.516Z | 2024-08-19T12:18:15.741Z |
4841676 | 4841676 | 20240805125516_THHqa | NZ001J | 2024-08-16T12:05:40.348Z | 2024-08-19T12:18:08.334Z |
4841616 | 4841616 | 20240805125140_gAKaI | NZ001J | 2024-08-16T12:05:38.126Z | 2024-08-19T12:18:05.217Z |
4841535 | 4841535 | 20240805124514_8VJ7Z | NZ001J | 2024-08-16T12:05:31.053Z | 2024-08-19T12:18:00.618Z |
4841325 | 4841325 | 20240805123459_5lEL5 | NZ001J | 2024-08-16T12:05:21.193Z | 2024-08-19T12:17:49.471Z |
4841128 | 4841128 | 20240805121959_IbzBB | NZ001J | 2024-08-16T12:05:13.467Z | 2024-08-19T12:17:40.196Z |
4840726 | 4840726 | 20240805114936_5IWsj | NZ001J | 2024-08-16T12:04:47.107Z | 2024-08-19T12:17:19.367Z |
4840708 | 4840708 | 20240805114918_FK8XG | NZ001J | 2024-08-16T12:04:46.893Z | 2024-08-19T12:17:19.158Z |
4840433 | 4840433 | 20240805112825_QzaCx | NZ001J | 2024-08-16T12:04:31.351Z | 2024-08-19T12:17:08.977Z |
4840240 | 4840240 | 20240805111625_2aE93 | NZ001J | 2024-08-16T12:04:19.039Z | 2024-08-19T12:17:01.516Z |
4840223 | 4840223 | 20240805111542_VmkMO | NZ001J | 2024-08-16T12:04:18.363Z | 2024-08-19T12:17:01.106Z |
4840133 | 4840133 | 20240805110906_c4R9V | NZ001J | 2024-08-16T12:04:14.681Z | 2024-08-19T12:16:59.510Z |
4840061 | 4840061 | 20240805110142_CI2z0 | NZ001J | 2024-08-16T12:04:10.390Z | 2024-08-19T12:16:57.605Z |
4839715 | 4839715 | 20240805104023_NsC3h | NZ001J | 2024-08-16T12:03:45.497Z | 2024-08-19T12:16:49.738Z |
4839602 | 4839602 | 20240805103354_1SOuf | NZ001J | 2024-08-16T12:03:38.246Z | 2024-08-19T12:16:47.555Z |
4838934 | 4838934 | 20240805094005_cWiyz | NZ001J | 2024-08-16T12:02:55.885Z | 2024-08-19T12:16:13.264Z |
4838817 | 4838817 | 20240805093137_0S8pV | NZ001J | 2024-08-16T12:02:50.366Z | 2024-08-19T12:16:09.214Z |
4838145 | 4838145 | 20240805083105_PUage | NZ001J | 2024-08-16T12:01:53.165Z | 2024-08-19T12:15:35.250Z |
4837972 | 4837972 | 20240805081140_4I7eN | NZ001J | 2024-08-16T12:01:38.611Z | 2024-08-19T12:15:30.192Z |
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);