names

70 rows where place_id = 587072

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590381 1864633 1864633 plaintiff Coppys Robert (legal representative) 587072 587072 Coppys, Robert, of Magna Melton, executor of 0
3590383 1864633 1864633 defendant Grote Robert yeoman 587072 587072 Grote, Robert, of Magna Melton, yeoman 0
3602705 1868508 1868508 defendant Baly Edmund husbandman 587072 587072 Baly, Edmund, of Magna Melton, husbandman 4
3619983 1873822 1873822 defendant Goderede John carpenter 587072 587072 Goderede, John, of Magna Melton, carpenter 0
3619984 1873822 1873822 defendant Hervy Robert yeoman 587072 587072 Hervy, Robert, of Magna Melton, yeoman 1
3619985 1873822 1873822 defendant Grote Robert yeoman 587072 587072 Grote, Robert, of Magna Melton, yeoman 2
3619986 1873822 1873822 defendant Kyttemay Richard husbandman 587072 587072 Kyttemay, Richard, of Magna Melton, husbandman 3
3620567 1874008 1874008 defendant Hervy Henry husbandman 587072 587072 Hervy, Henry, of Magna Melton, husbandman 3
3631683 1904723 1904723 defendant Jermyn Thomas gent 587072 587072 Jermyn, Thomas, of Magna Melton, gent 0
3631684 1904723 1904723 defendant Jermyn Robert clerk 587072 587072 Jermyn, Robert, of Magna Melton, clerk 1
3774023 1949589 1949589 defendant Frosdyke William husbandman 587072 587072 Frosdyke, William, of Magna melton, husbandman 2
3797811 1957213 1957213 defendant Bayle Edmund husbandman 587072 587072 Bayle, Edmund, of Magna Melton, husbandman 2
3880742 1983824 1983824 defendant Harvy John, senior husbandman 587072 587072 Harvy, John, senior, of Magna Melton, husbandman 2
3880743 1983824 1983824 defendant Harvy John, junior husbandman 587072 587072 Harvy, John, junior, of Magna Melton, husbandman 3
3887428 1986060 1986060 defendant Goodred William husbandman 587072 587072 Goodred, William, of Magna Melton, husbandman 2
3888844 1986519 1986519 defendant Herny Robert husbandman 587072 587072 Herny, Robert, of Magna Melton, husbandman 0
3888848 1986520 1986520 defendant Herny Robert husbandman 587072 587072 Herny, Robert, of Magna Melton, husbandman 0
3974652 2015702 2015702 defendant Crispe Edward husbandman 587072 587072 Crispe, Edward, of Magna Melton, husbandman 0
3983463 2018861 2018861 defendant Cryspe Edward yeoman 587072 587072 Cryspe, Edward, of Magna Melton, yeoman 2
4006169 2026978 2026978 defendant Baylye Henry husbandman 587072 587072 Baylye, Henry, of Magna Melton, husbandman 1
4132740 2072035 2072035 defendant Kynge George husbandman 587072 587072 Kynge, George, of Magna Melton, husbandman 0
4132741 2072035 2072035 defendant Seman Thomas husbandman 587072 587072 Seman, Thomas, of Magna Melton, husbandman 1
4132742 2072035 2072035 defendant Browne James husbandman 587072 587072 Browne, James, of Magna Melton, husbandman 2
4198012 2094853 2094853 defendant Browne Richard husbandman 587072 587072 Browne, Richard, of Magna Melton, husbandman 1
4211945 2099729 2099729 defendant Kyng Martin yeoman 587072 587072 Kyng, Martin, of Magna Melton, yeoman 0
4211946 2099729 2099729 defendant Kynge John yeoman 587072 587072 Kynge, John, of Magna Melton, yeoman 1
4397336 2163690 2163690 defendant Crane Thomas husbandman 587072 587072 Crane, Thomas, of Magna Melton, husbandman 0
4397337 2163690 2163690 defendant Browne Thomas clerk 587072 587072 Browne, Thomas, of Magna Melton, clerk 1
4870403 2317720 2317720 defendant Hekelyngham John husbandman 587072 587072 Hekelyngham, John, of Magna Melton, husbandman 0
4873624 2318689 2318689 defendant Ikelyngham John husbandman 587072 587072 Ikelyngham, John, of Magna Melton, husbandman 0
4874402 2318935 2318935 defendant Godrede William husbandman 587072 587072 Godrede, William, of Magna Melton, husbandman 3
4897892 2325999 2325999 defendant Couper John husbandman 587072 587072 Couper, John, of Magna Melton, husbandman 3
4956224 2343821 2343821 defendant Goodred John husbandman 587072 587072 Goodred, John, of Magna Melton, husbandman 3
5016008 2361566 2361566 defendant Wykes Richard   587072 587072 Wykes, Richard, of Magna Melton, wright 4
5035959 2367371 2367371 defendant Pynkney Thomas gent 587072 587072 Pynkney, Thomas, of Magna Melton, gent 0
5035960 2367371 2367371 defendant Elsy Richard gent 587072 587072 Elsy, Richard, of Magna Melton, gent 1
5108643 2388962 2388962 defendant Wykys Richard husbandman 587072 587072 Wykys, Richard, of Magna Melton, husbandman 5
5123593 2393358 2393358 plaintiff Wode Edmund   587072 587072 Wode, Edmund, of Magna Melton 0
5218246 2421066 2421066 plaintiff Germyn Thomas yeoman 587072 587072 Germyn, Thomas, of Magna Melton, yeoman 0
5227630 2423701 2423701 defendant Motte John husbandman 587072 587072 Motte, John, of Magna Melton, husbandman 1
5227632 2423701 2423701 defendant Northgate John husbandman 587072 587072 Northgate, John, of Magna Melton, husbandman 3
5291978 2442659 2442659 defendant Hervy Richard yeoman 587072 587072 Hervy, Richard, of Magna Melton, yeoman 0
5316422 2449992 2449992 defendant Godered John   587072 587072 Godered, John, of Magna Melton, wright 0
5321272 2451458 2451458 defendant Godered John carpenter 587072 587072 Godered, John, of Magna Melton, carpenter 0
5327235 2453216 2453216 defendant Baggys Robert laborer 587072 587072 Baggys, Robert, of Magna Melton, laborer 0
5327236 2453216 2453216 defendant Kydmay Henry husbandman 587072 587072 Kydmay, Henry, of Magna Melton, husbandman 1
5327237 2453216 2453216 defendant Bayly Thomas husbandman 587072 587072 Bayly, Thomas, of Magna Melton, husbandman 2
5331738 2454577 2454577 defendant Chapman John clerk 587072 587072 together with Chapman, John, of Magna Melton, clerk 6
5337146 2456184 2456184 defendant Godered John husbandman 587072 587072 Godered, John, of Magna Melton, husbandman 4
5356293 2462045 2462045 plaintiff Toppys Robert   587072 587072 Toppys, Robert, of Magna Melton 2
5356411 2462073 2462073 plaintiff Toppys Robert   587072 587072 Toppys, Robert, of Magna Melton 2
5356726 2462167 2462167 defendant Hervy Robert husbandman 587072 587072 Hervy, Robert, of Magna Melton, husbandman 3
5357602 2462448 2462448 defendant Chapman John clerk 587072 587072 Chapman, John, of Magna Melton, clerk 0
5512394 2508737 2508737 defendant Barker Thomas carpenter 587072 587072 Barker, Thomas, of Magna Melton, carpenter 4
5513582 2509097 2509097 defendant Lovell Gregory   587072 587072 Lovell, Gregory, of Magna Melton, knight 0
5518361 2510570 2510570 defendant Appulton John carpenter 587072 587072 Appulton, John, of Magna Melton, carpenter 0
5525852 2512677 2512677 defendant Wattys Thomas husbandman 587072 587072 Wattys, Thomas, of Magna Melton, husbandman 1
5527924 2513299 2513299 defendant Hervy Henry husbandman 587072 587072 Hervy, Henry, of Magna Melton, husbandman 0
5527926 2513300 2513300 defendant Hervy Henry husbandman 587072 587072 Hervy, Henry, of Magna Melton, husbandman 0
5538895 2516651 2516651 defendant Hervy Henry yeoman 587072 587072 Hervy, Henry, of Magna Melton, yeoman 0
5553699 2521117 2521117 defendant Jermyn Thomas yeoman 587072 587072 Jermyn, Thomas, of Magna Melton, yeoman 0
5570837 2526029 2526029 plaintiff Jermyn Robert clerk 587072 587072 Jermyn, Robert, of Magna Melton, clerk 0
5570839 2526029 2526029 plaintiff Jermyn Thomas gent 587072 587072 Jermyn, Thomas, of Magna Melton, gent 2
5584140 2530111 2530111 defendant Jermyn Thomas gent 587072 587072 Jermyn, Thomas, of Magna Melton, gent 0
5584141 2530111 2530111 defendant Jermyn Robert clerk 587072 587072 Jermyn, Robert, of Magna Melton, clerk 1
5584143 2530112 2530112 defendant Jermyn Thomas gent 587072 587072 Jermyn, Thomas, of Magna Melton, gent 0
5584144 2530112 2530112 defendant Jermyn Robert clerk 587072 587072 Jermyn, Robert, of Magna Melton, clerk 1
5596462 2533806 2533806 plaintiff Hervy John, senior yeoman 587072 587072 (Hervy, John, senior, of Magna Melton, yeoman 1
5601071 2535222 2535222 plaintiff Jermyn Robert clerk 587072 587072 Jermyn, Robert, of Magna Melton, clerk 0
5628394 2552844 2552844 plaintiff Peverell John   587072 587072 Peverell, John, of Magna Melton 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);