names

55 rows where place_id = 607668

✎ 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
3670263 1916646 1916646 defendant Russell Thomas gent 607668 607668 Russell, Thomas, of Rudham, gent 1
3687174 1922164 1922164 defendant Russell Thomas gent 607668 607668 Russell, Thomas, of Rudham, gent 1
3749435 1941739 1941739 defendant Hodson Robert butcher 607668 607668 Hodson, Robert, of Rudham, butcher 0
3804659 1959397 1959397 defendant Russell Thomas gent 607668 607668 Russell, Thomas, of Rudham, gent 0
3809557 1960874 1960874 defendant Styflyn John clerk 607668 607668 Styflyn, John, of Rudham, clerk 2
3810412 1961147 1961147 defendant Ruttlond William husbandman 607668 607668 Ruttlond, William, of Rudham, husbandman 1
3817234 1963304 1963304 defendant Verdon Robert husbandman 607668 607668 Verdon, Robert, of Rudham, husbandman 8
3846588 1972486 1972486 defendant Warne James husbandman 607668 607668 Warne, James, of Rudham, husbandman 0
3867584 1979393 1979393 defendant Laurence William butcher 607668 607668 Laurence, William, of Rudham, butcher 2
3912558 1994530 1994530 defendant Ryche John husbandman 607668 607668 Ryche, John, of Rudham, husbandman 4
4037499 2038074 2038074 defendant Smyth John husbandman 607668 607668 Smyth, John, of Rudham, husbandman 0
4150796 2078413 2078413 defendant Savery Edward warrener 607668 607668 Savery, Edward, of Rudham, warrener 2
4152975 2079147 2079147 defendant Miles Richard yeoman 607668 607668 Miles, Richard, of Rudham, yeoman 0
4176251 2087171 2087171 defendant Ryche Henry   607668 607668 Ryche, Henry, of Rudham, of yeoman 1
4176252 2087171 2087171 defendant Harbart Richard yeoman 607668 607668 Harbart, Richard, of Rudham, yeoman 2
4199523 2095384 2095384 defendant Ryche Henry yeoman 607668 607668 Ryche, Henry, of Rudham, yeoman 1
4199524 2095384 2095384 defendant Harbart Richard yeoman 607668 607668 Harbart, Richard, of Rudham, yeoman 2
4283593 2124169 2124169 defendant Robynson Richard husbandman 607668 607668 Robynson, Richard, of Rudham, husbandman 3
4325121 2138785 2138785 defendant Burgany William yeoman 607668 607668 Burgany, William, of Rudham, yeoman 3
4343546 2145020 2145020 defendant Reade Thomas gent 607668 607668 Reade, Thomas, of Rudham, gent 0
4420598 2171344 2171344 defendant Oxwyk Roger de   607668 607668 Oxwyk, Roger de, of Rudham 7
4492956 2198500 2198500 defendant Parys Reginald   607668 607668 Parys, Reginald, of Rudham 1
4492958 2198500 2198500 defendant Parys Thomas   607668 607668 Parys, Thomas, of Rudham 3
4492961 2198501 2198501 defendant Parys Reginald   607668 607668 Parys, Reginald, of Rudham 1
4492963 2198501 2198501 defendant Parys Thomas   607668 607668 Parys, Thomas, of Rudham 3
4518376 2206121 2206121 defendant Cook John   607668 607668 Cook, John, of Rudham 1
4537125 2211883 2211883 defendant Hamond Thomas   607668 607668 Hamond, Thomas, of Rudham 1
4537126 2211883 2211883 defendant Hamond John   607668 607668 Hamond, John, of Rudham 2
4579212 2224980 2224980 defendant Boune John   607668 607668 Boune, John, of Rudham 2
4609274 2234003 2234003 defendant Benne John   607668 607668 Benne, John, of Rudham 6
4648319 2245568 2245568 defendant Bacheler John   607668 607668 Bacheler, John, of Rudham 0
4724727 2273031 2273031 defendant Westerne John butcher 607668 607668 Westerne, John, of Rudham, butcher 0
4726219 2273483 2273483 defendant Lynet John butcher 607668 607668 Lynet, John, of Rudham, butcher 1
4731215 2274961 2274961 defendant Broun William clerk 607668 607668 Broun, William, of Rudham, clerk 0
4736667 2276596 2276596 defendant Willes John yeoman 607668 607668 Willes, John, of Rudham, yeoman 1
4736670 2276597 2276597 defendant Willes John yeoman 607668 607668 Willes, John, of Rudham, yeoman 1
4779989 2289742 2289742 defendant Willys John yeoman 607668 607668 Willys, John, of Rudham, yeoman 1
4824387 2303688 2303688 defendant Spenser John ostler 607668 607668 Spenser, John, of Rudham, ostler 0
4867183 2316696 2316696 defendant Douge or Donge Thomas yeoman 607668 607668 Douge or Donge, Thomas, of Rudham, yeoman 0
4889769 2323594 2323594 defendant Douge or Donge Thomas yeoman 607668 607668 Douge or Donge, Thomas, of Rudham, yeoman 0
4902448 2327380 2327380 defendant Douge or Donge Thomas yeoman 607668 607668 Douge or Donge, Thomas, of Rudham, yeoman 0
4943152 2339830 2339830 defendant Howes John yeoman 607668 607668 Howes, John, of Rudham, yeoman 3
4959619 2344837 2344837 defendant Donge or Douge Thomas ostler 607668 607668 Donge or Douge, Thomas, of Rudham, ostler 0
5066198 2376416 2376416 plaintiff Methewolde John gent 607668 607668 Methewolde, John, of Rudham, gent 0
5090726 2383675 2383675 plaintiff Methewold or Medewold John gent 607668 607668 Methewold or Medewold, John, of Rudham, or of Wesebech, gent 0
5176473 2408806 2408806 plaintiff Ugge Simon   607668 607668 Ugge, Simon, of Rudham 0
5210718 2418867 2418867 plaintiff Ugge Simon   607668 607668 Ugge, Simon, of Rudham 0
5339023 2456776 2456776 defendant Grey Richard saddler 607668 607668 Grey, Richard, of Rudham, saddler 0
5349646 2460024 2460024 defendant Grene Richard yeoman 607668 607668 Grene, Richard, of Rudham, yeoman 1
5445000 2488390 2488390 defendant Wryght Robert husbandman 607668 607668 Wryght, Robert, of Rudham, husbandman 1
5457630 2492182 2492182 defendant Wright Robert husbandman 607668 607668 Wright, Robert, of Rudham, husbandman 1
5577857 2528146 2528146 defendant Skyppon Thomas yeoman 607668 607668 Skyppon, Thomas, of Rudham, yeoman 1
5577860 2528147 2528147 defendant Skyppon Thomas yeoman 607668 607668 Skyppon, Thomas, of Rudham, yeoman 0
5597847 2534225 2534225 plaintiff Dey Robert   607668 607668 Dey, Robert, of Rudham 0
5619305 2549885 2549885 defendant Benet Roger   607668 607668 Benet, Roger, of Rudham 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);