names

47 rows where place_id = 628283

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3781497 1951952 1951952 defendant Bayman Robert yeoman 628283 628283 Bayman, Robert, of Marlesford, yeoman 0
3857548 1975995 1975995 defendant Flete Richard husbandman 628283 628283 Flete, Richard, of Marlesford, husbandman 1
3969652 2013990 2013990 defendant Welles Edmund yeoman 628283 628283 Welles, Edmund, of Marlesford, yeoman 0
3974808 2015752 2015752 defendant Well Edmund husbandman 628283 628283 Well, Edmund, of Marlesford, husbandman 3
4032363 2036242 2036242 defendant Bayman Christopher gent 628283 628283 Bayman, Christopher, of Marlesford, gent 2
4032367 2036243 2036243 defendant Bayman Christopher gent 628283 628283 Bayman, Christopher, of Marlesford, gent 2
4046157 2041065 2041065 defendant Bayman Christopher gent 628283 628283 Bayman, Christopher, of Marlesford, gent 0
4046159 2041066 2041066 defendant Bayman Christopher gent 628283 628283 Bayman, Christopher, of Marlesford, gent 0
4066951 2048477 2048477 defendant Dameron John pedder 628283 628283 Dameron, John, of Marlesford, pedder 0
4294669 2128180 2128180 defendant Chapnell Henry yeoman 628283 628283 Chapnell, Henry, of Marlesford, yeoman 0
4331863 2140949 2140949 defendant Whighte Thomas husbandman 628283 628283 Whighte, Thomas, of Marlesford, husbandman 1
4398569 2164101 2164101 defendant Garrard John husbandman 628283 628283 Garrard, John, of Marlesford, husbandman 2
4483309 2195480 2195480 defendant Hughson Thomas falconer 628283 628283 Hughson, Thomas, of Marlesford, falconer 0
4483310 2195480 2195480 defendant Botyld John   628283 628283 Botyld, John, of Marlesford 1
4597756 2230550 2230550 plaintiff Skynnere John   628283 628283 Skynnere, John, of Marlesford 0
4716726 2270551 2270551 defendant Smyth John smith 628283 628283 Smyth, John, of Marlesford, smith 0
4752102 2281097 2281097 plaintiff Styward John   628283 628283 Styward, John, of Marlesford, on his own account 0
4793683 2294137 2294137 defendant Whyte Robert butcher 628283 628283 Whyte, Robert, of Marlesford, butcher 0
4808477 2298820 2298820 defendant Whyte Robert butcher 628283 628283 Whyte, Robert, of Marlesford, butcher 0
4833463 2306472 2306472 defendant Croos Henry laborer 628283 628283 Croos, Henry, of Marlesford, laborer 0
4833504 2306485 2306485 defendant Luttewyn John tanner 628283 628283 Luttewyn, John, of Marlesford, tanner 0
4886920 2322761 2322761 defendant Whyte Robert butcher 628283 628283 Whyte, Robert, of Marlesford, butcher 1
4889546 2323527 2323527 defendant Gorald William clerk 628283 628283 Gorald, William, of Marlesford, clerk 0
4911849 2330209 2330209 defendant Smyth John smith 628283 628283 Smyth, John, of Marlesford, smith 0
4925515 2334412 2334412 defendant Smyth Roger smith 628283 628283 Smyth, Roger, of Marlesford, smith 1
4941537 2339370 2339370 defendant Chapelyn William, senior yeoman 628283 628283 Chapelyn, William, senior, of Marlesford, yeoman 0
4941538 2339370 2339370 defendant Chapelyn William, junior yeoman 628283 628283 Chapelyn, William, junior, of Marlesford, yeoman 1
4943190 2339839 2339839 defendant Gorald William clerk 628283 628283 Gorald, William, of Marlesford, clerk 3
4954146 2343209 2343209 defendant White Robert laborer 628283 628283 White, Robert, of Marlesford, laborer 0
4981449 2351368 2351368 plaintiff Styward John   628283 628283 Styward, John, of Marlesford 0
4981453 2351369 2351369 plaintiff Styward John   628283 628283 Styward, John, of Marlesford 0
5011682 2360266 2360266 defendant Gorell William   628283 628283 Gorell, William, of Marlesford, parson 0
5049898 2371595 2371595 defendant Styward John gent 628283 628283 Styward, John, of Marlesford, gent 0
5049997 2371620 2371620 plaintiff Styward John   628283 628283 Styward, John, of Marlesford 0
5069849 2377475 2377475 defendant Pecot John yeoman 628283 628283 Pecot, John, of Marlesford, yeoman 4
5087029 2382585 2382585 defendant Pycot John yeoman 628283 628283 Pycot, John, of Marlesford, yeoman 2
5120973 2392568 2392568 plaintiff Styward John (legal representative) 628283 628283 Styward, John, of Marlesford, executors of 0
5161478 2404458 2404458 plaintiff Styward John (legal representative) 628283 628283 Styward, John, of Marlesford, executors of 0
5175868 2408625 2408625 plaintiff Styward John (legal representative) 628283 628283 Styward, John, of Marlesford, executors of 0
5210175 2418704 2418704 plaintiff Styward John (legal representative) 628283 628283 Styward, John, of Marlesford, executors of 0
5335634 2455729 2455729 defendant Pye William carpenter 628283 628283 Pye, William, of Marlesford, carpenter 0
5346787 2459154 2459154 defendant Pye William carpenter 628283 628283 Pye, William, of Marlesford, carpenter 0
5457880 2492255 2492255 defendant Cotell Richard yeoman 628283 628283 Cotell, Richard, of Marlesford, yeoman 0
5503628 2506050 2506050 defendant Cotell Richard husbandman 628283 628283 Cotell, Richard, of Marlesford, husbandman 0
5521880 2511658 2511658 defendant Bokkyng Richard clerk 628283 628283 Bokkyng, Richard, of Marlesford, clerk 3
5626560 2552278 2552278 defendant Compaygnon Luke husbandman 628283 628283 Compaygnon, Luke, of Marlesford, husbandman 0
5626561 2552278 2552278 defendant Thurg- John laborer 628283 628283 Thurg-, John, of Marlesford, laborer 1

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