names

85 rows where place_id = 588582

✎ 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
3594981 1866060 1866060 defendant Brownyng Robert yeoman 588582 588582 Brownyng, Robert, of Godmersham, yeoman 0
3594983 1866061 1866061 defendant Philpot Robert yeoman 588582 588582 Philpot, Robert, of Godmersham, yeoman 0
3599423 1867459 1867459 defendant A Dele John yeoman 588582 588582 A Dele, John, of Godmersham, yeoman 0
3611373 1871230 1871230 defendant Feveryll Robert   588582 588582 Feveryll, Robert, of Godmersham, rough mason 0
3611374 1871230 1871230 defendant Dele James husbandman 588582 588582 Dele, James, of Godmersham, husbandman 1
3637311 1906472 1906472 defendant Amys Richard tailor 588582 588582 Amys, Richard, of Godmersham, tailor 0
3649507 1910233 1910233 defendant Trewe William husbandman 588582 588582 Trewe, William, of Godmersham, husbandman 2
3680997 1920135 1920135 defendant Brownyng Thomas yeoman 588582 588582 Brownyng, Thomas, of Godmersham, yeoman 0
3680998 1920135 1920135 defendant Brownyng Robert smith 588582 588582 Brownyng, Robert, of Godmersham, smith 1
3713779 1930608 1930608 defendant Bradbury Reginald tailor 588582 588582 Bradbury, Reginald, of Godmersham, tailor 0
3716198 1931359 1931359 defendant Chapman James husbandman 588582 588582 Chapman, James, of Godmersham, husbandman 0
3766368 1947136 1947136 defendant A Pery Agatha widow 588582 588582 A Pery, Agatha, of Godmersham, widow 0
3766369 1947136 1947136 defendant Penne Richard tailor 588582 588582 Penne, Richard, of Godmersham, tailor 1
3783056 1952453 1952453 defendant Bewall Thomas husbandman 588582 588582 Bewall, Thomas, of Godmersham, husbandman 0
3783058 1952454 1952454 defendant Bewell Thomas husbandman 588582 588582 Bewell, Thomas, of Godmersham, husbandman 0
3792983 1955663 1955663 plaintiff Bewell Thomas   588582 588582 Bewell, Thomas, of Godmersham 0
3792984 1955663 1955663 defendant Jordayne Richard miller 588582 588582 Jordayne, Richard, of Godmersham, miller 0
3834833 1968833 1968833 defendant Fuller John yeoman 588582 588582 Fuller, John, of Godmersham, yeoman 3
3939942 2003659 2003659 defendant Love John husbandman 588582 588582 Love, John, of Godmersham, husbandman 3
4226754 2104831 2104831 defendant Vaughan Robert yeoman 588582 588582 Vaughan, Robert, of Godmersham, yeoman 0
4243797 2110906 2110906 defendant Vaughan Robert yeoman 588582 588582 Vaughan, Robert, of Godmersham, yeoman 0
4488786 2197214 2197214 plaintiff Hethe Alan de   588582 588582 Hethe, Alan de, of Godmersham 4
4488800 2197217 2197217 defendant Hethe Alan de   588582 588582 with Hethe, Alan de, of Godmersham 2
4489259 2197361 2197361 plaintiff Thomas William chaplain 588582 588582 Thomas, William, of Godmersham, chaplain 0
4505939 2202368 2202368 defendant Smyth Philip   588582 588582 Smyth, Philip, of Godmersham 0
4510570 2203769 2203769 defendant Smyth Philip   588582 588582 Smyth, Philip, of Godmersham 0
4519727 2206527 2206527 defendant Phelip William   588582 588582 Phelip, William, of Godmersham 0
4536724 2211762 2211762 defendant Cook John   588582 588582 Cook, John, of Godmersham 0
4564428 2220443 2220443 defendant Cotyng Thomas laborer 588582 588582 Cotyng, Thomas, of Godmersham, laborer 0
4564429 2220443 2220443 defendant Herst Richard wheler 588582 588582 Herst, Richard, of Godmersham, wheler 1
4635628 2241992 2241992 defendant Aleyn William   588582 588582 Aleyn, William, of Godmersham 0
4671265 2256665 2256665 defendant Colvyle Mathew woolman 588582 588582 Colvyle, Mathew, of Godmersham, woolman 0
4680806 2259617 2259617 defendant Norwode Thomas laborer 588582 588582 Norwode, Thomas, of Godmersham, laborer 0
4697420 2264681 2264681 defendant Quyk Thomas butcher 588582 588582 Quyk, Thomas, of Godmersham, butcher 0
4705808 2267188 2267188 defendant Cook John yeoman 588582 588582 Cook, John, of Godmersham, yeoman 0
4729467 2274428 2274428 defendant Heed alias Cook John husbandman 588582 588582 Heed alias Cook, John, of Godmersham, husbandman 0
4847471 2310708 2310708 defendant Pope William husbandman 588582 588582 Pope, William, of Godmersham, husbandman 1
4847472 2310708 2310708 defendant Pope Hamond husbandman 588582 588582 Pope, Hamond, of Godmersham, husbandman 2
4871534 2318067 2318067 defendant Gerard Thomas clerk 588582 588582 Gerard, Thomas, of Godmersham, clerk 0
4884618 2322101 2322101 defendant Phelypp John husbandman 588582 588582 Phelypp, John, of Godmersham, husbandman 1
4893789 2324752 2324752 defendant Bret William laborer 588582 588582 Bret, William, of Godmersham, laborer 1
4896975 2325703 2325703 defendant Bakke John baker 588582 588582 Bakke, John, of Godmersham, baker 0
4916519 2331672 2331672 defendant Bak John baker 588582 588582 Bak, John, of Godmersham, baker 2
5057614 2373845 2373845 defendant Pope Hamon husbandman 588582 588582 Pope, Hamon, of Godmersham, husbandman 0
5080840 2380760 2380760 defendant Pope Hamon husbandman 588582 588582 Pope, Hamon, of Godmersham, husbandman 0
5083031 2381430 2381430 defendant Upwell William yeoman 588582 588582 Upwell, William, of Godmersham, yeoman 0
5104981 2387897 2387897 defendant A Down William laborer 588582 588582 A Down, William, of Godmersham, laborer 1
5107963 2388768 2388768 defendant Rust Richard husbandman 588582 588582 Rust, Richard, of Godmersham, husbandman 3
5112477 2390036 2390036 defendant Marley John laborer 588582 588582 Marley, John, of Godmersham, laborer 0
5112478 2390036 2390036 defendant a Doune William laborer 588582 588582 a Doune, William, of Godmersham, laborer 1
5258148 2432668 2432668 defendant Cantelowe Thomas gent 588582 588582 Cantelowe, Thomas, of Godmersham, gent 0
5258150 2432669 2432669 defendant Cantelowe Thomas gent 588582 588582 Cantelowe, Thomas, of Godmersham, gent 0
5258152 2432670 2432670 defendant Cantelowe Thomas gent 588582 588582 Cantelowe, Thomas, of Godmersham, gent 0
5258162 2432673 2432673 defendant Cantelowe Thomas gent 588582 588582 Cantelowe, Thomas, of Godmersham, gent 2
5322757 2451882 2451882 defendant Valence James (legal representative) 588582 588582 Valence, James, of Godmersham, gent, executrix of 1
5337984 2456444 2456444 defendant Fourner John yeoman 588582 588582 Fourner, John, of Godmersham, yeoman 1
5337988 2456445 2456445 defendant Fourner John yeoman 588582 588582 Fourner, John, of Godmersham, yeoman 1
5341690 2457595 2457595 defendant Cantlowe Thomas gent 588582 588582 Cantlowe, Thomas, of Godmersham, gent 0
5341691 2457595 2457595 defendant London William yeoman 588582 588582 London, William, of Godmersham, yeoman 1
5355491 2461790 2461790 defendant Pope John   588582 588582 Pope, John, of Godmersham, parish clerk 2
5360216 2463237 2463237 defendant Dele John yeoman 588582 588582 Dele, John, of Godmersham, yeoman 0
5375174 2467823 2467823 defendant Style Beatrice widow 588582 588582 Style, Beatrice, of Godmersham, widow 2
5376470 2468239 2468239 defendant Bocher William laborer 588582 588582 Bocher, William, of Godmersham, laborer 0
5376471 2468239 2468239 defendant Wodelese William laborer 588582 588582 Wodelese, William, of Godmersham, laborer 1
5387769 2471565 2471565 defendant Frognale Nicholas husbandman 588582 588582 Frognale, Nicholas, of Godmersham, husbandman 1
5387772 2471565 2471565 defendant Idekyn or Judkyn John fuller 588582 588582 Idekyn or Judkyn, John, of Godmersham, fuller 4
5387773 2471565 2471565 defendant Chapman Richard laborer 588582 588582 Chapman, Richard, of Godmersham, laborer 5
5422485 2481671 2481671 defendant Lokkyng Stephen tailor 588582 588582 Lokkyng, Stephen, of Godmersham, tailor 2
5454881 2491378 2491378 defendant Lokkyng Stephen tailor 588582 588582 Lokkyng, Stephen, of Godmersham, tailor 2
5459662 2492806 2492806 defendant Philpot Robert yeoman 588582 588582 Philpot, Robert, of Godmersham, yeoman 0
5471361 2496375 2496375 defendant Philpot Robert yeoman 588582 588582 Philpot, Robert, of Godmersham, yeoman 0
5501589 2505428 2505428 defendant A Dele John yeoman 588582 588582 A Dele, John, of Godmersham, yeoman 1
5505901 2506768 2506768 defendant London William yeoman 588582 588582 London, William, of Godmersham, yeoman 1
5505905 2506769 2506769 defendant Hilles John gent 588582 588582 Hilles, John, of Godmersham, gent 0
5508829 2507614 2507614 defendant Brounyng Robert yeoman 588582 588582 Brounyng, Robert, of Godmersham, yeoman, son of Brounynge, Richard, of Godmersham, yeoman 2
5512076 2508636 2508636 defendant Browenyng Robert yeoman 588582 588582 Browenyng, Robert, of Godmersham, yeoman 0
5512078 2508637 2508637 defendant Philpot Robert yeoman 588582 588582 Philpot, Robert, of Godmersham, yeoman 0
5513814 2509176 2509176 defendant Philip Thomas tiler 588582 588582 Philip, Thomas, of Godmersham, tiler 0
5513816 2509176 2509176 defendant Andrewe Thomas   588582 588582 Andrewe, Thomas, of Godmersham, parish clerk 2
5513820 2509178 2509178 defendant Lulle Lawrence smith 588582 588582 Lulle, Lawrence, of Godmersham, smith 0
5513825 2509179 2509179 defendant Philip William husbandman 588582 588582 Philip, William, of Godmersham, husbandman 3
5513826 2509179 2509179 defendant Jakes John fuller 588582 588582 Jakes, John, of Godmersham, fuller 4
5604069 2536132 2536132 defendant True William husbandman 588582 588582 True, William, of Godmersham, husbandman 2
5610501 2547002 2547002 plaintiff Baldewyne Thomas   588582 588582 Baldewyne, Thomas, of Godmersham 0
5621424 2550596 2550596 plaintiff Stowebury John   588582 588582 Stowebury, John, of Godmersham 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);