names

87 rows where place_id = 592500

✎ 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
3607896 1870120 1870120 defendant Curteys William butcher 592500 592500 Curteys, William, of Horseley, butcher 0
3613284 1871805 1871805 defendant Smyth John smith 592500 592500 Smyth, John, of Horseley, smith 2
3613285 1871805 1871805 defendant Hege Nicholas smith 592500 592500 Hege, Nicholas, of Horseley, smith 3
3620910 1874103 1874103 defendant Soweter John   592500 592500 Soweter, John, of Horseley, scythe smith 0
3626469 1903135 1903135 defendant Bower Richard tailor 592500 592500 Bower, Richard, of Horseley, tailor 1
3626470 1903135 1903135 defendant Balle Thomas   592500 592500 Balle, Thomas, of Horseley, scythe smith 2
3628203 1903678 1903678 defendant Bailly Thomas husbandman 592500 592500 Bailly, Thomas, of Horseley, husbandman 0
3628204 1903678 1903678 defendant Haghton John husbandman 592500 592500 Haghton, John, of Horseley, husbandman 1
3629798 1904172 1904172 defendant Halom Robert   592500 592500 Halom, Robert, of Horseley, scythe grinder 0
3629799 1904172 1904172 defendant Roge John laborer 592500 592500 Roge, John, of Horseley, laborer 1
3629800 1904172 1904172 defendant Hagh Thomas laborer 592500 592500 Hagh, Thomas, of Horseley, laborer 2
3634288 1905521 1905521 defendant Southam Henry husbandman 592500 592500 Southam, Henry, of Horseley, husbandman 3
3634289 1905521 1905521 defendant Stephen Hugh husbandman 592500 592500 Stephen, Hugh, of Horseley, husbandman 4
3634353 1905541 1905541 defendant Aglande John yeoman 592500 592500 Aglande, John, of Horseley, yeoman 0
3651370 1910794 1910794 defendant More Richard husbandman 592500 592500 More, Richard, of Horseley, husbandman 0
3674697 1918133 1918133 defendant Garcett Thomas yeoman 592500 592500 Garcett, Thomas, of Horseley, yeoman 0
3677990 1919159 1919159 defendant Balle Henry   592500 592500 Balle, Henry, of Horseley, scythe smith 5
3699167 1925951 1925951 defendant Wynfeld John   592500 592500 Wynfeld, John, of Horseley, scythe smith 0
3743146 1939716 1939716 defendant Clerke Robert yeoman 592500 592500 Clerke, Robert, of Horseley, yeoman 0
3743148 1939717 1939717 defendant Clerke Robert yeoman 592500 592500 Clerke, Robert, of Horseley, yeoman 0
3788122 1954079 1954079 defendant Stanley Thomas miller 592500 592500 Stanley, Thomas, of Horseley, miller 0
3791266 1955102 1955102 defendant Browne Thomas clerk 592500 592500 Browne, Thomas, of Horseley, clerk 0
3848617 1973151 1973151 defendant Ive Thomas laborer 592500 592500 Ive, Thomas, of Horseley, laborer 0
3889307 1986660 1986660 defendant Lander Richard husbandman 592500 592500 Lander, Richard, of Horseley, husbandman 0
3908717 1993212 1993212 defendant Stathome Roger yeoman 592500 592500 Stathome, Roger, of Horseley, yeoman 0
3932960 2001315 2001315 defendant Pessall John esq 592500 592500 Pessall, John, of Horseley, esq 0
3932962 2001316 2001316 defendant Pessall John esq 592500 592500 Pessall, John, of Horseley, esq 0
3944212 2005081 2005081 defendant Clarke Thomas yeoman 592500 592500 Clarke, Thomas, of Horseley, yeoman 0
3945170 2005406 2005406 plaintiff Blomevill Alan gent 592500 592500 Blomevill, Alan, of Horseley, or of Newton Flotnam, Norf, gent 0
3945171 2005406 2005406 defendant Lowe Barbara gentlewoman 592500 592500 Lowe, Barbara, of Horseley, gentlewoman 0
3982404 2018479 2018479 defendant Boswell Robert smith 592500 592500 Boswell, Robert, of Horseley, or of Rotherame, Yorks, smith 0
3982414 2018483 2018483 defendant Boswell Robert smith 592500 592500 Boswell, Robert, of Horseley, or of Rotherame, Yorks, smith 0
3983887 2019007 2019007 defendant Hancock John gent 592500 592500 Hancock, John, of Horseley, gent 0
3983888 2019007 2019007 defendant Pesell Thomas laborer 592500 592500 Pesell, Thomas, of Horseley, laborer 1
3983889 2019007 2019007 defendant Howbrowe Robert laborer 592500 592500 Howbrowe, Robert, of Horseley, laborer 2
3983890 2019007 2019007 defendant Davys John laborer 592500 592500 Davys, John, of Horseley, laborer 3
3983891 2019007 2019007 defendant Hyck William laborer 592500 592500 Hyck, William, of Horseley, laborer 4
4056042 2044545 2044545 defendant Blundevile Alan gent 592500 592500 Blundevile, Alan, of Horseley, gent 0
4073575 2050837 2050837 defendant Landerne Roger husbandman 592500 592500 Landerne, Roger, of Horseley, husbandman 0
4076043 2051727 2051727 defendant Seele Robert yeoman 592500 592500 Seele, Robert, of Horseley, yeoman 0
4079574 2052992 2052992 defendant Blundevyle Alan gent 592500 592500 Blundevyle, Alan, of Horseley, gent 0
4110718 2064092 2064092 defendant Townson alias Farmer John yeoman 592500 592500 Townson alias Farmer, John, of Horseley, yeoman 0
4145263 2076502 2076502 defendant Gretton Thomas tailor 592500 592500 Gretton, Thomas, of Horseley, tailor 0
4157770 2080790 2080790 defendant Skrymsher Thomas gent 592500 592500 Skrymsher, Thomas, of Horseley, gent 0
4157772 2080791 2080791 defendant Skrymsher Thomas gent 592500 592500 Skrymsher, Thomas, of Horseley, gent 0
4170125 2085045 2085045 defendant Seele Eias   592500 592500 Seele, Eias, of Horseley, "stonpecker" 3
4170126 2085045 2085045 defendant Ratchdall Henry   592500 592500 Ratchdall, Henry, of Horseley, "stonpecker" 4
4170127 2085045 2085045 defendant Ashmore Robert   592500 592500 Ashmore, Robert, of Horseley, "stonpecker" 5
4170128 2085045 2085045 defendant Bruckes Robert   592500 592500 Bruckes, Robert, of Horseley, mason 6
4244514 2111146 2111146 defendant Estyngton Walter butcher 592500 592500 Estyngton, Walter, of Horseley, butcher 0
4247655 2112197 2112197 defendant Jukes Roger yeoman 592500 592500 Jukes, Roger, of Horseley, or of Wolverley, yeoman 0
4247656 2112197 2112197 defendant Jukes Henry   592500 592500 Jukes, Henry, of Horseley, yeoman, his son 1
4477407 2193599 2193599 defendant Cartewright Stephen   592500 592500 Cartewright, Stephen, of Horseley 0
4502458 2201351 2201351 plaintiff Milner Thomas   592500 592500 Milner, Thomas, of Horseley 0
4734083 2275844 2275844 defendant Tayllour Thomas husbandman 592500 592500 Tayllour, Thomas, of Horseley, husbandman 1
4734084 2275844 2275844 defendant Were William de husbandman 592500 592500 Were, William de, of Horseley, husbandman 2
4750895 2280744 2280744 defendant Were William de husbandman 592500 592500 Were, William de, of Horseley, husbandman 1
4771199 2286975 2286975 defendant Were William yeoman 592500 592500 Were, William, of Horseley, yeoman 1
4828181 2304858 2304858 defendant Weyre William husbandman 592500 592500 Weyre, William, of Horseley, husbandman 0
4844979 2309947 2309947 defendant Trees Robert in the smith 592500 592500 Trees, Robert in the, of Horseley, smith 5
4940609 2339090 2339090 defendant Trese John   592500 592500 Trese, John, of Horseley, of scythe smith 1
5184346 2411160 2411160 defendant Trees Thomas   592500 592500 Trees, Thomas, of Horseley, sythe smith 0
5234475 2425674 2425674 defendant Bothe Richard   592500 592500 Bothe, Richard, of Horseley, scythe smith 0
5234476 2425674 2425674 defendant Aspynall Thomas   592500 592500 Aspynall, Thomas, of Horseley, scythe smith 1
5252300 2430829 2430829 defendant Aspynall Thomas   592500 592500 Aspynall, Thomas, of Horseley, scythe smith 0
5324206 2452327 2452327 plaintiff Prowede William clerk 592500 592500 Prowede, William, of Horseley, clerk 0
5384043 2470523 2470523 defendant Barley William   592500 592500 Barley, William, of Horseley, scythe smith 2
5384047 2470524 2470524 defendant Barley William   592500 592500 Barley, William, of Horseley, scythe smith 2
5436459 2485839 2485839 defendant Stathume John gent 592500 592500 Stathume, John, of Horseley, gent 2
5451127 2490229 2490229 defendant Stathume John gent 592500 592500 Stathume, John, of Horseley, gent 2
5526822 2512956 2512956 defendant Johnson Geoffrey yeoman 592500 592500 Johnson, Geoffrey, of Horseley, yeoman 4
5534568 2515354 2515354 defendant Mylner William   592500 592500 Mylner, William, of Horseley, scythe smith 17
5534576 2515356 2515356 defendant Smyth John   592500 592500 Smyth, John, of Horseley, scythe smith 0
5540630 2517194 2517194 defendant Toys John husbandman 592500 592500 Toys, John, of Horseley, husbandman 0
5576945 2527833 2527833 defendant Lees John   592500 592500 Lees, John, of Horseley, scythe smith 0
5578646 2528388 2528388 defendant Milner Henry   592500 592500 Milner, Henry, of Horseley, scythe smith 1
5578647 2528388 2528388 defendant Lees John husbandman 592500 592500 Lees, John, of Horseley, husbandman 2
5580221 2528900 2528900 defendant Agland John   592500 592500 Agland, John, of Horseley, scythe smith 0
5580222 2528900 2528900 defendant Agland Henry laborer 592500 592500 Agland, Henry, of Horseley, laborer 1
5580224 2528901 2528901 defendant Agland John   592500 592500 Agland, John, of Horseley, scythe smith 0
5580225 2528901 2528901 defendant Agland henry laborer 592500 592500 Agland, henry, of Horseley, laborer 1
5580227 2528902 2528902 defendant Aglond John   592500 592500 Aglond, John, of Horseley, scythe smith 0
5580228 2528902 2528902 defendant Aglond Henry laborer 592500 592500 Aglond, Henry, of Horseley, laborer 1
5586964 2530950 2530950 defendant Roper John husbandman 592500 592500 Roper, John, of Horseley, husbandman 0
5587299 2531053 2531053 defendant Hudson Robert   592500 592500 Hudson, Robert, of Horseley, scythe smith 0
5589361 2531673 2531673 defendant Milner Henry   592500 592500 Milner, Henry, of Horseley, scythe smith 3
5602519 2535681 2535681 plaintiff Milnegat Elizabeth   592500 592500 Milnegat, Elizabeth, of Horseley, widow, administrators of 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);