names

41 rows where place_id = 589020

✎ 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
3596291 1866469 1866469 defendant Smyth William smith 589020 589020 Smyth, William, of Magna Marlowe, Bucks, smith 4
3596295 1866470 1866470 defendant Burford Thomas smith 589020 589020 Burford, Thomas, of Magna Marlowe, Bucks, smith 2
3684924 1921417 1921417 defendant Plumrydge Thomas husbandman 589020 589020 Plumrydge, Thomas, of Magna Marlowe, Bucks, husbandman 3
3688440 1922540 1922540 defendant Sandys John gent 589020 589020 Sandys, John, of Magna Marlowe, Bucks, gent 2
3738466 1938234 1938234 defendant Burford Thomas husbandman 589020 589020 Burford, Thomas, of Magna Marlowe, Bucks, husbandman 2
3850374 1973706 1973706 defendant Haltman Edmund clerk 589020 589020 Haltman, Edmund, of Magna Marlowe, Bucks, clerk 0
3871876 1980830 1980830 defendant Prest William yeoman 589020 589020 Prest, William, of Magna Marlowe, Bucks, yeoman 3
3959437 2010386 2010386 defendant Mathewe Richard bargeman 589020 589020 Mathewe, Richard, of Magna Marlowe, Bucks, bargeman 0
3996297 2023425 2023425 defendant Lamden William baker 589020 589020 Lamden, William, of Magna Marlowe, Bucks, baker 0
4032333 2036235 2036235 defendant Edward Thomas chapman 589020 589020 Edward, Thomas, of Magna Marlowe, Bucks, chapman 2
4032338 2036236 2036236 defendant Edward Thomas chapman 589020 589020 Edward, Thomas, of Magna Marlowe, Bucks, chapman 2
4039111 2038615 2038615 defendant Wade John yeoman or bargeman 589020 589020 Wade, John, of Magna Marlowe, Bucks, yeoman or bargeman 0
4074064 2051017 2051017 defendant Prieste Hugh yeoman 589020 589020 Prieste, Hugh, of Magna Marlowe, Bucks, yeoman 0
4074067 2051018 2051018 defendant Prieste Hugh yeoman 589020 589020 Prieste, Hugh, of Magna Marlowe, Bucks, yeoman 0
4076201 2051777 2051777 plaintiff Sharpe John yeoman 589020 589020 Sharpe, John, of Magna Marlowe, Bucks, yeoman 0
4076203 2051778 2051778 plaintiff Sharpe John yeoman 589020 589020 Sharpe, John, of Magna Marlowe, Bucks, yeoman 0
4076599 2051930 2051930 defendant Mathewe Roger bargeman 589020 589020 Mathewe, Roger, of Magna Marlowe, Bucks, bargeman 0
4078116 2052478 2052478 defendant Lamden William yeoman 589020 589020 Lamden, William, of Magna Marlowe, Bucks, yeoman 0
4101753 2060936 2060936 defendant Turner Michael yeoman 589020 589020 Turner, Michael, of Magna Marlowe, Bucks, yeoman 0
4203726 2096859 2096859 defendant Pasmore Richard chapman 589020 589020 Pasmore, Richard, of Magna Marlowe, Bucks, chapman 3
4211950 2099730 2099730 defendant Mathewe Richard bargeman 589020 589020 Mathewe, Richard, of Magna Marlowe, Bucks, bargeman 1
4220666 2102727 2102727 defendant Seymor John bargeman 589020 589020 Seymor, John, of Magna Marlowe, Bucks, yeoman, bargeman 0
4283488 2124128 2124128 defendant Turner Michael yeoman 589020 589020 Turner, Michael, of Magna Marlowe, Bucks, yeoman 0
4286240 2125132 2125132 defendant Skynner Thomas   589020 589020 Skynner, Thomas, of Magna Marlowe, Bucks, barge man 2
4327028 2139369 2139369 defendant Shrimpton Thomas yeoman 589020 589020 Shrimpton, Thomas, of Magna Marlowe, Bucks, yeoman 3
4335079 2142005 2142005 defendant Turner Michael, junior gent 589020 589020 Turner, Michael, junior, of Magna Marlowe, Bucks, gent 0
4336485 2142496 2142496 defendant Pusey Robert cordwainer 589020 589020 Pusey, Robert, of Magna Marlowe, Bucks, cordwainer 0
4358429 2150180 2150180 defendant Seamer John yeoman 589020 589020 Seamer, John, of Magna Marlowe, Bucks, yeoman 1
4367012 2153258 2153258 defendant Deane Thomas yeoman 589020 589020 Deane, Thomas, of Magna Marlowe, Bucks, yeoman 0
4392669 2162167 2162167 defendant Bennett Thomas gent 589020 589020 Bennett, Thomas, of Magna Marlowe, Bucks, gent 0
5215809 2420349 2420349 defendant Flegge John gent 589020 589020 Flegge, John, of Magna Marlowe, Bucks, gent 3
5232409 2425050 2425050 defendant Smyth John   589020 589020 Smyth, John, of Magna Marlowe, Bucks, ferrour 0
5234107 2425569 2425569 defendant Bullok Thomas husbandman 589020 589020 Bullok, Thomas, of Magna Marlowe, Bucks, husbandman 0
5342380 2457812 2457812 defendant Persson Arnold (legal representative) 589020 589020 Persson, Arnold, of Magna Marlowe, Bucks, surgeon, executor of 0
5482728 2499778 2499778 defendant Dyconson Richard yeoman 589020 589020 Dyconson, Richard, of Magna Marlowe, Bucks, yeoman 0
5482730 2499779 2499779 defendant Dyconson Richard yeoman 589020 589020 Dyconson, Richard, of Magna Marlowe, Bucks, yeoman 0
5499485 2504789 2504789 defendant Dekynson Richard yeoman 589020 589020 Dekynson, Richard, of Magna Marlowe, Bucks, yeoman 0
5501749 2505480 2505480 defendant Dyconson Richard yeoman 589020 589020 Dyconson, Richard, of Magna Marlowe, Bucks, yeoman 0
5506146 2506841 2506841 defendant Wodeward John miller 589020 589020 Wodeward, John, of Magna Marlowe, Bucks, miller 0
5549408 2519880 2519880 defendant Seman Roger chapman 589020 589020 Seman, Roger, of Magna Marlowe, Bucks, chapman 1
5551480 2520471 2520471 defendant Colard John husbandman 589020 589020 Colard, John, of Magna Marlowe, Bucks, 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);