names

22 rows where place_id = 606284

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3664706 1914914 1914914 defendant Austen William merchant 606284 606284 Austen, William, of Little Stepyng, merchant 0
4697494 2264702 2264702 defendant Pope Oliver   606284 606284 Pope, Oliver, of Little Stepyng, shoe maker 1
4729504 2274440 2274440 defendant atte Tounesend Thomas   606284 606284 atte Tounesend, Thomas, of Little Stepyng, bailiff 0
4748288 2280008 2280008 defendant Malteby Margaret widow 606284 606284 Malteby, Margaret, of Little Stepyng, widow 0
4748289 2280008 2280008 defendant Pope Oliver shoemaker 606284 606284 Pope, Oliver, of Little Stepyng, shoemaker 1
4751547 2280938 2280938 plaintiff Smyth Robert   606284 606284 Smyth, Robert, of Little Stepyng 0
4805408 2297896 2297896 defendant Austhorp John husbandman 606284 606284 Austhorp, John, of Little Stepyng, husbandman 2
4814942 2300783 2300783 defendant Fouler John, junior husbandman 606284 606284 Fouler, John, junior, of Little Stepyng, husbandman 0
4817655 2301610 2301610 defendant Fouler John   606284 606284 Fouler, John, of Little Stepyng, franklin 0
4845549 2310116 2310116 defendant Fowler John husbandman 606284 606284 Fowler, John, of Little Stepyng, husbandman 10
4993892 2355042 2355042 defendant Herryotson Joan widow 606284 606284 Herryotson, Joan, of Little Stepyng, widow 0
5139818 2398121 2398121 defendant Halman Robert thatcher 606284 606284 Halman, Robert, of Little Stepyng, thatcher 0
5160783 2404249 2404249 defendant Halman Robert thatcher 606284 606284 Halman, Robert, of Little Stepyng, thatcher 0
5196677 2414779 2414779 defendant Halman Robert thatcher 606284 606284 Halman, Robert, of Little Stepyng, thatcher 0
5305132 2446539 2446539 defendant Raundson Hugh husbandman 606284 606284 Raundson, Hugh, of Little Stepyng, husbandman 0
5361258 2463547 2463547 defendant Ranson or Rauson Hugh yeoman 606284 606284 Ranson or Rauson, Hugh, of Little Stepyng, yeoman 0
5371476 2466661 2466661 defendant Gunby John butcher 606284 606284 Gunby, John, of Little Stepyng, butcher 0
5458501 2492436 2492436 plaintiff Fouler John   606284 606284 Fouler, John, of Little Stepyng 0
5458502 2492436 2492436 plaintiff Astyn John   606284 606284 Astyn, John, of Little Stepyng 1
5470141 2495986 2495986 plaintiff Fouler John   606284 606284 Fouler, John, of Little Stepyng 0
5470142 2495986 2495986 plaintiff Astyn John   606284 606284 Astyn, John, of Little Stepyng 1
5617023 2549139 2549139 defendant Braytoft Alan de   606284 606284 Braytoft, Alan de, of Little Stepyng 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);