names

48 rows where place_id = 592771

✎ 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
3608872 1870431 1870431 defendant Johnson Thomas tanner 592771 592771 Johnson, Thomas, of Tonbregge, tanner 0
3644464 1908686 1908686 defendant Colyn Roger laborer 592771 592771 Colyn, Roger, of Tonbregge, laborer 0
4438700 2181393 2181393 defendant Lange John   592771 592771 Lange, John, of Tonbregge 0
4521673 2207109 2207109 defendant Fleccher Reginald   592771 592771 Fleccher, Reginald, of Tonbregge 0
4543346 2213807 2213807 plaintiff atte Bourne Thomas   592771 592771 atte Bourne, Thomas, of Tonbregge 0
4558549 2218626 2218626 defendant Courch Richard   592771 592771 Courch, Richard, of Tonbregge 0
4559407 2218890 2218890 defendant Wellere Henry   592771 592771 Wellere, Henry, of Tonbregge 1
4572420 2222913 2222913 defendant Kyppes John   592771 592771 Kyppes, John, of Tonbregge 2
4585923 2227022 2227022 defendant Cotynge Roger   592771 592771 Cotynge, Roger, of Tonbregge 0
4585924 2227022 2227022 defendant Kennane John   592771 592771 Kennane, John, of Tonbregge 1
4585929 2227024 2227024 defendant Kent John   592771 592771 Kent, John, of Tonbregge 0
4585930 2227024 2227024 defendant Godefray William   592771 592771 Godefray, William, of Tonbregge 1
4594935 2229670 2229670 plaintiff Pycot John   592771 592771 Pycot, John, of Tonbregge 0
4624156 2238535 2238535 defendant Reade John   592771 592771 Reade, John, of Tonbregge 0
4635970 2242085 2242085 plaintiff atte Bourne Thomas   592771 592771 atte Bourne, Thomas, of Tonbregge 0
4651987 2246556 2246556 plaintiff atte Bourne Thomas   592771 592771 atte Bourne, Thomas, of Tonbregge 0
4651989 2246557 2246557 plaintiff atte Bourne Thomas   592771 592771 atte Bourne, Thomas, of Tonbregge 0
4651991 2246558 2246558 plaintiff atte Bourne Thomas   592771 592771 atte Bourne, Thomas, of Tonbregge 0
4671888 2256853 2256853 defendant Herst John laborer 592771 592771 Herst, John, of Tonbregge, laborer 0
4689453 2262258 2262258 plaintiff Vane John   592771 592771 Vane, John, of Tonbregge 0
4779446 2289549 2289549 defendant Akedon Henry laborer 592771 592771 Akedon, Henry, of Tonbregge, laborer 7
4820212 2302393 2302393 plaintiff Pycot John, senior   592771 592771 Pycot, John, senior, of Tonbregge 0
4820214 2302394 2302394 plaintiff Pycot John, senior   592771 592771 Pycot, John, senior, of Tonbregge 0
4908523 2329222 2329222 defendant Partyche William yeoman 592771 592771 Partyche, William, of Tonbregge, yeoman 0
4946125 2340774 2340774 defendant Hadlo John husbandman 592771 592771 Hadlo, John, of Tonbregge, husbandman 3
4946132 2340775 2340775 defendant Hadlo John husbandman 592771 592771 Hadlo, John, of Tonbregge, husbandman 3
4977653 2350283 2350283 plaintiff Pykotte or Pycot John, senior   592771 592771 Pykotte or Pycot, John, senior, of Tonbregge 0
4977654 2350283 2350283 defendant Wylliam Robert husbandman 592771 592771 Wylliam, Robert, of Tonbregge, husbandman 0
5025190 2364262 2364262 defendant Randolf William yeoman 592771 592771 Randolf, William, of Tonbregge, yeoman 3
5035282 2367180 2367180 defendant Vane Henry husbandman 592771 592771 Vane, Henry, of Tonbregge, husbandman 0
5035283 2367180 2367180 defendant Vane Richard   592771 592771 Vane, Richard, of Tonbregge, servant 1
5035284 2367180 2367180 defendant Henryservantvane William   592771 592771 Henryservantvane, William, of Tonbregge, servant 2
5035413 2367216 2367216 defendant Randolf William gent 592771 592771 Randolf, William, of Tonbregge, gent 0
5069812 2377464 2377464 defendant Gervays Thomas yeoman 592771 592771 Gervays, Thomas, of Tonbregge, yeoman 0
5094381 2384760 2384760 defendant Gervays Thomas yeoman 592771 592771 Gervays, Thomas, of Tonbregge, yeoman 0
5141422 2398607 2398607 defendant Neweburgh William barber 592771 592771 Neweburgh, William, of Tonbregge, barber 4
5193888 2413937 2413937 defendant Fychet John husbandman 592771 592771 Fychet, John, of Tonbregge, husbandman 0
5193890 2413937 2413937 defendant Fychet Thomas husbandman 592771 592771 Fychet, Thomas, of Tonbregge, husbandman 2
5208440 2418195 2418195 defendant Fychet John husbandman 592771 592771 Fychet, John, of Tonbregge, husbandman 0
5336728 2456053 2456053 plaintiff A Vane John yeoman 592771 592771 A Vane, John, of Tonbregge, yeoman 1
5445466 2488542 2488542 plaintiff Fane John yeoman 592771 592771 Fane, John, of Tonbregge, yeoman 0
5458244 2492367 2492367 plaintiff Fane John   592771 592771 Fane, John, of Tonbregge 0
5568163 2525236 2525236 defendant Stacy Peter clothmaker 592771 592771 Stacy, Peter, of Tonbregge, clothmaker 0
5571518 2526224 2526224 defendant Lymden John fuller 592771 592771 Lymden, John, of Tonbregge, fuller 2
5629067 2553062 2553062 plaintiff Pycot John, senior   592771 592771 Pycot, John, senior, of Tonbregge 0
5629068 2553062 2553062 defendant Afolf John   592771 592771 Afolf, John, of Tonbregge 0
5629070 2553063 2553063 defendant Halle Thomas glover 592771 592771 Halle, Thomas, of Tonbregge, glover 0
5629071 2553063 2553063 defendant Cotyng Richard   592771 592771 Cotyng, Richard, of Tonbregge, wood broker 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);