names

43 rows where place_id = 640057

✎ 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
3822962 1965090 1965090 plaintiff Tayllour Robert   640057 640057 Tayllour, Robert, of Stevynton, wool seller 0
3852814 1974487 1974487 defendant Derlyng Robert husbandman 640057 640057 Derlyng, Robert, of Stevynton, husbandman 0
3852815 1974487 1974487 defendant Agnes Richard laborer 640057 640057 Agnes, Richard, of Stevynton, laborer 1
3854293 1974978 1974978 plaintiff Tayler Robert woolman 640057 640057 Tayler, Robert, of Stevynton, woolman 0
3870673 1980434 1980434 defendant Lyvord Robert husbandman 640057 640057 Lyvord, Robert, of Stevynton, husbandman 0
3882922 1984554 1984554 defendant Pake Robert butcher 640057 640057 Pake, Robert, of Stevynton, butcher 0
3882923 1984554 1984554 defendant Gardener John husbandman 640057 640057 Gardener, John, of Stevynton, husbandman 1
3882924 1984554 1984554 defendant Fyssher Thomas laborer 640057 640057 Fyssher, Thomas, of Stevynton, laborer 2
3896065 1988888 1988888 plaintiff Tayller John   640057 640057 Tayller, John, of Stevynton 0
3896068 1988889 1988889 plaintiff Tayller Robert yeoman 640057 640057 Tayller, Robert, of Stevynton, yeoman 0
3896069 1988889 1988889 plaintiff Tayller John yeoman 640057 640057 Tayller, John, of Stevynton, yeoman 1
3896082 1988893 1988893 plaintiff Tayllour Robert   640057 640057 Tayllour, Robert, of Stevynton 0
3896085 1988894 1988894 plaintiff Tayllour Robert woolman 640057 640057 Tayllour, Robert, of Stevynton, woolman 0
4305625 2132102 2132102 defendant Darlynge Edward yeoman 640057 640057 Darlynge, Edward, of Stevynton, yeoman 0
4486553 2196506 2196506 defendant Smyth John   640057 640057 Smyth, John, of Stevynton 0
4486554 2196506 2196506 defendant Smyth William   640057 640057 Smyth, William, of Stevynton 1
4515082 2205129 2205129 defendant Hykford Robert   640057 640057 Hykford, Robert, of Stevynton 0
4548047 2215325 2215325 defendant Bordewater William   640057 640057 Bordewater, William, of Stevynton 0
4560575 2219247 2219247 defendant Fousehill William   640057 640057 Fousehill, William, of Stevynton 0
4569700 2222107 2222107 defendant Bolter John   640057 640057 Bolter, John, of Stevynton 0
4599213 2230966 2230966 defendant Godusday Robert   640057 640057 Godusday, Robert, of Stevynton 0
4602611 2232035 2232035 defendant Foulere William   640057 640057 Foulere, William, of Stevynton 0
4602612 2232035 2232035 defendant Brightwelton Robert   640057 640057 Brightwelton, Robert, of Stevynton 1
4602613 2232035 2232035 defendant Clere Robert   640057 640057 Clere, Robert, of Stevynton 2
4653646 2247067 2247067 defendant Bolle Robert laborer 640057 640057 Bolle, Robert, of Stevynton, laborer 2
4691623 2262911 2262911 defendant Wirysdale William fuller 640057 640057 Wirysdale, William, of Stevynton, fuller 0
4703056 2266338 2266338 defendant Wirysdale William fuller 640057 640057 Wirysdale, William, of Stevynton, fuller 0
4748226 2279987 2279987 defendant Edmunde Robert husbandman 640057 640057 Edmunde, Robert, of Stevynton, husbandman 2
4748227 2279987 2279987 defendant Saundres William husbandman 640057 640057 Saundres, William, of Stevynton, husbandman 3
4773388 2287651 2287651 defendant Prest John chapman 640057 640057 Prest, John, of Stevynton, chapman 1
4835536 2307104 2307104 defendant Pake John husbandman 640057 640057 Pake, John, of Stevynton, husbandman 0
4845783 2310191 2310191 defendant Edmond Robert husbandman 640057 640057 Edmond, Robert, of Stevynton, husbandman 0
5011835 2360312 2360312 defendant Brayne John husbandman 640057 640057 Brayne, John, of Stevynton, husbandman 0
5069970 2377513 2377513 defendant Carpynter William husbandman 640057 640057 Carpynter, William, of Stevynton, husbandman 0
5284249 2440413 2440413 defendant Seward John butcher 640057 640057 Seward, John, of Stevynton, butcher 0
5505036 2506485 2506485 defendant Scoll John husbandman 640057 640057 Scoll, John, of Stevynton, husbandman 1
5509633 2507848 2507848 defendant Sharp John husbandman 640057 640057 Sharp, John, of Stevynton, husbandman 0
5509634 2507848 2507848 defendant Sharp Robert husbandman 640057 640057 Sharp, Robert, of Stevynton, husbandman 1
5512800 2508855 2508855 defendant Lyford William husbandman 640057 640057 Lyford, William, of Stevynton, husbandman 1
5519809 2511032 2511032 defendant Fyssher John, junior tailor 640057 640057 Fyssher, John, junior, of Stevynton, tailor 0
5549607 2519935 2519935 defendant Scharpe John butcher 640057 640057 Scharpe, John, of Stevynton, butcher 0
5593497 2532951 2532951 defendant Sharp John yeoman 640057 640057 Sharp, John, of Stevynton, yeoman 1
5596807 2533920 2533920 defendant Carpenter Richard clothier 640057 640057 Carpenter, Richard, of Stevynton, clothier 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);