participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
762 rows where station_code = "US004N" 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 |
---|---|---|---|---|---|
5524736 | 5524736 | 20241111052449_kjVip | US004N | 2024-11-12T14:17:58.560Z | 2024-11-12T14:18:08.755Z |
5524549 | 5524549 | 20241111043121_axkqE | US004N | 2024-11-12T14:17:39.586Z | 2024-11-12T14:18:08.676Z |
5524540 | 5524540 | 20241111042914_ld40p | US004N | 2024-11-12T14:17:37.298Z | 2024-11-12T14:18:08.671Z |
5524398 | 5524398 | 20241111040751_wrZ3l | US004N | 2024-11-12T14:17:15.261Z | 2024-11-12T14:18:08.602Z |
5524101 | 5524101 | 20241111031409_MpfwY | US004N | 2024-11-12T14:16:32.502Z | 2024-11-12T14:18:08.470Z |
5519619 | 5519619 | 20241111121531_06y9w | US004N | 2024-11-12T14:04:36.900Z | 2024-11-12T14:04:36.900Z |
5519552 | 5519552 | 20241111115853_zmbGN | US004N | 2024-11-12T14:04:29.823Z | 2024-11-12T14:04:29.823Z |
5519488 | 5519488 | 20241111113621_2UbvT | US004N | 2024-11-12T14:04:12.866Z | 2024-11-12T14:04:12.866Z |
5519427 | 5519427 | 20241111112110_r0ra9 | US004N | 2024-11-12T14:03:59.068Z | 2024-11-12T14:03:59.068Z |
5519389 | 5519389 | 20241111111457_Wjv84 | US004N | 2024-11-12T14:03:54.640Z | 2024-11-12T14:03:54.640Z |
5519350 | 5519350 | 20241111110434_gnYX1 | US004N | 2024-11-12T14:03:49.080Z | 2024-11-12T14:03:49.080Z |
5519300 | 5519300 | 20241111105600_OM4Ef | US004N | 2024-11-12T14:03:41.395Z | 2024-11-12T14:03:41.395Z |
5519126 | 5519126 | 20241111101913_CAN3c | US004N | 2024-11-12T14:03:08.312Z | 2024-11-12T14:03:08.312Z |
5519013 | 5519013 | 20241111095441_Dh8pf | US004N | 2024-11-12T14:02:39.890Z | 2024-11-12T14:02:39.890Z |
5518993 | 5518993 | 20241111094959_leLY3 | US004N | 2024-11-12T14:02:34.361Z | 2024-11-12T14:02:34.361Z |
5518887 | 5518887 | 20241111092842_HVnya | US004N | 2024-11-12T14:02:16.650Z | 2024-11-12T14:02:16.650Z |
5518847 | 5518847 | 20241111092116_ZK0Go | US004N | 2024-11-12T14:02:12.773Z | 2024-11-12T14:02:12.773Z |
5518690 | 5518690 | 20241111085144_qwQKX | US004N | 2024-11-12T14:01:41.269Z | 2024-11-12T14:01:41.269Z |
5518639 | 5518639 | 20241111084030_oURQd | US004N | 2024-11-12T14:01:33.734Z | 2024-11-12T14:01:33.734Z |
5518552 | 5518552 | 20241111081453_xlEY3 | US004N | 2024-11-12T14:01:18.103Z | 2024-11-12T14:01:18.103Z |
5518439 | 5518439 | 20241111074929_5r21i | US004N | 2024-11-12T14:00:56.590Z | 2024-11-12T14:00:56.590Z |
5518387 | 5518387 | 20241111072241_nH0UI | US004N | 2024-11-12T14:00:48.753Z | 2024-11-12T14:00:48.753Z |
5518096 | 5518096 | 20241110055913_QlSWT | US004N | 2024-11-11T14:15:12.701Z | 2024-11-12T14:22:01.869Z |
5517991 | 5517991 | 20241110053248_i3hHX | US004N | 2024-11-11T14:15:06.816Z | 2024-11-12T14:21:59.993Z |
5517923 | 5517923 | 20241110051837_fDuVX | US004N | 2024-11-11T14:15:03.162Z | 2024-11-12T14:21:58.650Z |
5517891 | 5517891 | 20241110050925_o97du | US004N | 2024-11-11T14:14:59.825Z | 2024-11-12T14:21:57.860Z |
5517378 | 5517378 | 20241110033626_5a13O | US004N | 2024-11-11T14:14:19.369Z | 2024-11-12T14:21:40.037Z |
5517281 | 5517281 | 20241110031821_KlahZ | US004N | 2024-11-11T14:14:11.904Z | 2024-11-12T14:21:36.790Z |
5517235 | 5517235 | 20241110031027_Y2jLg | US004N | 2024-11-11T14:14:08.160Z | 2024-11-12T14:21:35.743Z |
5513829 | 5513829 | 20241110122621_cj3OU | US004N | 2024-11-11T14:05:31.519Z | 2024-11-12T14:18:06.662Z |
5513762 | 5513762 | 20241110121912_xQnLN | US004N | 2024-11-11T14:05:26.219Z | 2024-11-12T14:18:06.638Z |
5513726 | 5513726 | 20241110121007_Zo392 | US004N | 2024-11-11T14:05:23.232Z | 2024-11-12T14:18:06.621Z |
5513681 | 5513681 | 20241110120509_njzaf | US004N | 2024-11-11T14:05:10.894Z | 2024-11-12T14:18:06.602Z |
5513584 | 5513584 | 20241110115212_pyPpS | US004N | 2024-11-11T14:04:54.702Z | 2024-11-12T14:18:06.564Z |
5513425 | 5513425 | 20241110112914_1hApV | US004N | 2024-11-11T14:04:37.788Z | 2024-11-12T14:18:06.490Z |
5513414 | 5513414 | 20241110112724_aHEoR | US004N | 2024-11-11T14:04:36.542Z | 2024-11-12T14:18:06.484Z |
5513385 | 5513385 | 20241110112441_EFKhG | US004N | 2024-11-11T14:04:34.174Z | 2024-11-12T14:18:06.472Z |
5513298 | 5513298 | 20241110111257_9HiSg | US004N | 2024-11-11T14:04:25.854Z | 2024-11-12T14:18:06.436Z |
5513246 | 5513246 | 20241110110405_fIyVB | US004N | 2024-11-11T14:04:13.778Z | 2024-11-12T14:18:06.409Z |
5513181 | 5513181 | 20241110105148_WokUh | US004N | 2024-11-11T14:04:03.307Z | 2024-11-12T14:18:06.384Z |
5513084 | 5513084 | 20241110103610_RJXuN | US004N | 2024-11-11T14:03:51.982Z | 2024-11-12T14:18:06.341Z |
5513067 | 5513067 | 20241110103240_IdITR | US004N | 2024-11-11T14:03:50.164Z | 2024-11-12T14:18:06.333Z |
5512970 | 5512970 | 20241110101618_30o1T | US004N | 2024-11-11T14:03:41.250Z | 2024-11-12T14:18:06.290Z |
5512914 | 5512914 | 20241110101058_1AphR | US004N | 2024-11-11T14:03:34.791Z | 2024-11-12T14:18:06.271Z |
5512884 | 5512884 | 20241110100521_3233x | US004N | 2024-11-11T14:03:25.752Z | 2024-11-12T14:18:06.257Z |
5512677 | 5512677 | 20241110092842_bXWRG | US004N | 2024-11-11T14:02:57.078Z | 2024-11-12T14:18:06.175Z |
5512553 | 5512553 | 20241110090717_DU3ru | US004N | 2024-11-11T14:02:39.720Z | 2024-11-12T14:18:06.121Z |
5512399 | 5512399 | 20241110084232_35g92 | US004N | 2024-11-11T14:02:14.640Z | 2024-11-12T14:18:06.060Z |
5512326 | 5512326 | 20241110083223_mr3xv | US004N | 2024-11-11T14:02:06.658Z | 2024-11-12T14:18:06.031Z |
5512308 | 5512308 | 20241110083122_P7qj2 | US004N | 2024-11-11T14:02:04.779Z | 2024-11-12T14:18:06.025Z |
5512194 | 5512194 | 20241110081332_8ni3K | US004N | 2024-11-11T14:01:42.369Z | 2024-11-12T14:18:05.973Z |
5512005 | 5512005 | 20241110074028_0cuB3 | US004N | 2024-11-11T14:01:22.170Z | 2024-11-12T14:18:05.897Z |
5511997 | 5511997 | 20241110073945_Y3HhR | US004N | 2024-11-11T14:01:21.354Z | 2024-11-12T14:18:05.894Z |
5511940 | 5511940 | 20241110072557_c4VwV | US004N | 2024-11-11T14:01:09.642Z | 2024-11-12T14:18:05.867Z |
5511928 | 5511928 | 20241110072326_0bsub | US004N | 2024-11-11T14:01:07.011Z | 2024-11-12T14:18:05.861Z |
5511908 | 5511908 | 20241110072056_frA2g | US004N | 2024-11-11T14:01:02.628Z | 2024-11-12T14:18:05.851Z |
5485564 | 5485564 | 20241105063633_5JHyI | US004N | 2024-11-06T14:18:30.001Z | 2024-11-12T14:27:39.224Z |
5480298 | 5480298 | 20241105121903_UEVXF | US004N | 2024-11-06T14:05:10.901Z | 2024-11-12T14:26:29.853Z |
5479956 | 5479956 | 20241105110840_CLNWw | US004N | 2024-11-06T14:04:04.008Z | 2024-11-12T14:26:27.032Z |
5479904 | 5479904 | 20241105105804_tLZgU | US004N | 2024-11-06T14:03:51.833Z | 2024-11-12T14:26:26.809Z |
5479829 | 5479829 | 20241105104841_TDQ4V | US004N | 2024-11-06T14:03:41.613Z | 2024-11-12T14:26:26.482Z |
5479655 | 5479655 | 20241105101247_GW8mg | US004N | 2024-11-06T14:03:00.080Z | 2024-11-12T14:26:25.452Z |
5479506 | 5479506 | 20241105094526_bl3K2 | US004N | 2024-11-06T14:02:31.613Z | 2024-11-12T14:26:24.395Z |
5479256 | 5479256 | 20241105084714_pe8go | US004N | 2024-11-06T14:01:37.422Z | 2024-11-12T14:26:22.153Z |
5479241 | 5479241 | 20241105083948_vxKV1 | US004N | 2024-11-06T14:01:35.721Z | 2024-11-12T14:26:22.093Z |
5479193 | 5479193 | 20241105082822_pDsOp | US004N | 2024-11-06T14:01:26.600Z | 2024-11-12T14:26:21.559Z |
5479179 | 5479179 | 20241105082515_NewE4 | US004N | 2024-11-06T14:01:20.535Z | 2024-11-12T14:26:21.260Z |
5478990 | 5478990 | 20241105072150_87hom | US004N | 2024-11-06T14:00:33.989Z | 2024-11-12T14:26:19.833Z |
5469835 | 5469835 | 20241103042716_h3ymZ | US004N | 2024-11-04T14:17:07.424Z | 2024-11-11T14:23:02.393Z |
5465351 | 5465351 | 20241103113254_KjBJB | US004N | 2024-11-04T14:03:33.484Z | 2024-11-12T14:27:46.107Z |
5464231 | 5464231 | 20241101054943_AK7Pq | US004N | 2024-11-03T14:22:09.629Z | 2024-11-09T14:24:37.016Z |
5464213 | 5464213 | 20241101053758_lY9cf | US004N | 2024-11-03T14:22:09.197Z | 2024-11-09T14:24:36.828Z |
5464212 | 5464212 | 20241101053713_QSdJb | US004N | 2024-11-03T14:22:09.166Z | 2024-11-09T14:24:36.827Z |
5464196 | 5464196 | 20241101052617_1O1OX | US004N | 2024-11-03T14:22:08.437Z | 2024-11-09T14:24:36.026Z |
5463786 | 5463786 | 20241102051202_B2KsU | US004N | 2024-11-03T14:19:17.160Z | 2024-11-10T14:26:36.746Z |
5462946 | 5462946 | 20241102020250_aWcjh | US004N | 2024-11-03T14:18:10.863Z | 2024-11-10T14:26:33.800Z |
5462868 | 5462868 | 20241102014743_fbhVO | US004N | 2024-11-03T14:18:08.314Z | 2024-11-10T14:26:33.555Z |
5459906 | 5459906 | 20241101121406_IwPD0 | US004N | 2024-11-03T14:12:48.023Z | 2024-11-10T14:26:21.638Z |
5459851 | 5459851 | 20241101120155_aRRI3 | US004N | 2024-11-03T14:12:39.997Z | 2024-11-10T14:26:21.224Z |
5459660 | 5459660 | 20241101113109_ufjvN | US004N | 2024-11-03T14:12:25.673Z | 2024-11-10T14:26:20.389Z |
5459656 | 5459656 | 20241101113030_L5MXR | US004N | 2024-11-03T14:12:25.211Z | 2024-11-10T14:26:20.359Z |
5459586 | 5459586 | 20241101112011_02cRY | US004N | 2024-11-03T14:12:20.260Z | 2024-11-10T14:26:20.036Z |
5459564 | 5459564 | 20241101111744_zr1ej | US004N | 2024-11-03T14:12:17.846Z | 2024-11-10T14:26:19.913Z |
5459506 | 5459506 | 20241101110954_Ktu8X | US004N | 2024-11-03T14:12:03.141Z | 2024-11-10T14:26:19.530Z |
5459270 | 5459270 | 20241101103318_J1vsY | US004N | 2024-11-03T14:11:36.221Z | 2024-11-10T14:26:18.772Z |
5459187 | 5459187 | 20241101102148_4mIxd | US004N | 2024-11-03T14:11:28.221Z | 2024-11-10T14:26:18.398Z |
5459065 | 5459065 | 20241101100423_OiOK3 | US004N | 2024-11-03T14:11:14.400Z | 2024-11-10T14:26:17.746Z |
5458509 | 5458509 | 20241101083729_9TE2d | US004N | 2024-11-03T14:09:53.080Z | 2024-11-10T14:26:14.101Z |
5458456 | 5458456 | 20241101082909_bnlhG | US004N | 2024-11-03T14:09:46.827Z | 2024-11-10T14:26:13.739Z |
5458277 | 5458277 | 20241101075943_iTeqU | US004N | 2024-11-03T14:09:26.612Z | 2024-11-10T14:26:12.773Z |
5458260 | 5458260 | 20241101075530_ogtcq | US004N | 2024-11-03T14:09:23.406Z | 2024-11-10T14:26:12.684Z |
5456405 | 5456405 | 20241102111524_3tto1 | US004N | 2024-11-03T14:04:26.698Z | 2024-11-11T14:22:28.706Z |
5456147 | 5456147 | 20241102102859_x8LEI | US004N | 2024-11-03T14:03:31.581Z | 2024-11-11T14:22:26.784Z |
5455734 | 5455734 | 20241102090702_7yP34 | US004N | 2024-11-03T14:02:06.561Z | 2024-11-11T14:22:23.929Z |
5455615 | 5455615 | 20241102084439_DPZVj | US004N | 2024-11-03T14:01:41.522Z | 2024-11-11T14:22:23.056Z |
5455500 | 5455500 | 20241102081241_ZhOiX | US004N | 2024-11-03T14:01:06.442Z | 2024-11-11T14:22:21.923Z |
5455353 | 5455353 | 20241102072716_NQ0Fw | US004N | 2024-11-03T14:00:39.856Z | 2024-11-11T14:22:20.645Z |
5454948 | 5454948 | 20241031055240_sRpu0 | US004N | 2024-11-02T12:23:27.460Z | 2024-11-08T14:23:26.376Z |
5454802 | 5454802 | 20241031052143_IDczS | US004N | 2024-11-02T12:23:23.714Z | 2024-11-08T14:23:25.683Z |
5454170 | 5454170 | 20241031035038_Me2gz | US004N | 2024-11-02T12:22:53.172Z | 2024-11-08T14:23:20.827Z |
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);