names

94 rows where place_id = 597577

✎ 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
3629082 1903972 1903972 defendant Jenettys Walter clerk 597577 597577 (Jenettys, Walter, of Hanbury, clerk 5
3634848 1905698 1905698 plaintiff Nasshe John husbandman 597577 597577 Nasshe, John, of Hanbury, husbandman 0
3636264 1906132 1906132 defendant Lee Thomas husbandman 597577 597577 Lee, Thomas, of Hanbury, husbandman 2
3637885 1906663 1906663 defendant Goselyng Thomas yeoman 597577 597577 Goselyng, Thomas, of Hanbury, yeoman 0
3643827 1908495 1908495 defendant Lokarde Thomas husbandman 597577 597577 Lokarde, Thomas, of Hanbury, husbandman 1
3672283 1917331 1917331 defendant Davys Roger laborer 597577 597577 Davys, Roger, of Hanbury, laborer 1
3672286 1917331 1917331 defendant Yate Roger husbandman 597577 597577 Yate, Roger, of Hanbury, husbandman 4
3733584 1936748 1936748 defendant Androwys William gent 597577 597577 Androwys, William, of Hanbury, gent 0
3764858 1946676 1946676 defendant Hayford Thomas husbandman 597577 597577 Hayford, Thomas, of Hanbury, husbandman 0
3764860 1946677 1946677 defendant Hayford Thomas husbandman 597577 597577 Hayford, Thomas, of Hanbury, husbandman 0
3775862 1950203 1950203 defendant Havard Thomas husbandman 597577 597577 Havard, Thomas, of Hanbury, husbandman 2
3780795 1951729 1951729 defendant Mayall Richard husbandman 597577 597577 Mayall, Richard, of Hanbury, husbandman 0
3780799 1951730 1951730 defendant Andrewys William gent 597577 597577 Andrewys, William, of Hanbury, gent 0
3780800 1951730 1951730 defendant Andrewys Agnes widow 597577 597577 Andrewys, Agnes, of Hanbury, widow 1
3780803 1951731 1951731 defendant Andrewys William gent 597577 597577 Andrewys, William, of Hanbury, gent 0
3780804 1951731 1951731 defendant Andrewys Agnes widow 597577 597577 Andrewys, Agnes, of Hanbury, widow 1
3798136 1957313 1957313 defendant Ewyn John husbandman 597577 597577 Ewyn, John, of Hanbury, husbandman 0
3798137 1957313 1957313 defendant Coke John husbandman 597577 597577 Coke, John, of Hanbury, husbandman 1
3798138 1957313 1957313 defendant Watkyns John husbandman 597577 597577 Watkyns, John, of Hanbury, husbandman 2
3798139 1957313 1957313 defendant Nasshe John, junior husbandman 597577 597577 Nasshe, John, junior, of Hanbury, husbandman 3
3798487 1957428 1957428 defendant Prat Thomas mercer 597577 597577 Prat, Thomas, of Hanbury, mercer 1
3806118 1959840 1959840 defendant Yardeley Thomas husbandman 597577 597577 Yardeley, Thomas, of Hanbury, husbandman 0
3806119 1959840 1959840 defendant Bayle William husbandman 597577 597577 Bayle, William, of Hanbury, husbandman 1
3815906 1962879 1962879 defendant Pratt Thomas mercer 597577 597577 Pratt, Thomas, of Hanbury, mercer 1
3819755 1964058 1964058 defendant Vernam Thomas gent 597577 597577 Vernam, Thomas, of Hanbury, gent 1
3840882 1970717 1970717 defendant Barcroft John yeoman 597577 597577 Barcroft, John, of Hanbury, yeoman 0
3846471 1972449 1972449 defendant Braunt William husbandman 597577 597577 Braunt, William, of Hanbury, husbandman 4
3871285 1980647 1980647 defendant Barcrofte John yeoman 597577 597577 Barcrofte, John, of Hanbury, yeoman 0
3892661 1987794 1987794 defendant Hadley John husbandman 597577 597577 Hadley, John, of Hanbury, husbandman 0
3892663 1987795 1987795 defendant Hadley John husbandman 597577 597577 Hadley, John, of Hanbury, husbandman 0
3898962 1989857 1989857 plaintiff Barcroft John yeoman 597577 597577 Barcroft, John, of Hanbury, yeoman 0
3907051 1992646 1992646 defendant Hedley John husbandman 597577 597577 Hedley, John, of Hanbury, husbandman 0
3912458 1994495 1994495 defendant Androse John gent 597577 597577 Androse, John, of Hanbury, gent 1
3939811 2003616 2003616 defendant More John laborer 597577 597577 More, John, of Hanbury, laborer 2
3940682 2003891 2003891 defendant Steward Thomas husbandman 597577 597577 Steward, Thomas, of Hanbury, husbandman 0
3942499 2004500 2004500 defendant Nasshe Richard husbandman 597577 597577 Nasshe, Richard, of Hanbury, husbandman 0
3955467 2008979 2008979 defendant Heywood Thomas husbandman 597577 597577 Heywood, Thomas, of Hanbury, husbandman 0
3955469 2008979 2008979 defendant Dutton William husbandman 597577 597577 Dutton, William, of Hanbury, husbandman 2
3955470 2008979 2008979 defendant Heywood John husbandman 597577 597577 Heywood, John, of Hanbury, husbandman 3
3955962 2009156 2009156 defendant Coxon Robert husbandman 597577 597577 Coxon, Robert, of Hanbury, husbandman 0
3956827 2009459 2009459 defendant Haywode Thomas husbandman 597577 597577 Haywode, Thomas, of Hanbury, husbandman 0
3956832 2009460 2009460 defendant Haywood Thomas husbandman 597577 597577 Haywood, Thomas, of Hanbury, husbandman 0
3962300 2011396 2011396 defendant Dawk or Dawkes Roger yeoman 597577 597577 Dawk or Dawkes, Roger, of Hanbury, yeoman 0
3964857 2012317 2012317 defendant Brant Thomas husbandman 597577 597577 Brant, Thomas, of Hanbury, husbandman 0
3975954 2016153 2016153 plaintiff James William husbandman 597577 597577 James, William, of Hanbury, husbandman 0
3978184 2016951 2016951 defendant Walker John smith 597577 597577 Walker, John, of Hanbury, smith 0
3996466 2023495 2023495 plaintiff Dawbes Roger yeoman 597577 597577 Dawbes, Roger, of Hanbury, yeoman 0
3997060 2023717 2023717 defendant Vysard Francis husbandman 597577 597577 Vysard, Francis, of Hanbury, husbandman 0
4037074 2037924 2037924 defendant Heywood Elizabeth widow 597577 597577 Heywood, Elizabeth, of Hanbury, widow 0
4037075 2037924 2037924 defendant Heywood John husbandman 597577 597577 Heywood, John, of Hanbury, husbandman 1
4051150 2042849 2042849 defendant Darby John husbandman 597577 597577 Darby, John, of Hanbury, husbandman 1
4051155 2042850 2042850 defendant Darby John husbandman 597577 597577 Darby, John, of Hanbury, husbandman 1
4063040 2047084 2047084 defendant Haywood Thomas weaver 597577 597577 Haywood, Thomas, of Hanbury, weaver 0
4063041 2047084 2047084 defendant Haywood William husbandman 597577 597577 Haywood, William, of Hanbury, husbandman 1
4063042 2047084 2047084 defendant Pratt alias Pudge Anthony husbandman 597577 597577 Pratt alias Pudge, Anthony, of Hanbury, husbandman 2
4063043 2047084 2047084 defendant Richard John husbandman 597577 597577 Richard, John, of Hanbury, husbandman 3
4065210 2047840 2047840 defendant Taylor Giles husbandman 597577 597577 Taylor, Giles, of Hanbury, husbandman 0
4065211 2047840 2047840 defendant Hunt Humphrey   597577 597577 Hunt, Humphrey, of Hanbury, broad weaver 1
4082243 2053962 2053962 defendant Morgan Edward gent 597577 597577 Morgan, Edward, of Hanbury, gent 1
4125176 2069291 2069291 defendant Graunt Thomas gent 597577 597577 Graunt, Thomas, of Hanbury, or of Walhousse, gent 0
4125178 2069292 2069292 defendant Graunte Thomas gent 597577 597577 Graunte, Thomas, of Hanbury, or of Walhousse, gent 0
4145026 2076420 2076420 defendant Monoxe William yeoman 597577 597577 Monoxe, William, of Hanbury, yeoman 0
4153855 2079445 2079445 defendant Morgan Edward, senior esq 597577 597577 Morgan, Edward, senior, of Hanbury, esq 1
4161107 2081960 2081960 defendant Brereton Richard gent 597577 597577 Brereton, Richard, of Hanbury, gent 1
4169388 2084796 2084796 defendant Paynter Robert yeoman 597577 597577 Paynter, Robert, of Hanbury, yeoman 0
4169389 2084796 2084796 defendant Paynter Margery widow 597577 597577 Paynter, Margery, of Hanbury, widow 1
4176080 2087110 2087110 defendant Morgan Edward, senior gent 597577 597577 Morgan, Edward, senior, of Hanbury, gent 0
4176082 2087111 2087111 defendant Morgan Edward, senior gent 597577 597577 Morgan, Edward, senior, of Hanbury, gent 0
4184548 2090103 2090103 defendant Brereton Richard gent 597577 597577 Brereton, Richard, of Hanbury, gent 0
4223081 2103562 2103562 defendant Morgan Edward gent 597577 597577 Morgan, Edward, of Hanbury, gent 0
4224354 2104003 2104003 defendant Morgan Edward, junior gent 597577 597577 Morgan, Edward, junior, of Hanbury, gent 0
4231816 2106625 2106625 defendant Morgan Edward esq 597577 597577 Morgan, Edward, of Hanbury, esq 0
4233861 2107370 2107370 defendant Jefferis Thomas gent 597577 597577 Jefferis, Thomas, of Hanbury, or of Inckborowe, gent 0
4241225 2110052 2110052 defendant Morgan Edward, junior gent 597577 597577 Morgan, Edward, junior, of Hanbury, gent 0
4285846 2124990 2124990 defendant Randoll Robert gent 597577 597577 Randoll, Robert, of Hanbury, gent 0
4294540 2128133 2128133 defendant Parsons William yeoman 597577 597577 Parsons, William, of Hanbury, yeoman 1
4294541 2128133 2128133 defendant Hemynge Robert yeoman 597577 597577 Hemynge, Robert, of Hanbury, yeoman 2
4294543 2128134 2128134 defendant Randell Robert gent 597577 597577 Randell, Robert, of Hanbury, gent 0
4298145 2129438 2129438 defendant Parman Hugh husbandman 597577 597577 Parman, Hugh, of Hanbury, husbandman 1
4298147 2129438 2129438 defendant Nasshe William, senior husbandman 597577 597577 Nasshe, William, senior, of Hanbury, husbandman 3
4305065 2131912 2131912 defendant Stanley Thomas husbandman 597577 597577 Stanley, Thomas, of Hanbury, husbandman 0
4326317 2139166 2139166 defendant Manse Richard (legal representative) 597577 597577 Manse, Richard, of Hanbury, executors of 2
4328709 2139912 2139912 defendant Parsons William yeoman 597577 597577 Parsons, William, of Hanbury, yeoman 0
4347200 2146280 2146280 defendant Robotham alias Rosington George husbandman 597577 597577 Robotham alias Rosington, George, of Hanbury, husbandman 1
4361243 2151184 2151184 defendant Morgan Edward, junior gent 597577 597577 Morgan, Edward, junior, of Hanbury, gent 1
4515892 2205391 2205391 defendant Wybbe Thomas   597577 597577 Wybbe, Thomas, of Hanbury, parson 0
5396313 2474035 2474035 defendant Alenson Thomas husbandman 597577 597577 Alenson, Thomas, of Hanbury, husbandman 0
5409624 2477846 2477846 defendant Alenson Thomas husbandman 597577 597577 Alenson, Thomas, of Hanbury, husbandman 0
5423179 2481895 2481895 defendant Alanson Thomas husbandman 597577 597577 Alanson, Thomas, of Hanbury, husbandman 0
5423181 2481896 2481896 defendant Alenson Thomas husbandman 597577 597577 Alenson, Thomas, of Hanbury, husbandman 0
5589679 2531770 2531770 defendant Asshe John husbandman 597577 597577 Asshe, John, of Hanbury, husbandman 0
5589912 2531830 2531830 defendant Pyper Robert husbandman 597577 597577 Pyper, Robert, of Hanbury, husbandman 0
5589913 2531830 2531830 defendant Yate Roger husbandman 597577 597577 Yate, Roger, of Hanbury, husbandman 1
5589914 2531830 2531830 defendant TYeredeley John husbandman 597577 597577 TYeredeley, John, of Hanbury, husbandman 2

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);