participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,794 rows where station_code = "NZ004H" 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 |
---|---|---|---|---|---|
5461032 | 5461032 | 20241101153733_TAdNa | NZ004H | 2024-11-03T14:14:39.958Z | 2024-11-03T14:19:33.658Z |
5460999 | 5460999 | 20241101153159_a2SFD | NZ004H | 2024-11-03T14:14:38.286Z | 2024-11-03T14:19:33.651Z |
5460966 | 5460966 | 20241101152616_vWeTS | NZ004H | 2024-11-03T14:14:37.253Z | 2024-11-03T14:19:33.647Z |
5460964 | 5460964 | 20241101152608_jsrdM | NZ004H | 2024-11-03T14:14:37.075Z | 2024-11-03T14:19:33.646Z |
5460895 | 5460895 | 20241101151805_abeBA | NZ004H | 2024-11-03T14:14:33.204Z | 2024-11-03T14:19:33.633Z |
5460874 | 5460874 | 20241101151532_BEz93 | NZ004H | 2024-11-03T14:14:32.310Z | 2024-11-03T14:19:33.628Z |
5460781 | 5460781 | 20241101150217_3UIS2 | NZ004H | 2024-11-03T14:14:24.814Z | 2024-11-03T14:19:33.612Z |
5460740 | 5460740 | 20241101145745_Fx2DV | NZ004H | 2024-11-03T14:14:19.217Z | 2024-11-03T14:19:33.605Z |
5460494 | 5460494 | 20241101142325_A4ici | NZ004H | 2024-11-03T14:13:51.387Z | 2024-11-03T14:19:33.561Z |
5460474 | 5460474 | 20241101141600_cBejC | NZ004H | 2024-11-03T14:13:47.720Z | 2024-11-03T14:19:33.555Z |
5460425 | 5460425 | 20241101140512_4NYFz | NZ004H | 2024-11-03T14:13:43.165Z | 2024-11-03T14:19:33.542Z |
5460323 | 5460323 | 20241101134757_E0qe4 | NZ004H | 2024-11-03T14:13:35.907Z | 2024-11-03T14:19:33.523Z |
5460274 | 5460274 | 20241101132827_FgKmF | NZ004H | 2024-11-03T14:13:32.167Z | 2024-11-03T14:19:33.511Z |
5459153 | 5459153 | 20241101101620_h1K7J | NZ004H | 2024-11-03T14:11:25.202Z | 2024-11-03T14:19:33.281Z |
5458703 | 5458703 | 20241101090419_NXfAv | NZ004H | 2024-11-03T14:10:29.168Z | 2024-11-03T14:19:33.179Z |
5449304 | 5449304 | 20241031151752_wqN1W | NZ004H | 2024-11-02T12:12:27.889Z | 2024-11-03T14:20:51.066Z |
5449286 | 5449286 | 20241031151702_5r0vi | NZ004H | 2024-11-02T12:12:25.517Z | 2024-11-03T14:20:50.901Z |
5449212 | 5449212 | 20241031150522_wsWPJ | NZ004H | 2024-11-02T12:12:18.067Z | 2024-11-03T14:20:49.500Z |
5449175 | 5449175 | 20241031150153_6rg4X | NZ004H | 2024-11-02T12:12:12.769Z | 2024-11-03T14:20:49.317Z |
5449104 | 5449104 | 20241031145400_ALHz9 | NZ004H | 2024-11-02T12:12:05.504Z | 2024-11-03T14:20:48.693Z |
5449032 | 5449032 | 20241031144431_4cmd0 | NZ004H | 2024-11-02T12:11:59.268Z | 2024-11-03T14:20:47.476Z |
5448797 | 5448797 | 20241031141705_0JqFB | NZ004H | 2024-11-02T12:11:27.610Z | 2024-11-03T14:20:42.139Z |
5448598 | 5448598 | 20241031135133_EjGv3 | NZ004H | 2024-11-02T12:11:10.037Z | 2024-11-03T14:20:40.064Z |
5448561 | 5448561 | 20241031134611_DEn2g | NZ004H | 2024-11-02T12:11:05.712Z | 2024-11-03T14:20:39.560Z |
5448433 | 5448433 | 20241031133113_H0o8D | NZ004H | 2024-11-02T12:10:45.501Z | 2024-11-03T14:20:37.676Z |
5448298 | 5448298 | 20241031130838_fWjks | NZ004H | 2024-11-02T12:10:30.181Z | 2024-11-03T14:20:35.108Z |
5447887 | 5447887 | 20241031122035_ERL3O | NZ004H | 2024-11-02T12:09:23.460Z | 2024-11-03T14:20:29.879Z |
5447667 | 5447667 | 20241031120045_8nmVt | NZ004H | 2024-11-02T12:08:46.505Z | 2024-11-03T14:20:26.128Z |
5447633 | 5447633 | 20241031115754_4D9PE | NZ004H | 2024-11-02T12:08:43.420Z | 2024-11-03T14:20:25.641Z |
5447368 | 5447368 | 20241031113534_O3gQJ | NZ004H | 2024-11-02T12:08:00.894Z | 2024-11-03T14:20:21.285Z |
5446675 | 5446675 | 20241031102044_rESW3 | NZ004H | 2024-11-02T12:06:01.258Z | 2024-11-03T14:20:05.834Z |
5445437 | 5445437 | 20241031080257_2JaD2 | NZ004H | 2024-11-02T12:02:03.134Z | 2024-11-03T14:19:41.970Z |
5437684 | 5437684 | 20241030153442_C3qct | NZ004H | 2024-11-01T12:10:11.442Z | 2024-11-03T14:22:40.276Z |
5437342 | 5437342 | 20241030145707_rt3Ib | NZ004H | 2024-11-01T12:09:25.978Z | 2024-11-03T14:22:39.218Z |
5437252 | 5437252 | 20241030144814_wA8AZ | NZ004H | 2024-11-01T12:09:17.704Z | 2024-11-03T14:22:38.946Z |
5437164 | 5437164 | 20241030143608_Ijyat | NZ004H | 2024-11-01T12:09:11.303Z | 2024-11-03T14:22:38.803Z |
5436893 | 5436893 | 20241030140307_nYBul | NZ004H | 2024-11-01T12:08:32.458Z | 2024-11-03T14:22:37.975Z |
5436837 | 5436837 | 20241030135514_3dJ7l | NZ004H | 2024-11-01T12:08:27.012Z | 2024-11-03T14:22:37.847Z |
5436797 | 5436797 | 20241030134834_vAbAA | NZ004H | 2024-11-01T12:08:21.756Z | 2024-11-03T14:22:37.734Z |
5436722 | 5436722 | 20241030134127_6vg53 | NZ004H | 2024-11-01T12:08:07.672Z | 2024-11-03T14:22:37.574Z |
5436459 | 5436459 | 20241030131013_7EpAd | NZ004H | 2024-11-01T12:07:42.439Z | 2024-11-03T14:22:36.714Z |
5436443 | 5436443 | 20241030130801_NPrOa | NZ004H | 2024-11-01T12:07:38.563Z | 2024-11-03T14:22:36.660Z |
5436300 | 5436300 | 20241030124753_Qct3P | NZ004H | 2024-11-01T12:07:15.146Z | 2024-11-03T14:22:36.170Z |
5436250 | 5436250 | 20241030124147_wk3yU | NZ004H | 2024-11-01T12:07:10.255Z | 2024-11-03T14:22:36.001Z |
5435879 | 5435879 | 20241030120718_Xwlut | NZ004H | 2024-11-01T12:06:16.791Z | 2024-11-03T14:22:34.380Z |
5435831 | 5435831 | 20241030120135_X2JjT | NZ004H | 2024-11-01T12:06:01.423Z | 2024-11-03T14:22:34.204Z |
5435664 | 5435664 | 20241030114807_LWv6U | NZ004H | 2024-11-01T12:05:43.890Z | 2024-11-03T14:22:33.464Z |
5435305 | 5435305 | 20241030111512_gYv2u | NZ004H | 2024-11-01T12:04:46.253Z | 2024-11-03T14:22:31.946Z |
5435225 | 5435225 | 20241030110626_SLJb7 | NZ004H | 2024-11-01T12:04:33.400Z | 2024-11-03T14:22:31.623Z |
5435126 | 5435126 | 20241030105212_kN3bl | NZ004H | 2024-11-01T12:04:20.970Z | 2024-11-03T14:22:30.434Z |
5434934 | 5434934 | 20241030102656_eXCK8 | NZ004H | 2024-11-01T12:03:48.054Z | 2024-11-03T14:22:27.906Z |
5434514 | 5434514 | 20241030093734_4n244 | NZ004H | 2024-11-01T12:02:33.912Z | 2024-11-03T14:22:23.257Z |
5434442 | 5434442 | 20241030092521_qe0z2 | NZ004H | 2024-11-01T12:02:24.868Z | 2024-11-03T14:22:21.464Z |
5427836 | 5427836 | 20241028155044_vX6q4 | NZ004H | 2024-10-31T12:14:04.176Z | 2024-11-03T14:24:48.943Z |
5427298 | 5427298 | 20241028145446_lOT11 | NZ004H | 2024-10-31T12:13:24.939Z | 2024-11-03T14:24:46.549Z |
5427270 | 5427270 | 20241028145249_eH0vh | NZ004H | 2024-10-31T12:13:23.525Z | 2024-11-03T14:24:46.428Z |
5427241 | 5427241 | 20241028144942_yC3ne | NZ004H | 2024-10-31T12:13:21.946Z | 2024-11-03T14:24:46.393Z |
5427158 | 5427158 | 20241028143807_yKjpo | NZ004H | 2024-10-31T12:13:17.035Z | 2024-11-03T14:24:46.294Z |
5426907 | 5426907 | 20241028140848_bFbOa | NZ004H | 2024-10-31T12:12:37.286Z | 2024-11-03T14:24:45.395Z |
5426711 | 5426711 | 20241028134534_BUN91 | NZ004H | 2024-10-31T12:12:23.446Z | 2024-11-03T14:24:44.562Z |
5426648 | 5426648 | 20241028133832_k2IV4 | NZ004H | 2024-10-31T12:12:19.097Z | 2024-11-03T14:24:44.306Z |
5426591 | 5426591 | 20241028133008_mdr6C | NZ004H | 2024-10-31T12:12:15.143Z | 2024-11-03T14:24:43.946Z |
5424357 | 5424357 | 20241029140651_D6PYS | NZ004H | 2024-10-31T12:04:41.524Z | 2024-11-03T14:23:36.145Z |
5424244 | 5424244 | 20241029134624_Ijrsf | NZ004H | 2024-10-31T12:04:23.026Z | 2024-11-03T14:23:35.662Z |
5422591 | 5422591 | 20241028131957_ILUxQ | NZ004H | 2024-10-30T12:20:28.284Z | 2024-11-03T14:24:42.919Z |
5422413 | 5422413 | 20241028125953_wbzeD | NZ004H | 2024-10-30T12:20:26.422Z | 2024-11-03T14:24:42.055Z |
5422346 | 5422346 | 20241028125147_nLlxQ | NZ004H | 2024-10-30T12:20:25.678Z | 2024-11-03T14:24:41.905Z |
5422333 | 5422333 | 20241028124941_Hb23r | NZ004H | 2024-10-30T12:20:25.520Z | 2024-11-03T14:24:41.894Z |
5422013 | 5422013 | 20241028120843_jtPx7 | NZ004H | 2024-10-30T12:20:20.164Z | 2024-11-03T14:24:40.081Z |
5421883 | 5421883 | 20241028115537_QrlbK | NZ004H | 2024-10-30T12:20:17.035Z | 2024-11-03T14:24:39.670Z |
5421577 | 5421577 | 20241028110301_YlSVb | NZ004H | 2024-10-30T12:20:07.454Z | 2024-11-03T14:24:38.480Z |
5415284 | 5415284 | 20241027133458_nj6m3 | NZ004H | 2024-10-30T12:09:30.981Z | 2024-11-03T14:25:39.435Z |
5415181 | 5415181 | 20241027131518_zdQan | NZ004H | 2024-10-30T12:09:09.390Z | 2024-11-03T14:25:39.146Z |
5415093 | 5415093 | 20241027130043_2alsG | NZ004H | 2024-10-30T12:08:56.950Z | 2024-11-03T14:25:38.927Z |
5415052 | 5415052 | 20241027125102_OHxJt | NZ004H | 2024-10-30T12:08:52.265Z | 2024-11-03T14:25:38.820Z |
5414979 | 5414979 | 20241027123753_CzUpZ | NZ004H | 2024-10-30T12:08:45.359Z | 2024-11-03T14:25:38.504Z |
5414514 | 5414514 | 20241027114844_caC2b | NZ004H | 2024-10-30T12:07:35.982Z | 2024-11-03T14:25:36.435Z |
5414231 | 5414231 | 20241027111706_RLLJe | NZ004H | 2024-10-30T12:06:59.119Z | 2024-11-03T14:25:35.892Z |
5413984 | 5413984 | 20241027105242_4666o | NZ004H | 2024-10-30T12:06:24.271Z | 2024-11-03T14:25:35.243Z |
5413914 | 5413914 | 20241027104215_TKbKr | NZ004H | 2024-10-30T12:06:08.674Z | 2024-11-03T14:25:34.923Z |
5413533 | 5413533 | 20241028101424_sS4G8 | NZ004H | 2024-10-30T12:03:23.968Z | 2024-11-03T14:24:36.488Z |
5413486 | 5413486 | 20241028100648_Qp6DQ | NZ004H | 2024-10-30T12:03:16.699Z | 2024-11-03T14:24:36.098Z |
5413247 | 5413247 | 20241028091913_vMIw0 | NZ004H | 2024-10-30T12:02:22.449Z | 2024-11-03T14:24:33.657Z |
5413096 | 5413096 | 20241028084922_0Foh9 | NZ004H | 2024-10-30T12:01:49.711Z | 2024-11-03T14:24:32.115Z |
5412904 | 5412904 | 20241028080315_fORPE | NZ004H | 2024-10-30T12:01:07.225Z | 2024-11-03T14:24:30.100Z |
5411956 | 5411956 | 20241027094433_caZpu | NZ004H | 2024-10-29T12:19:20.701Z | 2024-11-03T14:25:32.200Z |
5411944 | 5411944 | 20241027094146_1A36W | NZ004H | 2024-10-29T12:19:20.226Z | 2024-11-03T14:25:32.176Z |
5411846 | 5411846 | 20241027093251_JLbh3 | NZ004H | 2024-10-29T12:19:15.647Z | 2024-11-03T14:25:31.856Z |
5411352 | 5411352 | 20241027082819_SuXaG | NZ004H | 2024-10-29T12:18:44.589Z | 2024-11-03T14:25:29.914Z |
5392376 | 5392376 | 20241026161536_DhxHC | NZ004H | 2024-10-28T12:07:48.915Z | 2024-11-03T14:26:18.118Z |
5392188 | 5392188 | 20241026152732_LWSVe | NZ004H | 2024-10-28T12:07:19.118Z | 2024-11-03T14:26:16.825Z |
5368394 | 5368394 | 20241024091720_5oV5Y | NZ004H | 2024-10-26T12:03:27.046Z | 2024-11-02T12:28:15.505Z |
5368390 | 5368390 | 20241024091655_y06TM | NZ004H | 2024-10-26T12:03:26.259Z | 2024-11-02T12:28:15.502Z |
5368330 | 5368330 | 20241024090612_9WED4 | NZ004H | 2024-10-26T12:03:11.082Z | 2024-11-02T12:28:15.395Z |
5360368 | 5360368 | 20241023160555_UC0jb | NZ004H | 2024-10-25T12:10:41.326Z | 2024-11-01T12:26:47.395Z |
5360321 | 5360321 | 20241023155715_rruJi | NZ004H | 2024-10-25T12:10:32.340Z | 2024-11-01T12:26:47.363Z |
5360064 | 5360064 | 20241023152122_Id5ix | NZ004H | 2024-10-25T12:10:06.598Z | 2024-11-01T12:26:47.028Z |
5360049 | 5360049 | 20241023151938_6nxNj | NZ004H | 2024-10-25T12:10:05.359Z | 2024-11-01T12:26:47.021Z |
5360030 | 5360030 | 20241023151617_Ee0RA | NZ004H | 2024-10-25T12:10:02.548Z | 2024-11-01T12:26:47.014Z |
5359927 | 5359927 | 20241023150315_KZhET | NZ004H | 2024-10-25T12:09:37.733Z | 2024-11-01T12:26:46.874Z |
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);