names

46 rows where place_id = 592896

✎ 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
3609304 1870569 1870569 defendant Chese William husbandman 592896 592896 Chese, William, of Magna Munden, husbandman 2
3717810 1931874 1931874 defendant Aunsell Robert husbandman 592896 592896 Aunsell, Robert, of Magna Munden, husbandman 0
3717811 1931874 1931874 defendant Andrewe John husbandman 592896 592896 Andrewe, John, of Magna Munden, husbandman 1
3720431 1932670 1932670 defendant Andrewe John husbandman or maltman 592896 592896 Andrewe, John, of Magna Munden, husbandman or maltman 0
3732861 1936506 1936506 defendant Andrewe John husbandman 592896 592896 Andrewe, John, of Magna Munden, husbandman 0
3733041 1936556 1936556 defendant Andrewe John husbandman 592896 592896 Andrewe, John, of Magna Munden, husbandman 0
3735003 1937183 1937183 defendant Andrewe John maltman 592896 592896 Andrewe, John, of Magna Munden, maltman 0
3736173 1937556 1937556 defendant Andrewe John husbandman or maltman 592896 592896 Andrewe, John, of Magna Munden, husbandman or maltman 0
3740037 1938738 1938738 defendant Austen William laborer 592896 592896 Austen, William, of Magna Munden, laborer 0
3740038 1938738 1938738 defendant Froste Thomas husbandman 592896 592896 Froste, Thomas, of Magna Munden, husbandman 1
3741146 1939093 1939093 defendant Andrewe John husbandman 592896 592896 Andrewe, John, of Magna Munden, husbandman 0
3763317 1946159 1946159 defendant Woode Thomas maltman 592896 592896 Woode, Thomas, of Magna Munden, maltman 2
3764463 1946546 1946546 defendant Andrewe William yeoman 592896 592896 Andrewe, William, of Magna Munden, yeoman 0
3770681 1948512 1948512 defendant Auncell Robert husbandman 592896 592896 Auncell, Robert, of Magna Munden, husbandman 0
3770684 1948513 1948513 defendant Auncell John husbandman 592896 592896 Auncell, John, of Magna Munden, husbandman 1
3781230 1951870 1951870 defendant Auncell Robert husbandman 592896 592896 Auncell, Robert, of Magna Munden, husbandman 0
3793343 1955779 1955779 defendant Bonde Thomas sawyer 592896 592896 Bonde, Thomas, of Magna Munden, sawyer 1
3798002 1957273 1957273 defendant Rawlyn Walter shoemaker 592896 592896 Rawlyn, Walter, of Magna Munden, shoemaker 0
3812471 1961788 1961788 defendant Selle Simon maltman 592896 592896 Selle, Simon, of Magna Munden, maltman 0
3903636 1991447 1991447 defendant Sell Simon husbandman 592896 592896 Sell, Simon, of Magna Munden, husbandman 0
3903689 1991465 1991465 defendant Chery Thomas husbandman 592896 592896 Chery, Thomas, of Magna Munden, husbandman 0
3903690 1991465 1991465 defendant Sell Simon husbandman 592896 592896 Sell, Simon, of Magna Munden, husbandman 1
3903691 1991465 1991465 defendant Miles William husbandman 592896 592896 Miles, William, of Magna Munden, husbandman 2
3903692 1991465 1991465 defendant Browne William husbandman 592896 592896 Browne, William, of Magna Munden, husbandman 3
3950533 2007267 2007267 defendant Gardner Philip husbandman 592896 592896 Gardner, Philip, of Magna Munden, husbandman 0
3950534 2007267 2007267 defendant Tyler Thomas maltman 592896 592896 Tyler, Thomas, of Magna Munden, maltman 1
4898391 2326152 2326152 defendant Tounesende John husbandman 592896 592896 Tounesende, John, of Magna Munden, husbandman 0
4898392 2326152 2326152 defendant Grene John husbandman 592896 592896 Grene, John, of Magna Munden, husbandman 1
4983731 2352060 2352060 defendant Gayler William husbandman 592896 592896 Gayler, William, of Magna Munden, husbandman 2
5084046 2381731 2381731 defendant Symmes William husbandman 592896 592896 Symmes, William, of Magna Munden, husbandman 0
5103817 2387541 2387541 defendant Andrewe alias Borell William maltman 592896 592896 Andrewe alias Borell, William, of Magna Munden, maltman 0
5109087 2389079 2389079 defendant Andrewe William husbandman 592896 592896 Andrewe, William, of Magna Munden, husbandman 1
5227004 2423551 2423551 defendant Stokker William husbandman 592896 592896 Stokker, William, of Magna Munden, husbandman 0
5262036 2433876 2433876 defendant Webbe Thomas, junior husbandman 592896 592896 Webbe, Thomas, junior, of Magna Munden, husbandman 0
5263620 2434371 2434371 defendant Webbe Thomas maltman 592896 592896 Webbe, Thomas, of Magna Munden, maltman 0
5356392 2462065 2462065 defendant Ponde Edmund husbandman 592896 592896 Ponde, Edmund, of Magna Munden, husbandman 1
5480166 2499052 2499052 defendant Benne Henry husbandman 592896 592896 Benne, Henry, of Magna Munden, husbandman 0
5480169 2499053 2499053 defendant Benne Henry husbandman 592896 592896 Benne, Henry, of Magna Munden, husbandman 0
5491994 2502513 2502513 defendant Chese John maltman 592896 592896 Chese, John, of Magna Munden, maltman 1
5518309 2510554 2510554 defendant Andrewe William, junior husbandman 592896 592896 Andrewe, William, junior, of Magna Munden, husbandman 0
5518310 2510554 2510554 defendant Wrattyng John maltman 592896 592896 Wrattyng, John, of Magna Munden, maltman 1
5533960 2515162 2515162 defendant Duke John miller 592896 592896 Duke, John, of Magna Munden, miller 2
5557752 2522216 2522216 defendant Downes Thomas husbandman 592896 592896 Downes, Thomas, of Magna Munden, husbandman 0
5573539 2526823 2526823 defendant Dowenes Thomas   592896 592896 (Dowenes, Thomas, of Magna Munden, tallow chandler 1
5592358 2532596 2532596 plaintiff Warner William husbandman 592896 592896 Warner, William, of Magna Munden, husbandman 0
5592359 2532596 2532596 defendant Bond Thomas husbandman 592896 592896 Bond, Thomas, of Magna Munden, 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);