participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
284 rows where station_code = "NZ000J" 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 |
---|---|---|---|---|---|
5071566 | 5071566 | 20240911171811_7CE60 | NZ000J | 2024-09-15T12:02:59.147Z | 2024-09-20T12:21:21.710Z |
5070475 | 5070475 | 20240909125823_2PCz6 | NZ000J | 2024-09-14T12:21:21.994Z | 2024-09-17T12:19:12.520Z |
5062113 | 5062113 | 20240909164524_lQtdb | NZ000J | 2024-09-14T12:11:49.799Z | 2024-09-18T12:15:10.405Z |
5061935 | 5061935 | 20240909162455_oeTN8 | NZ000J | 2024-09-14T12:11:39.837Z | 2024-09-18T12:15:10.170Z |
5061913 | 5061913 | 20240909162251_FojmG | NZ000J | 2024-09-14T12:11:38.549Z | 2024-09-18T12:15:10.155Z |
5061335 | 5061335 | 20240909145008_Zthqj | NZ000J | 2024-09-14T12:10:43.061Z | 2024-09-18T12:15:08.938Z |
5058550 | 5058550 | 20240910162347_feZLl | NZ000J | 2024-09-14T12:03:56.652Z | 2024-09-19T12:21:29.711Z |
5050096 | 5050096 | 20240909124619_ID5lk | NZ000J | 2024-09-13T12:12:39.900Z | 2024-09-17T12:19:12.322Z |
5044610 | 5044610 | 20240908152151_KVvvR | NZ000J | 2024-09-13T12:02:31.295Z | 2024-09-17T12:18:54.753Z |
5044240 | 5044240 | 20240908143341_2wobL | NZ000J | 2024-09-13T12:01:44.599Z | 2024-09-17T12:18:53.885Z |
5044232 | 5044232 | 20240908143255_Ul00A | NZ000J | 2024-09-13T12:01:43.838Z | 2024-09-17T12:18:53.864Z |
5035770 | 5035770 | 20240907102009_oRS3q | NZ000J | 2024-09-12T12:12:27.929Z | 2024-09-15T12:21:41.173Z |
5035454 | 5035454 | 20240907093206_B2FB3 | NZ000J | 2024-09-12T12:12:06.001Z | 2024-09-15T12:21:39.620Z |
5035425 | 5035425 | 20240907092815_XVxYl | NZ000J | 2024-09-12T12:12:04.333Z | 2024-09-15T12:21:39.583Z |
5017180 | 5017180 | 20240904153839_O447f | NZ000J | 2024-09-10T12:08:54.661Z | 2024-09-13T12:19:46.629Z |
5016979 | 5016979 | 20240904151755_w8EP7 | NZ000J | 2024-09-10T12:08:36.401Z | 2024-09-13T12:19:46.482Z |
5016864 | 5016864 | 20240904150716_adkMj | NZ000J | 2024-09-10T12:08:26.472Z | 2024-09-13T12:19:46.400Z |
5003817 | 5003817 | 20240903100015_y3P5v | NZ000J | 2024-09-09T12:02:06.617Z | 2024-09-12T12:18:59.440Z |
5003275 | 5003275 | 20240904113122_9Mzaf | NZ000J | 2024-09-09T12:01:31.427Z | 2024-09-13T12:19:43.951Z |
4994954 | 4994954 | 20240902154234_7F2i2 | NZ000J | 2024-09-08T12:03:07.933Z | 2024-09-11T12:20:40.657Z |
4994587 | 4994587 | 20240902143622_udO2K | NZ000J | 2024-09-08T12:02:44.165Z | 2024-09-11T12:20:35.413Z |
4994568 | 4994568 | 20240902143224_cJrdi | NZ000J | 2024-09-08T12:02:42.844Z | 2024-09-11T12:20:35.115Z |
4993077 | 4993077 | 20240902094641_CbNEU | NZ000J | 2024-09-08T12:01:09.933Z | 2024-09-11T12:20:20.207Z |
4992798 | 4992798 | 20240902085720_Totii | NZ000J | 2024-09-08T12:00:51.960Z | 2024-09-11T12:20:17.398Z |
4910304 | 4910304 | 20240809175624_L7Qxk | NZ000J | 2024-08-29T12:06:03.304Z | 2024-09-02T12:20:38.622Z |
4909974 | 4909974 | 20240809173447_JiyF2 | NZ000J | 2024-08-29T12:05:42.439Z | 2024-09-02T12:20:28.014Z |
4909742 | 4909742 | 20240809171855_4W3tp | NZ000J | 2024-08-29T12:05:26.866Z | 2024-09-02T12:20:21.523Z |
4908298 | 4908298 | 20240809153107_qmhIA | NZ000J | 2024-08-29T12:03:57.457Z | 2024-09-02T12:19:09.515Z |
4908266 | 4908266 | 20240809152722_4eG97 | NZ000J | 2024-08-29T12:03:55.234Z | 2024-09-02T12:19:08.470Z |
4907687 | 4907687 | 20240809144237_XwRQH | NZ000J | 2024-08-29T12:03:18.643Z | 2024-09-02T12:18:37.932Z |
4907307 | 4907307 | 20240809140827_Yfw9T | NZ000J | 2024-08-29T12:02:52.749Z | 2024-09-02T12:18:18.184Z |
4907292 | 4907292 | 20240809140543_vUXS3 | NZ000J | 2024-08-29T12:02:51.819Z | 2024-09-02T12:18:17.784Z |
4906572 | 4906572 | 20240809125220_3fruF | NZ000J | 2024-08-29T12:02:01.205Z | 2024-09-02T12:17:42.586Z |
4906520 | 4906520 | 20240809124635_48zcg | NZ000J | 2024-08-29T12:01:57.740Z | 2024-09-02T12:17:40.792Z |
4906133 | 4906133 | 20240809120651_SXvjM | NZ000J | 2024-08-29T12:01:29.643Z | 2024-09-02T12:17:27.381Z |
4905840 | 4905840 | 20240809112944_x8CyM | NZ000J | 2024-08-29T12:01:03.733Z | 2024-09-02T12:17:16.515Z |
4905541 | 4905541 | 20240809110233_J42FO | NZ000J | 2024-08-29T12:00:33.983Z | 2024-09-02T12:16:50.922Z |
4893599 | 4893599 | 20240809101435_t3z2Y | NZ000J | 2024-08-28T12:11:34.476Z | 2024-08-30T12:23:03.029Z |
4893165 | 4893165 | 20240809084935_p4ssk | NZ000J | 2024-08-28T12:11:04.772Z | 2024-08-30T12:22:48.831Z |
4885508 | 4885508 | 20240808102722_wKop3 | NZ000J | 2024-08-28T12:00:46.585Z | 2024-08-30T12:15:36.543Z |
4870380 | 4870380 | 20240806175821_NOLmd | NZ000J | 2024-08-19T12:07:50.621Z | 2024-08-27T12:08:44.646Z |
4869838 | 4869838 | 20240806173339_XENXL | NZ000J | 2024-08-19T12:07:20.924Z | 2024-08-27T12:08:21.924Z |
4869506 | 4869506 | 20240806172056_3V2fK | NZ000J | 2024-08-19T12:07:10.850Z | 2024-08-27T12:08:10.923Z |
4867374 | 4867374 | 20240806163829_JLxii | NZ000J | 2024-08-18T12:08:42.182Z | 2024-08-27T12:07:34.696Z |
4867288 | 4867288 | 20240806163417_iVtTn | NZ000J | 2024-08-18T12:08:39.370Z | 2024-08-27T12:07:31.641Z |
4867234 | 4867234 | 20240806163202_SfS7S | NZ000J | 2024-08-18T12:08:37.366Z | 2024-08-27T12:07:30.168Z |
4865987 | 4865987 | 20240806152531_oAvsL | NZ000J | 2024-08-18T12:07:19.512Z | 2024-08-27T12:06:37.546Z |
4864767 | 4864767 | 20240806143058_987iP | NZ000J | 2024-08-18T12:06:17.140Z | 2024-08-27T12:05:48.952Z |
4864322 | 4864322 | 20240806141213_hZ4gE | NZ000J | 2024-08-18T12:06:01.591Z | 2024-08-27T12:05:34.451Z |
4863549 | 4863549 | 20240806132930_lvyK8 | NZ000J | 2024-08-18T12:05:16.212Z | 2024-08-27T12:05:00.172Z |
4863356 | 4863356 | 20240806131942_dxJ6w | NZ000J | 2024-08-18T12:05:10.155Z | 2024-08-27T12:04:51.638Z |
4863347 | 4863347 | 20240806131915_3hWj7 | NZ000J | 2024-08-18T12:05:09.843Z | 2024-08-27T12:04:50.998Z |
4863124 | 4863124 | 20240806130832_Rt37R | NZ000J | 2024-08-18T12:05:01.867Z | 2024-08-27T12:04:40.238Z |
4862811 | 4862811 | 20240806125313_1YNXH | NZ000J | 2024-08-18T12:04:41.372Z | 2024-08-27T12:04:30.737Z |
4862707 | 4862707 | 20240806124757_uRI7l | NZ000J | 2024-08-18T12:04:37.346Z | 2024-08-27T12:04:26.781Z |
4861931 | 4861931 | 20240806120418_bfqP4 | NZ000J | 2024-08-18T12:04:02.831Z | 2024-08-27T12:03:53.435Z |
4861309 | 4861309 | 20240806112937_qZS10 | NZ000J | 2024-08-18T12:03:33.809Z | 2024-08-27T12:03:27.660Z |
4859387 | 4859387 | 20240806093620_swnCr | NZ000J | 2024-08-18T12:01:47.849Z | 2024-08-27T12:01:53.087Z |
4859270 | 4859270 | 20240806092838_YJiuZ | NZ000J | 2024-08-18T12:01:42.328Z | 2024-08-27T12:01:47.923Z |
4859133 | 4859133 | 20240806091659_BzfRP | NZ000J | 2024-08-18T12:01:30.811Z | 2024-08-27T12:01:39.365Z |
4858044 | 4858044 | 20240806075050_vCgBZ | NZ000J | 2024-08-18T12:00:22.495Z | 2024-08-27T12:00:32.185Z |
4848469 | 4848469 | 20240805170913_sUhMB | NZ000J | 2024-08-17T12:10:36.968Z | 2024-08-19T12:21:23.463Z |
4846625 | 4846625 | 20240805162124_a3bl1 | NZ000J | 2024-08-16T12:10:26.676Z | 2024-08-19T12:20:57.363Z |
4845963 | 4845963 | 20240805155650_9j3d3 | NZ000J | 2024-08-16T12:09:39.973Z | 2024-08-19T12:20:42.038Z |
4843999 | 4843999 | 20240805144704_AxvSH | NZ000J | 2024-08-16T12:07:48.403Z | 2024-08-19T12:19:11.259Z |
4843427 | 4843427 | 20240805141928_Fhj5N | NZ000J | 2024-08-16T12:07:21.855Z | 2024-08-19T12:18:52.357Z |
4842188 | 4842188 | 20240805132212_wpGe6 | NZ000J | 2024-08-16T12:06:11.430Z | 2024-08-19T12:18:29.177Z |
4842135 | 4842135 | 20240805132001_bnJUg | NZ000J | 2024-08-16T12:06:09.253Z | 2024-08-19T12:18:28.284Z |
4841611 | 4841611 | 20240805125058_1E21Q | NZ000J | 2024-08-16T12:05:37.948Z | 2024-08-19T12:18:04.901Z |
4840551 | 4840551 | 20240805113917_DR83H | NZ000J | 2024-08-16T12:04:41.807Z | 2024-08-19T12:17:12.405Z |
4840459 | 4840459 | 20240805112923_2Nzy2 | NZ000J | 2024-08-16T12:04:33.059Z | 2024-08-19T12:17:09.326Z |
4816904 | 4816904 | 20240803182424_JmT5Y | NZ000J | 2024-08-13T12:14:39.590Z | 2024-08-15T12:23:07.894Z |
4816543 | 4816543 | 20240803180355_aSBS6 | NZ000J | 2024-08-13T12:14:22.983Z | 2024-08-15T12:23:00.734Z |
4816318 | 4816318 | 20240803174914_GNYJ8 | NZ000J | 2024-08-13T12:14:11.915Z | 2024-08-15T12:22:57.345Z |
4814818 | 4814818 | 20240803164156_Arewv | NZ000J | 2024-08-13T12:13:02.696Z | 2024-08-15T12:22:21.757Z |
4813598 | 4813598 | 20240803154906_oDbLB | NZ000J | 2024-08-13T12:12:06.723Z | 2024-08-15T12:21:37.535Z |
4810912 | 4810912 | 20240803134523_7phs5 | NZ000J | 2024-08-13T12:09:17.795Z | 2024-08-15T12:20:16.907Z |
4810406 | 4810406 | 20240803130939_A0RTT | NZ000J | 2024-08-13T12:08:30.066Z | 2024-08-15T12:20:00.769Z |
4808822 | 4808822 | 20240803112133_DSgrW | NZ000J | 2024-08-13T12:06:14.066Z | 2024-08-15T12:19:21.491Z |
4808616 | 4808616 | 20240803111105_6Yhmb | NZ000J | 2024-08-13T12:05:43.207Z | 2024-08-15T12:19:12.965Z |
4807453 | 4807453 | 20240803100024_wIlHo | NZ000J | 2024-08-13T12:03:17.885Z | 2024-08-15T12:18:29.178Z |
4767066 | 4767066 | 20240731141945_Vkipc | NZ000J | 2024-08-06T12:08:56.283Z | 2024-08-10T12:19:38.234Z |
4767051 | 4767051 | 20240731141806_iSyvZ | NZ000J | 2024-08-06T12:08:55.892Z | 2024-08-10T12:19:37.838Z |
4689310 | 4689310 | 20240724182606_pQ2TO | NZ000J | 2024-07-26T12:11:27.866Z | 2024-08-01T12:12:08.807Z |
4685712 | 4685712 | 20240725100332_KxVs9 | NZ000J | 2024-07-26T12:06:01.166Z | 2024-08-02T12:24:47.568Z |
4685609 | 4685609 | 20240725094722_OrFoC | NZ000J | 2024-07-26T12:05:44.842Z | 2024-08-02T12:24:46.414Z |
4685239 | 4685239 | 20240725083252_r2pac | NZ000J | 2024-07-26T12:05:15.326Z | 2024-08-02T12:24:39.405Z |
4679457 | 4679457 | 20240723150313_Sx2WL | NZ000J | 2024-07-24T12:05:42.264Z | 2024-07-31T12:18:06.283Z |
4679279 | 4679279 | 20240723135418_t3iZF | NZ000J | 2024-07-24T12:05:18.320Z | 2024-07-31T12:18:05.407Z |
4659415 | 4659415 | 20240718125013_4Gm0l | NZ000J | 2024-07-19T12:00:14.788Z | 2024-07-27T12:16:46.305Z |
4653336 | 4653336 | 20240716171029_BWF4o | NZ000J | 2024-07-18T12:03:03.659Z | 2024-07-25T12:13:44.508Z |
4653028 | 4653028 | 20240716161636_oGOMO | NZ000J | 2024-07-18T12:02:27.613Z | 2024-07-25T12:13:42.638Z |
4652988 | 4652988 | 20240716161045_I4sBW | NZ000J | 2024-07-18T12:02:25.021Z | 2024-07-25T12:13:42.315Z |
4652888 | 4652888 | 20240716154557_D4S5F | NZ000J | 2024-07-18T12:02:18.150Z | 2024-07-25T12:13:41.801Z |
4652883 | 4652883 | 20240716154457_03fbj | NZ000J | 2024-07-18T12:02:17.768Z | 2024-07-25T12:13:41.783Z |
4645623 | 4645623 | 20240714173343_HEOoI | NZ000J | 2024-07-17T12:04:23.550Z | 2024-07-23T12:08:37.005Z |
4645563 | 4645563 | 20240714171811_gAWzZ | NZ000J | 2024-07-17T12:04:17.594Z | 2024-07-23T12:08:36.918Z |
4645467 | 4645467 | 20240714165406_8D0Y8 | NZ000J | 2024-07-17T12:04:10.553Z | 2024-07-23T12:08:36.702Z |
4645350 | 4645350 | 20240714161840_53q3J | NZ000J | 2024-07-17T12:04:02.907Z | 2024-07-23T12:08:36.489Z |
4645220 | 4645220 | 20240714153712_jkJw4 | NZ000J | 2024-07-17T12:03:56.346Z | 2024-07-23T12:08:36.247Z |
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);