names

45 rows where place_id = 608291

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3673036 1917574 1917574 defendant Wythenall Roger husbandman 608291 608291 Wythenall, Roger, of Hilderston, husbandman 4
3704661 1927745 1927745 defendant Pulton James husbandman 608291 608291 Pulton, James, of Hilderston, husbandman 0
3771804 1948880 1948880 defendant Chapman Robert butcher 608291 608291 Chapman, Robert, of Hilderston, butcher 1
3797268 1957031 1957031 defendant Pulton James husbandman 608291 608291 Pulton, James, of Hilderston, husbandman 0
3936480 2002524 2002524 defendant Hunt Edmund gent 608291 608291 Hunt, Edmund, of Hilderston, gent 0
3986923 2020065 2020065 defendant Pulton John yeoman 608291 608291 Pulton, John, of Hilderston, yeoman 0
4109962 2063820 2063820 defendant Bulwer George husbandman 608291 608291 Bulwer, George, of Hilderston, husbandman 0
4137359 2073712 2073712 defendant Byrde John yeoman 608291 608291 Byrde, John, of Hilderston, yeoman 0
4148959 2077756 2077756 defendant Wollaston William yeoman 608291 608291 Wollaston, William, of Hilderston, yeoman 0
4148961 2077757 2077757 defendant Wollaston William yeoman 608291 608291 Wollaston, William, of Hilderston, yeoman 0
4171565 2085522 2085522 defendant Burr John weaver 608291 608291 Burr, John, of Hilderston, weaver 0
4171566 2085522 2085522 defendant Porter Thomas husbandman 608291 608291 Porter, Thomas, of Hilderston, husbandman 1
4171567 2085522 2085522 defendant Catton Richard husbandman 608291 608291 Catton, Richard, of Hilderston, husbandman 2
4171569 2085523 2085523 defendant Porter Thomas husbandman 608291 608291 Porter, Thomas, of Hilderston, husbandman 0
4171570 2085523 2085523 defendant Catton Richard husbandman 608291 608291 Catton, Richard, of Hilderston, husbandman 1
4222888 2103494 2103494 defendant Pott Sampson husbandman 608291 608291 Pott, Sampson, of Hilderston, husbandman 0
4223324 2103650 2103650 defendant Arnett Thomas weaver 608291 608291 Arnett, Thomas, of Hilderston, weaver 0
4223325 2103650 2103650 defendant Reade Humphrey tailor 608291 608291 Reade, Humphrey, of Hilderston, tailor 1
4283590 2124169 2124169 defendant Hart Charles gent 608291 608291 Hart, Charles, of Hilderston, gent 0
4284836 2124621 2124621 defendant Gilbert James yeoman 608291 608291 Gilbert, James, of Hilderston, yeoman 1
4290919 2126811 2126811 defendant Haste Charles gent 608291 608291 Haste, Charles, of Hilderston, gent 0
4325971 2139060 2139060 defendant Bott James husbandman 608291 608291 Bott, James, of Hilderston, husbandman 2
4329798 2140263 2140263 defendant Mason Edward husbandman 608291 608291 Mason, Edward, of Hilderston, or of Bromley, husbandman 0
4424602 2172534 2172534 defendant Hony Thomas   608291 608291 Hony, Thomas, of Hilderston 0
4562558 2219848 2219848 defendant Gloos Richard   608291 608291 Gloos, Richard, of Hilderston 1
4681485 2259824 2259824 defendant Hales George yeoman 608291 608291 Hales, George, of Hilderston, yeoman 2
4687844 2261764 2261764 defendant Fychet John tailor 608291 608291 Fychet, John, of Hilderston, tailor 1
4692825 2263265 2263265 defendant Jeryngham Sampson yeoman 608291 608291 Jeryngham, Sampson, of Hilderston, yeoman 0
4692827 2263266 2263266 defendant Fechet John tailor 608291 608291 Fechet, John, of Hilderston, tailor 0
4707294 2267658 2267658 defendant Dowe Roger husbandman 608291 608291 Dowe, Roger, of Hilderston, husbandman 2
4721322 2272000 2272000 defendant Halys George yeoman 608291 608291 Halys, George, of Hilderston, yeoman 0
4739352 2277394 2277394 defendant Wodhous Peter yeoman 608291 608291 Wodhous, Peter, of Hilderston, yeoman 2
4759776 2283394 2283394 defendant Colyns John   608291 608291 Colyns, John, of Hilderston, bailiff 2
4759784 2283395 2283395 defendant Colyns John   608291 608291 Colyns, John, of Hilderston, bailiff 4
4759789 2283396 2283396 defendant Thomeys John yeoman 608291 608291 Thomeys, John, of Hilderston, yeoman 2
4957724 2344284 2344284 defendant Wele John husbandman 608291 608291 Wele, John, of Hilderston, husbandman 0
5023296 2363718 2363718 defendant Wels or Wele John husbandman 608291 608291 Wels or Wele, John, of Hilderston, husbandman 0
5110888 2389582 2389582 defendant Smyth John smith 608291 608291 Smyth, John, of Hilderston, smith 0
5110892 2389583 2389583 defendant Smyth John smith 608291 608291 Smyth, John, of Hilderston, smith 0
5279355 2439052 2439052 defendant Yareham John carpenter 608291 608291 Yareham, John, of Hilderston, carpenter 2
5376569 2468272 2468272 defendant Robyns John husbandman 608291 608291 Robyns, John, of Hilderston, husbandman 0
5385066 2470805 2470805 defendant Yarham Thomas husbandman 608291 608291 Yarham, Thomas, of Hilderston, husbandman 0
5392758 2472998 2472998 defendant Robyns John husbandman 608291 608291 Robyns, John, of Hilderston, husbandman 0
5397079 2474248 2474248 defendant Yarham Thomas husbandman 608291 608291 Yarham, Thomas, of Hilderston, husbandman 3
5515080 2509562 2509562 defendant Adams John husbandman 608291 608291 Adams, John, of Hilderston, husbandman 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);