names

36 rows where place_id = 596550

✎ 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
3625210 1875420 1875420 defendant Hadde John gent 596550 596550 Hadde, John, of Rochester St Margaret, gent 0
3633194 1905196 1905196 defendant Mansser Geoffrey laborer 596550 596550 Mansser, Geoffrey, of Rochester St Margaret, laborer 0
3633198 1905197 1905197 defendant Mansser Geoffrey laborer 596550 596550 Mansser, Geoffrey, of Rochester St Margaret, laborer 0
3637456 1906523 1906523 plaintiff Smyth Kawrence   596550 596550 Smyth, Kawrence, of Rochester St Margaret 0
3722107 1933176 1933176 defendant Close John husbandman 596550 596550 Close, John, of Rochester St Margaret, husbandman 5
3722758 1933384 1933384 defendant May Edward   596550 596550 May, Edward, of Rochester St Margaret 0
3723806 1933722 1933722 defendant Mayhewe Edward tailor 596550 596550 Mayhewe, Edward, of Rochester St Margaret, tailor 0
3723812 1933724 1933724 defendant Maples Thomas husbandman 596550 596550 Maples, Thomas, of Rochester St Margaret, husbandman 1
3724553 1933965 1933965 defendant Cloce John husbandman 596550 596550 Cloce, John, of Rochester St Margaret, husbandman 0
3724557 1933966 1933966 defendant Goly John husbandman 596550 596550 Goly, John, of Rochester St Margaret, husbandman 0
3724558 1933966 1933966 defendant Halle Richard husbandman 596550 596550 Halle, Richard, of Rochester St Margaret, husbandman 1
3725256 1934187 1934187 plaintiff Smyth Lawrence   596550 596550 Smyth, Lawrence, of Rochester St Margaret 0
3733826 1936833 1936833 defendant Ostregge Edmund yeoman 596550 596550 Ostregge, Edmund, of Rochester St Margaret, yeoman 0
3740463 1938874 1938874 defendant Parson John husbandman 596550 596550 Parson, John, of Rochester St Margaret, husbandman 0
3831564 1967762 1967762 defendant Carlton William yeoman 596550 596550 Carlton, William, of Rochester St Margaret, yeoman 0
3831565 1967762 1967762 defendant Stone Marion widow 596550 596550 Stone, Marion, of Rochester St Margaret, widow 1
4796321 2294997 2294997 defendant Whyte Thomas gent 596550 596550 Whyte, Thomas, of Rochester St Margaret, gent 0
4905680 2328377 2328377 defendant Hardell John farmer 596550 596550 Hardell, John, of Rochester St Margaret, farmer 2
5068718 2377139 2377139 defendant Herdell John husbandman 596550 596550 Herdell, John, of Rochester St Margaret, husbandman 0
5069806 2377462 2377462 defendant Ussheer Thomas husbandman 596550 596550 Ussheer, Thomas, of Rochester St Margaret, husbandman 0
5082981 2381415 2381415 defendant Haylyng Roger husbandman 596550 596550 Haylyng, Roger, of Rochester St Margaret, husbandman 0
5117432 2391530 2391530 defendant Boteler Joan widow 596550 596550 Boteler, Joan, of Rochester St Margaret, widow 0
5225125 2423019 2423019 defendant Essher Thomas yeoman 596550 596550 Essher, Thomas, of Rochester St Margaret, yeoman 0
5360654 2463362 2463362 defendant Pylcher Richard husbandman 596550 596550 Pylcher, Richard, of Rochester St Margaret, husbandman 1
5361999 2463778 2463778 defendant Pylcher Richard husbandman 596550 596550 Pylcher, Richard, of Rochester St Margaret, husbandman 0
5504478 2506317 2506317 defendant Braban Joan widow 596550 596550 Braban, Joan, of Rochester St Margaret, widow 0
5511639 2508487 2508487 defendant Tukker Thomas laborer 596550 596550 Tukker, Thomas, of Rochester St Margaret, laborer 2
5513065 2508939 2508939 defendant Hadde John gent 596550 596550 Hadde, John, of Rochester St Margaret, gent 3
5530588 2514084 2514084 defendant Cardon John   596550 596550 Cardon, John, of Rochester St Margaret, franklin 0
5531176 2514265 2514265 defendant Man John husbandman 596550 596550 Man, John, of Rochester St Margaret, husbandman 0
5531178 2514265 2514265 defendant Nicolson William husbandman 596550 596550 Nicolson, William, of Rochester St Margaret, husbandman 2
5531185 2514268 2514268 defendant Nicholas William   596550 596550 Nicholas, William, of Rochester St Margaret 0
5532209 2514620 2514620 defendant Garrard John husbandman 596550 596550 Garrard, John, of Rochester St Margaret, husbandman 0
5562376 2523596 2523596 defendant Vistboll Richard yeoman 596550 596550 Vistboll, Richard, of Rochester St Margaret, yeoman 3
5562377 2523596 2523596 defendant Smyth Lawrence yeoman 596550 596550 Smyth, Lawrence, of Rochester St Margaret, yeoman 4
5596532 2533830 2533830 defendant Goddyn Richard yeoman 596550 596550 Goddyn, Richard, of Rochester St Margaret, yeoman 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);