names

23 rows where place_id = 594740

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3617390 1873057 1873057 defendant Warry John husbandman 594740 594740 Warry, John, of Wynsham, husbandman 0
3617391 1873057 1873057 defendant Warry Stephen husbandman 594740 594740 Warry, Stephen, of Wynsham, husbandman 1
3628618 1903825 1903825 defendant Reynold William miller 594740 594740 Reynold, William, of Wynsham, miller 1
3818118 1963580 1963580 defendant Hays Mark gent 594740 594740 Hays, Mark, of Wynsham, gent 0
3885077 1985269 1985269 defendant Baggewyll Simon yeoman 594740 594740 Baggewyll, Simon, of Wynsham, yeoman 0
3930142 2000426 2000426 defendant Payne John smith 594740 594740 Payne, John, of Wynsham, smith 1
3930143 2000426 2000426 defendant Bennett John, junior weaver 594740 594740 Bennett, John, junior, of Wynsham, weaver 2
4075667 2051600 2051600 defendant Wallis Agnes widow 594740 594740 Wallis, Agnes, of Wynsham, widow 0
4149251 2077864 2077864 defendant Bell Thomas gent 594740 594740 Bell, Thomas, of Wynsham, gent 0
4176092 2087115 2087115 defendant Hill William smith 594740 594740 Hill, William, of Wynsham, smith 1
4353060 2148299 2148299 defendant Richardes William tanner 594740 594740 Richardes, William, of Wynsham, tanner 0
4353065 2148300 2148300 defendant Parker James yeoman 594740 594740 Parker, James, of Wynsham, yeoman 0
4453491 2186098 2186098 defendant Smyth John   594740 594740 Smyth, John, of Wynsham 0
4680562 2259532 2259532 defendant Cartere William singleman 594740 594740 Cartere, William, of Wynsham, singleman 4
4680563 2259532 2259532 defendant Mulward William husbandman 594740 594740 Mulward, William, of Wynsham, husbandman 5
4817347 2301512 2301512 defendant Hordon Thomas husbandman 594740 594740 Hordon, Thomas, of Wynsham, husbandman 3
4831491 2305880 2305880 defendant Lovecok William husbandman 594740 594740 Lovecok, William, of Wynsham, husbandman 0
4987213 2353124 2353124 defendant Middenhill Walter husbandman 594740 594740 Middenhill, Walter, of Wynsham, husbandman 0
5055702 2373274 2373274 defendant Wylly Robert laborer 594740 594740 Wylly, Robert, of Wynsham,laborer 1
5078335 2380012 2380012 defendant Croweche John husbandman 594740 594740 Croweche, John, of Wynsham, husbandman 1
5078818 2380153 2380153 defendant Middynhill Walter   594740 594740 Middynhill, Walter, of Wynsham, franklin 0
5078819 2380153 2380153 defendant Crowyche John husbandman 594740 594740 Crowyche, John, of Wynsham, husbandman 1
5547459 2519272 2519272 defendant Taillour William husbandman 594740 594740 Taillour, William, of Wynsham, 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);