participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
312 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 |
---|---|---|---|---|---|
5569400 | 5569400 | 20241121152326_GboZq | NZ000J | 2024-11-22T14:10:50.930Z | 2024-11-22T14:10:50.930Z |
5569170 | 5569170 | 20241121144634_o12WJ | NZ000J | 2024-11-22T14:10:26.427Z | 2024-11-22T14:10:26.427Z |
5569063 | 5569063 | 20241121142558_GLZoW | NZ000J | 2024-11-22T14:10:16.400Z | 2024-11-22T14:10:16.400Z |
5568595 | 5568595 | 20241121131018_kEEW1 | NZ000J | 2024-11-22T14:09:24.457Z | 2024-11-22T14:09:24.457Z |
5560906 | 5560906 | 20241120151821_4Uy8S | NZ000J | 2024-11-21T14:09:57.293Z | 2024-11-22T14:19:21.758Z |
5551589 | 5551589 | 20241118142151_S5SRt | NZ000J | 2024-11-19T14:05:01.788Z | 2024-11-22T14:22:11.530Z |
5551542 | 5551542 | 20241118141121_UPKrd | NZ000J | 2024-11-19T14:04:58.364Z | 2024-11-22T14:22:11.373Z |
5547233 | 5547233 | 20241117151207_GZExJ | NZ000J | 2024-11-18T14:05:19.302Z | 2024-11-22T14:22:38.108Z |
5547108 | 5547108 | 20241117144541_s3hlN | NZ000J | 2024-11-18T14:05:03.909Z | 2024-11-22T14:22:36.981Z |
5544780 | 5544780 | 20241116152042_QPehb | NZ000J | 2024-11-17T14:02:06.059Z | 2024-11-22T14:23:06.277Z |
5544716 | 5544716 | 20241116144454_kJOf2 | NZ000J | 2024-11-17T14:01:54.453Z | 2024-11-22T14:23:05.912Z |
5542859 | 5542859 | 20241115150438_Pc5ln | NZ000J | 2024-11-16T14:02:47.575Z | 2024-11-22T14:23:32.093Z |
5536066 | 5536066 | 20241112153329_sAw56 | NZ000J | 2024-11-14T14:09:09.886Z | 2024-11-21T14:25:56.453Z |
5520366 | 5520366 | 20241111152927_NXksg | NZ000J | 2024-11-12T14:06:13.519Z | 2024-11-20T14:25:07.634Z |
5520337 | 5520337 | 20241111152345_4SbRe | NZ000J | 2024-11-12T14:06:10.770Z | 2024-11-20T14:25:07.030Z |
5520098 | 5520098 | 20241111143649_roGsM | NZ000J | 2024-11-12T14:05:37.002Z | 2024-11-20T14:25:03.745Z |
5520000 | 5520000 | 20241111141750_J0WQO | NZ000J | 2024-11-12T14:05:27.373Z | 2024-11-20T14:25:01.888Z |
5519659 | 5519659 | 20241111122235_Lxis1 | NZ000J | 2024-11-12T14:04:41.605Z | 2024-11-20T14:24:54.697Z |
5514425 | 5514425 | 20241110155025_bbhX3 | NZ000J | 2024-11-11T14:06:36.954Z | 2024-11-19T14:21:47.762Z |
5511517 | 5511517 | 20241105131439_NweEJ | NZ000J | 2024-11-10T14:22:45.079Z | 2024-11-14T14:23:04.438Z |
5487254 | 5487254 | 20241106152449_F8xUR | NZ000J | 2024-11-07T14:05:23.966Z | 2024-11-15T14:24:38.631Z |
5487153 | 5487153 | 20241106145914_SCNeu | NZ000J | 2024-11-07T14:05:03.305Z | 2024-11-15T14:24:37.593Z |
5486661 | 5486661 | 20241106124555_iUaqa | NZ000J | 2024-11-07T14:03:42.770Z | 2024-11-15T14:24:32.950Z |
5480782 | 5480782 | 20241105154038_qSSzZ | NZ000J | 2024-11-06T14:06:35.284Z | 2024-11-14T14:23:06.671Z |
5480690 | 5480690 | 20241105145219_Hiahj | NZ000J | 2024-11-06T14:06:21.146Z | 2024-11-14T14:23:05.644Z |
5480632 | 5480632 | 20241105142227_XAUxs | NZ000J | 2024-11-06T14:06:06.937Z | 2024-11-14T14:23:05.367Z |
5480596 | 5480596 | 20241105141211_NfFaJ | NZ000J | 2024-11-06T14:06:01.248Z | 2024-11-14T14:23:05.156Z |
5480472 | 5480472 | 20241105131106_309Xi | NZ000J | 2024-11-06T14:05:45.886Z | 2024-11-14T14:23:04.397Z |
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 |
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);