participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,175 rows where station_code = "NZ0004" 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 |
---|---|---|---|---|---|
5459724 | 5459724 | 20241101114343_zMsTU | NZ0004 | 2024-11-03T14:12:30.958Z | 2024-11-03T14:19:33.406Z |
5459150 | 5459150 | 20241101101620_h1K7J | NZ0004 | 2024-11-03T14:11:25.202Z | 2024-11-03T14:19:33.281Z |
5459106 | 5459106 | 20241101100824_Pt74c | NZ0004 | 2024-11-03T14:11:20.708Z | 2024-11-03T14:19:33.270Z |
5458701 | 5458701 | 20241101090419_NXfAv | NZ0004 | 2024-11-03T14:10:29.168Z | 2024-11-03T14:19:33.179Z |
5458625 | 5458625 | 20241101085012_cOz8Q | NZ0004 | 2024-11-03T14:10:10.578Z | 2024-11-03T14:19:33.162Z |
5449651 | 5449651 | 20241031160421_SvJDw | NZ0004 | 2024-11-02T12:13:16.626Z | 2024-11-03T14:20:55.940Z |
5449359 | 5449359 | 20241031152440_OW8MU | NZ0004 | 2024-11-02T12:12:44.985Z | 2024-11-03T14:20:51.968Z |
5449301 | 5449301 | 20241031151752_wqN1W | NZ0004 | 2024-11-02T12:12:27.889Z | 2024-11-03T14:20:51.066Z |
5449289 | 5449289 | 20241031151711_zI31l | NZ0004 | 2024-11-02T12:12:26.616Z | 2024-11-03T14:20:50.917Z |
5449185 | 5449185 | 20241031150254_ovnly | NZ0004 | 2024-11-02T12:12:14.035Z | 2024-11-03T14:20:49.356Z |
5449169 | 5449169 | 20241031150153_6rg4X | NZ0004 | 2024-11-02T12:12:12.769Z | 2024-11-03T14:20:49.317Z |
5449101 | 5449101 | 20241031145400_ALHz9 | NZ0004 | 2024-11-02T12:12:05.504Z | 2024-11-03T14:20:48.693Z |
5449029 | 5449029 | 20241031144431_4cmd0 | NZ0004 | 2024-11-02T12:11:59.268Z | 2024-11-03T14:20:47.476Z |
5448860 | 5448860 | 20241031142537_pxap3 | NZ0004 | 2024-11-02T12:11:35.289Z | 2024-11-03T14:20:43.613Z |
5448777 | 5448777 | 20241031141528_v2wAk | NZ0004 | 2024-11-02T12:11:25.698Z | 2024-11-03T14:20:42.048Z |
5448738 | 5448738 | 20241031141212_9gS30 | NZ0004 | 2024-11-02T12:11:23.105Z | 2024-11-03T14:20:41.863Z |
5448662 | 5448662 | 20241031140230_qnR3u | NZ0004 | 2024-11-02T12:11:16.385Z | 2024-11-03T14:20:41.035Z |
5448595 | 5448595 | 20241031135133_EjGv3 | NZ0004 | 2024-11-02T12:11:10.037Z | 2024-11-03T14:20:40.064Z |
5448557 | 5448557 | 20241031134611_DEn2g | NZ0004 | 2024-11-02T12:11:05.712Z | 2024-11-03T14:20:39.560Z |
5448545 | 5448545 | 20241031134556_d9d53 | NZ0004 | 2024-11-02T12:11:03.161Z | 2024-11-03T14:20:39.264Z |
5448513 | 5448513 | 20241031134147_pu6mD | NZ0004 | 2024-11-02T12:10:59.125Z | 2024-11-03T14:20:39.063Z |
5448491 | 5448491 | 20241031133740_YvoEL | NZ0004 | 2024-11-02T12:10:52.378Z | 2024-11-03T14:20:38.636Z |
5448441 | 5448441 | 20241031133226_UhOh3 | NZ0004 | 2024-11-02T12:10:46.579Z | 2024-11-03T14:20:37.908Z |
5448427 | 5448427 | 20241031133113_H0o8D | NZ0004 | 2024-11-02T12:10:45.500Z | 2024-11-03T14:20:37.676Z |
5448295 | 5448295 | 20241031130838_fWjks | NZ0004 | 2024-11-02T12:10:30.181Z | 2024-11-03T14:20:35.108Z |
5448198 | 5448198 | 20241031125833_pRl3S | NZ0004 | 2024-11-02T12:10:15.049Z | 2024-11-03T14:20:34.105Z |
5447850 | 5447850 | 20241031121644_CVd3O | NZ0004 | 2024-11-02T12:09:18.090Z | 2024-11-03T14:20:29.510Z |
5447665 | 5447665 | 20241031120045_8nmVt | NZ0004 | 2024-11-02T12:08:46.505Z | 2024-11-03T14:20:26.128Z |
5447661 | 5447661 | 20241031120042_7WZOm | NZ0004 | 2024-11-02T12:08:46.193Z | 2024-11-03T14:20:26.104Z |
5447425 | 5447425 | 20241031114031_uHJPR | NZ0004 | 2024-11-02T12:08:08.703Z | 2024-11-03T14:20:22.039Z |
5447365 | 5447365 | 20241031113534_O3gQJ | NZ0004 | 2024-11-02T12:08:00.893Z | 2024-11-03T14:20:21.285Z |
5447009 | 5447009 | 20241031105637_v259J | NZ0004 | 2024-11-02T12:06:55.249Z | 2024-11-03T14:20:13.528Z |
5446671 | 5446671 | 20241031102044_rESW3 | NZ0004 | 2024-11-02T12:06:01.258Z | 2024-11-03T14:20:05.834Z |
5445435 | 5445435 | 20241031080257_2JaD2 | NZ0004 | 2024-11-02T12:02:03.112Z | 2024-11-03T14:19:41.970Z |
5437841 | 5437841 | 20241030155044_doOHv | NZ0004 | 2024-11-01T12:10:28.406Z | 2024-11-03T14:22:40.693Z |
5437838 | 5437838 | 20241030154958_R1q32 | NZ0004 | 2024-11-01T12:10:27.676Z | 2024-11-03T14:22:40.672Z |
5437679 | 5437679 | 20241030153442_C3qct | NZ0004 | 2024-11-01T12:10:11.442Z | 2024-11-03T14:22:40.276Z |
5437397 | 5437397 | 20241030150320_xf2tb | NZ0004 | 2024-11-01T12:09:31.872Z | 2024-11-03T14:22:39.428Z |
5437336 | 5437336 | 20241030145707_rt3Ib | NZ0004 | 2024-11-01T12:09:25.978Z | 2024-11-03T14:22:39.217Z |
5437248 | 5437248 | 20241030144814_wA8AZ | NZ0004 | 2024-11-01T12:09:17.704Z | 2024-11-03T14:22:38.945Z |
5437198 | 5437198 | 20241030144129_IyZhc | NZ0004 | 2024-11-01T12:09:13.850Z | 2024-11-03T14:22:38.863Z |
5437135 | 5437135 | 20241030143153_j5DOV | NZ0004 | 2024-11-01T12:09:07.442Z | 2024-11-03T14:22:38.701Z |
5436891 | 5436891 | 20241030140307_nYBul | NZ0004 | 2024-11-01T12:08:32.458Z | 2024-11-03T14:22:37.975Z |
5436830 | 5436830 | 20241030135514_3dJ7l | NZ0004 | 2024-11-01T12:08:27.012Z | 2024-11-03T14:22:37.847Z |
5436793 | 5436793 | 20241030134834_vAbAA | NZ0004 | 2024-11-01T12:08:21.756Z | 2024-11-03T14:22:37.734Z |
5436717 | 5436717 | 20241030134127_6vg53 | NZ0004 | 2024-11-01T12:08:07.671Z | 2024-11-03T14:22:37.574Z |
5436298 | 5436298 | 20241030124753_Qct3P | NZ0004 | 2024-11-01T12:07:15.146Z | 2024-11-03T14:22:36.169Z |
5436247 | 5436247 | 20241030124147_wk3yU | NZ0004 | 2024-11-01T12:07:10.255Z | 2024-11-03T14:22:36.001Z |
5435876 | 5435876 | 20241030120718_Xwlut | NZ0004 | 2024-11-01T12:06:16.791Z | 2024-11-03T14:22:34.380Z |
5435826 | 5435826 | 20241030120135_X2JjT | NZ0004 | 2024-11-01T12:06:01.423Z | 2024-11-03T14:22:34.204Z |
5435658 | 5435658 | 20241030114807_LWv6U | NZ0004 | 2024-11-01T12:05:43.890Z | 2024-11-03T14:22:33.464Z |
5435511 | 5435511 | 20241030113648_G6jwE | NZ0004 | 2024-11-01T12:05:20.818Z | 2024-11-03T14:22:33.019Z |
5435505 | 5435505 | 20241030113538_HPUpF | NZ0004 | 2024-11-01T12:05:19.989Z | 2024-11-03T14:22:32.990Z |
5435302 | 5435302 | 20241030111512_gYv2u | NZ0004 | 2024-11-01T12:04:46.252Z | 2024-11-03T14:22:31.946Z |
5435289 | 5435289 | 20241030111411_Y1N4o | NZ0004 | 2024-11-01T12:04:42.649Z | 2024-11-03T14:22:31.898Z |
5434931 | 5434931 | 20241030102656_eXCK8 | NZ0004 | 2024-11-01T12:03:48.054Z | 2024-11-03T14:22:27.906Z |
5434892 | 5434892 | 20241030102301_Ni0WB | NZ0004 | 2024-11-01T12:03:41.942Z | 2024-11-03T14:22:27.109Z |
5434681 | 5434681 | 20241030100224_xV1XQ | NZ0004 | 2024-11-01T12:03:08.799Z | 2024-11-03T14:22:25.507Z |
5434440 | 5434440 | 20241030092521_qe0z2 | NZ0004 | 2024-11-01T12:02:24.844Z | 2024-11-03T14:22:21.464Z |
5427467 | 5427467 | 20241028150849_BK34P | NZ0004 | 2024-10-31T12:13:33.467Z | 2024-11-03T14:24:47.780Z |
5427269 | 5427269 | 20241028145249_eH0vh | NZ0004 | 2024-10-31T12:13:23.525Z | 2024-11-03T14:24:46.428Z |
5427238 | 5427238 | 20241028144942_yC3ne | NZ0004 | 2024-10-31T12:13:21.945Z | 2024-11-03T14:24:46.393Z |
5426710 | 5426710 | 20241028134534_BUN91 | NZ0004 | 2024-10-31T12:12:23.446Z | 2024-11-03T14:24:44.562Z |
5426646 | 5426646 | 20241028133832_k2IV4 | NZ0004 | 2024-10-31T12:12:19.097Z | 2024-11-03T14:24:44.306Z |
5426588 | 5426588 | 20241028133008_mdr6C | NZ0004 | 2024-10-31T12:12:15.143Z | 2024-11-03T14:24:43.946Z |
5424713 | 5424713 | 20241029150408_7J4Xw | NZ0004 | 2024-10-31T12:05:53.533Z | 2024-11-03T14:23:38.595Z |
5424243 | 5424243 | 20241029134624_Ijrsf | NZ0004 | 2024-10-31T12:04:23.011Z | 2024-11-03T14:23:35.662Z |
5422587 | 5422587 | 20241028131957_ILUxQ | NZ0004 | 2024-10-30T12:20:28.284Z | 2024-11-03T14:24:42.919Z |
5422408 | 5422408 | 20241028125953_wbzeD | NZ0004 | 2024-10-30T12:20:26.421Z | 2024-11-03T14:24:42.055Z |
5422344 | 5422344 | 20241028125147_nLlxQ | NZ0004 | 2024-10-30T12:20:25.678Z | 2024-11-03T14:24:41.905Z |
5422307 | 5422307 | 20241028124727_opbUa | NZ0004 | 2024-10-30T12:20:25.344Z | 2024-11-03T14:24:41.861Z |
5422131 | 5422131 | 20241028121919_FlSlv | NZ0004 | 2024-10-30T12:20:22.621Z | 2024-11-03T14:24:41.101Z |
5421880 | 5421880 | 20241028115537_QrlbK | NZ0004 | 2024-10-30T12:20:17.035Z | 2024-11-03T14:24:39.670Z |
5421777 | 5421777 | 20241028113649_Iu3ba | NZ0004 | 2024-10-30T12:20:14.836Z | 2024-11-03T14:24:39.222Z |
5421612 | 5421612 | 20241028111121_vuVYb | NZ0004 | 2024-10-30T12:20:09.063Z | 2024-11-03T14:24:38.711Z |
5421573 | 5421573 | 20241028110301_YlSVb | NZ0004 | 2024-10-30T12:20:07.454Z | 2024-11-03T14:24:38.480Z |
5414977 | 5414977 | 20241027123753_CzUpZ | NZ0004 | 2024-10-30T12:08:45.359Z | 2024-11-03T14:25:38.504Z |
5414227 | 5414227 | 20241027111706_RLLJe | NZ0004 | 2024-10-30T12:06:59.118Z | 2024-11-03T14:25:35.891Z |
5413981 | 5413981 | 20241027105242_4666o | NZ0004 | 2024-10-30T12:06:24.271Z | 2024-11-03T14:25:35.243Z |
5413706 | 5413706 | 20241028104948_wjzbw | NZ0004 | 2024-10-30T12:04:00.984Z | 2024-11-03T14:24:37.984Z |
5413483 | 5413483 | 20241028100648_Qp6DQ | NZ0004 | 2024-10-30T12:03:16.699Z | 2024-11-03T14:24:36.098Z |
5413458 | 5413458 | 20241028100329_21Fb3 | NZ0004 | 2024-10-30T12:03:07.527Z | 2024-11-03T14:24:35.689Z |
5413093 | 5413093 | 20241028084922_0Foh9 | NZ0004 | 2024-10-30T12:01:49.711Z | 2024-11-03T14:24:32.115Z |
5412902 | 5412902 | 20241028080315_fORPE | NZ0004 | 2024-10-30T12:01:07.194Z | 2024-11-03T14:24:30.100Z |
5411942 | 5411942 | 20241027094146_1A36W | NZ0004 | 2024-10-29T12:19:20.226Z | 2024-11-03T14:25:32.176Z |
5411844 | 5411844 | 20241027093251_JLbh3 | NZ0004 | 2024-10-29T12:19:15.647Z | 2024-11-03T14:25:31.856Z |
5411523 | 5411523 | 20241027085022_h4LJQ | NZ0004 | 2024-10-29T12:18:58.208Z | 2024-11-03T14:25:30.375Z |
5411502 | 5411502 | 20241027084856_tH9YF | NZ0004 | 2024-10-29T12:18:57.131Z | 2024-11-03T14:25:30.341Z |
5411351 | 5411351 | 20241027082819_SuXaG | NZ0004 | 2024-10-29T12:18:44.519Z | 2024-11-03T14:25:29.914Z |
5392315 | 5392315 | 20241026155229_DVahb | NZ0004 | 2024-10-28T12:07:42.980Z | 2024-11-03T14:26:18.004Z |
5392186 | 5392186 | 20241026152732_LWSVe | NZ0004 | 2024-10-28T12:07:19.118Z | 2024-11-03T14:26:16.825Z |
5392183 | 5392183 | 20241026152710_8W3f2 | NZ0004 | 2024-10-28T12:07:18.845Z | 2024-11-03T14:26:16.824Z |
5359925 | 5359925 | 20241023150315_KZhET | NZ0004 | 2024-10-25T12:09:37.733Z | 2024-11-01T12:26:46.874Z |
5359908 | 5359908 | 20241023150050_w5RJU | NZ0004 | 2024-10-25T12:09:36.492Z | 2024-11-01T12:26:46.865Z |
5359874 | 5359874 | 20241023145710_6MX8f | NZ0004 | 2024-10-25T12:09:34.454Z | 2024-11-01T12:26:46.827Z |
5359843 | 5359843 | 20241023145148_AtJHr | NZ0004 | 2024-10-25T12:09:30.814Z | 2024-11-01T12:26:46.787Z |
5359544 | 5359544 | 20241023135738_zJRYu | NZ0004 | 2024-10-25T12:08:46.711Z | 2024-11-01T12:26:45.816Z |
5359522 | 5359522 | 20241023135613_uD13Y | NZ0004 | 2024-10-25T12:08:44.931Z | 2024-11-01T12:26:45.785Z |
5359519 | 5359519 | 20241023135531_EKTs6 | NZ0004 | 2024-10-25T12:08:44.728Z | 2024-11-01T12:26:45.784Z |
5359485 | 5359485 | 20241023134727_36DwD | NZ0004 | 2024-10-25T12:08:41.499Z | 2024-11-01T12:26:45.745Z |
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);