names

59 rows where place_id = 587353

✎ 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
3591163 1864857 1864857 defendant Howeden James yeoman 587353 587353 Howeden, James, of Est Markham, yeoman 0
3625544 1875527 1875527 defendant Cresy John gent 587353 587353 Cresy, John, of Est Markham, gent 0
3625545 1875527 1875527 defendant Cresy Thomas gent 587353 587353 Cresy, Thomas, of Est Markham, gent 1
3625546 1875527 1875527 defendant Cresy Robert gent 587353 587353 Cresy, Robert, of Est Markham, gent 2
3625547 1875527 1875527 defendant Shaa Elias yeoman 587353 587353 Shaa, Elias, of Est Markham,yeoman 3
3625548 1875527 1875527 defendant Hopwod John   587353 587353 Hopwod, John, of Est Markham, wright 4
3625549 1875527 1875527 defendant Mylner Leo   587353 587353 Mylner, Leo, of Est Markham, wright 5
3625550 1875527 1875527 defendant Arowesmyth Thomas   587353 587353 Arowesmyth, Thomas, of Est Markham, cartwright 6
3661585 1913900 1913900 defendant Levesey Edmund yeoman 587353 587353 Levesey, Edmund, of Est Markham, yeoman 0
3661586 1913900 1913900 defendant Levesey Thomas yeoman 587353 587353 Levesey, Thomas, of Est Markham, yeoman 1
3661587 1913900 1913900 defendant Levesey Alexander laborer 587353 587353 Levesey, Alexander, of Est Markham, laborer 2
3661588 1913900 1913900 defendant Rekkyngham Lambert laborer 587353 587353 Rekkyngham, Lambert, of Est Markham, laborer 3
3661589 1913900 1913900 defendant Sleford Robert laborer 587353 587353 Sleford, Robert, of Est Markham, laborer 4
3661591 1913901 1913901 defendant Levesey Edmund yeoman 587353 587353 Levesey, Edmund, of Est Markham, yeoman 0
3661592 1913901 1913901 defendant Levesey Thomas yeoman 587353 587353 Levesey, Thomas, of Est Markham, yeoman 1
3661593 1913901 1913901 defendant Levesey Alexander laborer 587353 587353 Levesey, Alexander, of Est Markham, laborer 2
3661594 1913901 1913901 defendant Rekkyngham Lambert laborer 587353 587353 Rekkyngham, Lambert, of Est Markham, laborer 3
3661595 1913901 1913901 defendant Sleford Robert laborer 587353 587353 Sleford, Robert, of Est Markham, laborer 4
3661597 1913902 1913902 defendant Levesey Thomas yeoman 587353 587353 Levesey, Thomas, of Est Markham, yeoman 0
3661599 1913903 1913903 defendant Levesey Thomas yeoman 587353 587353 Levesey, Thomas, of Est Markham, yeoman 0
3661601 1913904 1913904 defendant Levesey Thomas yeoman 587353 587353 Levesey, Thomas, of Est Markham, yeoman 0
3666128 1915351 1915351 defendant Lawe Robert gent 587353 587353 Lawe, Robert, of East Markham, gent 0
3695945 1924970 1924970 defendant Benett Henry butcher 587353 587353 Benett, Henry, of Est Markham, butcher 0
3821517 1964625 1964625 defendant Burton Richard tailor 587353 587353 Burton, Richard, of Est Markham, tailor 0
3910761 1993920 1993920 plaintiff Turnell William yeoman 587353 587353 Turnell, William, of Est Markham, yeoman 0
3941431 2004143 2004143 plaintiff Turnell William   587353 587353 Turnell, William, of East Markham 0
4155914 2080146 2080146 defendant Haslabye Samuel yeoman 587353 587353 Haslabye, Samuel, of East Markham, yeoman 0
4420601 2171346 2171346 plaintiff Bychebek Robert   587353 587353 Bychebek, Robert, of East Markham 0
4421607 2171650 2171650 plaintiff Cressy Peter de   587353 587353 Cressy, Peter de, of East Markham, son of Roger 0
4449141 2184675 2184675 defendant Hamond John   587353 587353 Hamond, John, of East markham 0
4576687 2224219 2224219 defendant Hamond John   587353 587353 Hamond, John, of East Markham 0
4613832 2235341 2235341 plaintiff Derleton John   587353 587353 Derleton, John, of East Markham, vicar 0
4696021 2264241 2264241 defendant Hamond Robert husbandman 587353 587353 Hamond, Robert, of East Markham, husbandman 0
4696022 2264241 2264241 defendant Scot John husbandman 587353 587353 Scot, John, of East Markham, husbandman 1
4696023 2264241 2264241 defendant Sylkston John husbandman 587353 587353 Sylkston, John, of East Markham, husbandman 2
4854126 2312702 2312702 defendant Bole Robert husbandman 587353 587353 Bole, Robert, of East Markham, husbandman 0
4854128 2312702 2312702 defendant Robert servant Donham Godfrey   587353 587353 Robert servant Donham, Godfrey, of East Markham, servant 2
4947696 2341265 2341265 defendant Ryppyngham John husbandman 587353 587353 Ryppyngham, John, of Est Markham, husbandman 1
4999523 2356731 2356731 defendant Crecy William   587353 587353 Crecy, William, of East Markham, franklin 1
5026879 2364731 2364731 defendant Coteler William yeoman 587353 587353 Coteler, William, of Est Markham, yeoman 1
5156474 2403049 2403049 defendant Bek Robert husbandman 587353 587353 Bek, Robert, of East Markham, husbandman 1
5172669 2407734 2407734 defendant Bek Robert husbandman 587353 587353 Bek, Robert, of East markham, husbandman 1
5192340 2413497 2413497 defendant Bek Robert husbandman 587353 587353 Bek, Robert, of East Markham, husbandman 1
5252091 2430764 2430764 defendant Sheylys Nicholas tailor 587353 587353 Sheylys, Nicholas, of Est Markham, tailor 0
5252093 2430764 2430764 defendant Ryplyngham John husbandman 587353 587353 Ryplyngham, John, of Est Markham, husbandman 2
5252095 2430764 2430764 defendant Howton John smith 587353 587353 Howton, John, of Est Markham, smith 4
5263435 2434313 2434313 defendant Grene John husbandman 587353 587353 Grene, John, of Est Markham, or of Litell Markham, husbandman 0
5297386 2444237 2444237 defendant Byllyold Robert yeoman 587353 587353 Byllyold, Robert, of East Markham, yeoman 0
5302762 2445809 2445809 defendant Bek Robert husbandman 587353 587353 Bek, Robert, of East Markham, husbandman 4
5328153 2453493 2453493 defendant Mercer Thomas chapman 587353 587353 Mercer, Thomas, of Est Markham, chapman 0
5379134 2469070 2469070 defendant Fyssher Hugh yeoman 587353 587353 Fyssher, Hugh, of East Markham, yeoman 0
5388515 2471768 2471768 defendant Parkyll Roger clerk 587353 587353 Parkyll, Roger, of East Markham, clerk 0
5462000 2493529 2493529 defendant Dam John husbandman 587353 587353 Dam, John, of East Markham, husbandman 2
5470939 2496239 2496239 defendant Parkyll Roger clerk 587353 587353 Parkyll, Roger, of East Markham, clerk 0
5473524 2497045 2497045 defendant Dam John smith 587353 587353 Dam, John, of East Markham, smith 2
5473530 2497046 2497046 defendant Dam John smith 587353 587353 Dam, John, of East Markham, smith 2
5490304 2501987 2501987 defendant Gyles William smith 587353 587353 Gyles, William, of Est Markham, smith 1
5516066 2509873 2509873 defendant Parre Thomas husbandman 587353 587353 Parre, Thomas, of Est Markham, husbandman 1
5565863 2524613 2524613 defendant Clerk Robert butcher 587353 587353 Clerk, Robert, of Est Markham, butcher 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);