names

62 rows where place_id = 645575

✎ 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
3886306 1985675 1985675 defendant Andrewe Matthew butcher 645575 645575 Andrewe, Matthew, of Huntington, butcher 0
3888224 1986317 1986317 defendant Andrewe Matthew butcher 645575 645575 Andrewe, Matthew, of Huntington, butcher 0
3921386 1997495 1997495 defendant Drury Linus mercer 645575 645575 Drury, Linus, of Huntington, mercer 0
3946192 2005746 2005746 defendant Rogers Thomas weaver 645575 645575 Rogers, Thomas, of Huntington, weaver 0
3962231 2011371 2011371 defendant Dackam Henry gent 645575 645575 Dackam, Henry, of Huntington, gent 0
3981161 2018020 2018020 defendant Harrys Thomas gent 645575 645575 Harrys, Thomas, of Huntington, gent 1
3988227 2020538 2020538 plaintiff ap David John (legal representative) 645575 645575 ap David, John, of Huntington, yeoman, executors of 0
3995338 2023074 2023074 plaintiff Coveney Roger yeoman 645575 645575 Coveney, Roger, of Huntington, yeoman 0
3995456 2023119 2023119 plaintiff Cowper William mercer 645575 645575 Cowper, William, of Huntington, mercer 0
3997691 2023930 2023930 plaintiff Edwardes Thomas gent 645575 645575 Edwardes, Thomas, of Huntington, gent 0
4001529 2025327 2025327 defendant Symcot Willism gent 645575 645575 Symcot, Willism, of Huntington, gent 2
4001534 2025327 2025327 defendant Fullelewe Ivo   645575 645575 Fullelewe, Ivo, of Huntington 7
4001535 2025327 2025327 defendant Barnard Henry yeoman 645575 645575 Barnard, Henry, of Huntington, yeoman 8
4040323 2039044 2039044 defendant Lluwellen Rice gent 645575 645575 Lluwellen, Rice, of Huntington, gent 1
4053432 2043603 2043603 defendant Moholom John yeoman 645575 645575 Moholom, John, of Huntington, yeoman 0
4081593 2053721 2053721 plaintiff Wilk Christopher   645575 645575 Wilk, Christopher, of Huntington, woollen draper 0
4082396 2054012 2054012 defendant Gwin Rice Bevan husbandman 645575 645575 Gwin, Rice Bevan, of Huntington, husbandman 3
4100298 2060441 2060441 defendant Wilkes Christopher draper 645575 645575 Wilkes, Christopher, of Huntington, draper 0
4120320 2067545 2067545 defendant Bowen Henry gent 645575 645575 Bowen, Henry, of Huntington, or of Llanyhangell Brynpabyan, Brecon, gent 0
4120321 2067545 2067545 defendant Griffith Lewis gent 645575 645575 Griffith, Lewis, of Huntington, gent 1
4120338 2067549 2067549 defendant Gwynne John gent 645575 645575 Gwynne, John, of Huntington, or of Llanelwethe, Radnor, gent 0
4120339 2067549 2067549 defendant Lluwellen Emanuel gent 645575 645575 Lluwellen, Emanuel, of Huntington, gent 1
4120340 2067549 2067549 defendant Vaughan Thomas gent 645575 645575 Vaughan, Thomas, of Huntington, gent 2
4143420 2075860 2075860 defendant Lluwellin Emanuel gent 645575 645575 Lluwellin, Emanuel, of Huntington, gent 1
4143421 2075860 2075860 defendant Vaughan Thomas gent 645575 645575 Vaughan, Thomas, of Huntington, gent 2
4148026 2077442 2077442 defendant Higgins Robert gent 645575 645575 Higgins, Robert, of Huntington, gent 0
4148027 2077442 2077442 defendant Amor James yeoman 645575 645575 Amor, James, of Huntington, yeoman 1
4152394 2078947 2078947 defendant Gitto John yeoman 645575 645575 Gitto, John, of Huntington, yeoman 1
4156948 2080509 2080509 defendant Gwyn Lewis gent 645575 645575 Gwyn, Lewis, of Huntington, gent 1
4179174 2088192 2088192 defendant Wraye Richard chapman 645575 645575 Wraye, Richard, of Huntington, chapman 0
4180675 2088723 2088723 defendant Gwynne Lewis gent 645575 645575 Gwynne, Lewis, of Huntington, gent 0
4216102 2101123 2101123 defendant Holmes Seth esq 645575 645575 Holmes, Seth, of Huntington, esq 0
4221845 2103137 2103137 defendant ap Bowen Richard yeoman 645575 645575 ap Bowen, Richard, of Huntington, yeoman 0
4223034 2103547 2103547 defendant Prichard Philip yeoman 645575 645575 Prichard, Philip, of Huntington, yeoman 1
4230390 2106122 2106122 defendant ap Bowen Richard yeoman 645575 645575 ap Bowen, Richard, of Huntington, yeoman 0
4248356 2112442 2112442 defendant Prichard John yeoman 645575 645575 Prichard, John, of Huntington, yeoman 1
4260983 2116635 2116635 defendant Lasynby Seth yeoman 645575 645575 Lasynby, Seth, of Huntington, yeoman 0
4270115 2119589 2119589 defendant Holmes Seth (legal representative) 645575 645575 Holmes, Seth, of Huntington, esq, executor of 0
4270116 2119589 2119589 defendant Holmes Seth esq 645575 645575 Holmes, Seth, of Huntington, esq 1
4276694 2121782 2121782 defendant Allford William yeoman 645575 645575 Allford, William, of Huntington, yeoman 0
4292535 2127392 2127392 defendant Goughe Walter yeoman 645575 645575 Goughe, Walter, of Huntington, yeoman 1
4294404 2128080 2128080 defendant Pykaringe or Pickeringe Gilbert gent 645575 645575 Pykaringe or Pickeringe, Gilbert, of Huntington, or of Thorpe, Nhants, gent 0
4297450 2129192 2129192 defendant Bradford Richard yeoman 645575 645575 Bradford, Richard, of Huntington, yeoman 1
4304837 2131826 2131826 defendant Allford William yeoman 645575 645575 Allford, William, of Huntington, yeoman 0
4311175 2134056 2134056 defendant Holmes Seth esq 645575 645575 Holmes, Seth, of Huntington, esq 2
4320786 2137363 2137363 defendant Holme Seth, junior esq 645575 645575 Holme, Seth, junior, of Huntington, esq 0
4320788 2137364 2137364 defendant Parke Richard husbandman 645575 645575 Parke, Richard, of Huntington, husbandman 0
4330374 2140460 2140460 defendant Bradford Richard yeoman 645575 645575 Bradford, Richard, of Huntington, yeoman 1
4330462 2140487 2140487 defendant Howell John yeoman 645575 645575 Howell, John, of Huntington, yeoman 0
4343937 2145158 2145158 defendant Smithe Thomas yeoman 645575 645575 Smithe, Thomas, of Huntington, yeoman 2
4355593 2149180 2149180 defendant Suthwyse Richard yeoman 645575 645575 Suthwyse, Richard, of Huntington, yeoman 0
4357078 2149704 2149704 defendant Pigeon Francis painter 645575 645575 Pigeon, Francis, of Huntington, painter 0
4373826 2155707 2155707 defendant Levatt John gent 645575 645575 Levatt, John, of Huntington, or of Trantham, Staffs, gent 0
4378083 2157228 2157228 defendant Holmes Seth gent 645575 645575 Holmes, Seth, of Huntington, gent 0
4382018 2158671 2158671 defendant Smyth Thomas   645575 645575 (Smyth, Thomas, of Huntington 4
4383231 2159109 2159109 defendant Jones John gent 645575 645575 Jones, John, of Huntington, gent 0
4396655 2163446 2163446 defendant Cromwell Oliver esq 645575 645575 Cromwell, Oliver, of Huntington, esq 0
4399515 2164425 2164425 defendant Wiseman Samuel gent 645575 645575 Wiseman, Samuel, of Huntington, gent 2
4820285 2302412 2302412 defendant Bykley John yeoman 645575 645575 Bykley, John, of Huntington, yeoman 0
4869316 2317370 2317370 defendant Cowsland John spicer 645575 645575 Cowsland, John, of Huntington, spicer 2
5490138 2501932 2501932 defendant Chixand Richard gent 645575 645575 Chixand, Richard, of Huntington, gent 0
5570148 2525843 2525843 defendant Pecarde Robert innholder 645575 645575 Pecarde, Robert, of Huntington, innholder 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);