names

64 rows where place_id = 589631

✎ 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
3598229 1867077 1867077 defendant Halle Henry husbandman 589631 589631 Halle, Henry, of Allesley, husbandman 0
3616435 1872777 1872777 plaintiff Dey William   589631 589631 Dey, William, of Allesley 0
3825024 1965699 1965699 defendant Jarves Richard cordwainer 589631 589631 Jarves, Richard, of Allesley, cordwainer 0
3855491 1975362 1975362 defendant Elte William laborer 589631 589631 Elte, William, of Allesley, laborer 1
3855492 1975362 1975362 defendant Elte John laborer 589631 589631 Elte, John, of Allesley, laborer 2
3855493 1975362 1975362 defendant Docker John laborer 589631 589631 Docker, John, of Allesley, laborer 3
4031434 2035912 2035912 plaintiff Fitche Robert gent 589631 589631 Fitche, Robert, of Allesley, gent 0
4299434 2129889 2129889 defendant French John yeoman 589631 589631 French, John, of Allesley, yeoman 0
4392645 2162159 2162159 defendant Adcocke Thomas gent 589631 589631 Adcocke, Thomas, of Allesley, gent 0
4602837 2232102 2232102 defendant Hervy William   589631 589631 Hervy, William, of Allesley 2
4669682 2256219 2256219 defendant Bynesson John drover 589631 589631 Bynesson, John, of Allesley, drover 0
4669685 2256220 2256220 defendant Eynesson John drover 589631 589631 Eynesson, John, of Allesley, drover 0
4755608 2282136 2282136 defendant Eyns William husbandman 589631 589631 Eyns, William, of Allesley, husbandman 0
4764163 2284784 2284784 defendant Praney or Pravey Reginald drover 589631 589631 Praney or Pravey, Reginald, of Allesley, drover 0
4798096 2295594 2295594 defendant Dee William drover 589631 589631 Dee, William, of Allesley, drover 0
4801741 2296725 2296725 defendant de Preney Eyun drover 589631 589631 de Preney, Eyun, of Allesley, drover 0
4814669 2300701 2300701 defendant Welbek John drover 589631 589631 Welbek, John, of Allesley, drover 1
4834408 2306769 2306769 defendant Hacche Robert yeoman 589631 589631 Hacche, Robert, of Allesley, yeoman 0
4834409 2306769 2306769 defendant Spycer Thomas yeoman 589631 589631 Spycer, Thomas, of Allesley, yeoman 1
4866824 2316588 2316588 defendant Hacche Robert   589631 589631 Hacche, Robert, of Allesley, bailiff 0
4866825 2316588 2316588 defendant Auncell Henry husbandman 589631 589631 Auncell, Henry, of Allesley, husbandman 1
4866827 2316589 2316589 defendant Hacche Robert   589631 589631 Hacche, Robert, of Allesley, bailiff 0
4866828 2316589 2316589 defendant Auncell Henry husbandman 589631 589631 Auncell, Henry, of Allesley, husbandman 1
4922306 2333394 2333394 defendant Heryng John   589631 589631 Heryng, John, of Allesley 0
4922311 2333394 2333394 defendant Pyper John   589631 589631 Pyper, John, of Allesley 5
4922333 2333394 2333394 defendant Judde John, junior   589631 589631 Judde, John, junior, of Allesley 27
4934492 2337182 2337182 defendant Hatche Robert yeoman 589631 589631 Hatche, Robert, of Allesley, yeoman 0
4937556 2338120 2338120 defendant Grandon Richard husbandman 589631 589631 Grandon, Richard, of Allesley, husbandman 0
4947465 2341205 2341205 defendant Heryng John husbandman 589631 589631 Heryng, John, of Allesley, husbandman 0
4949836 2341937 2341937 defendant Pane John husbandman 589631 589631 Pane, John, of Allesley, husbandman 0
4957395 2344179 2344179 plaintiff Welbek John   589631 589631 Welbek, John, of Allesley 0
4958374 2344471 2344471 defendant Welbek John brasier 589631 589631 Welbek, John, of Allesley, brasier 0
4967612 2347255 2347255 defendant Grendon Richard husbandman 589631 589631 Grendon, Richard, of Allesley, husbandman 3
4971266 2348343 2348343 defendant Grendon Richard husbandman 589631 589631 Grendon, Richard, of Allesley, husbandman 1
5002046 2357500 2357500 defendant Hede John yeoman 589631 589631 Hede, John, of Allesley, yeoman 0
5002047 2357500 2357500 defendant Grendon Richard husbandman 589631 589631 Grendon, Richard, of Allesley, husbandman 1
5039844 2368559 2368559 defendant Spon or Sponer William, senior husbandman 589631 589631 Spon or Sponer, William, senior, of Allesley, husbandman 1
5081370 2380934 2380934 defendant Heryn John husbandman 589631 589631 Heryn, John, of Allesley, husbandman 0
5086172 2382351 2382351 defendant Haddon John husbandman 589631 589631 Haddon, John, of Allesley, husbandman 1
5096547 2385422 2385422 defendant Warner John husbandman 589631 589631 Warner, John, of Allesley, husbandman 1
5110098 2389367 2389367 plaintiff Grendon Richard   589631 589631 Grendon, Richard, of Allesley 0
5139519 2398045 2398045 defendant Grendon Richard yeoman 589631 589631 Grendon, Richard, of Allesley, yeoman 0
5139600 2398061 2398061 defendant Auncell John yeoman 589631 589631 Auncell, John, of Allesley, yeoman 4
5139609 2398063 2398063 defendant Auncell John yeoman 589631 589631 Auncell, John, of Allesley, yeoman 4
5156229 2402983 2402983 defendant Grendon Richard yeoman 589631 589631 Grendon, Richard, of Allesley, yeoman 1
5156272 2402989 2402989 defendant Grendon Richard yeoman 589631 589631 Grendon, Richard, of Allesley, yeoman 1
5160538 2404173 2404173 defendant Grendon Richard yeoman 589631 589631 Grendon, Richard, of Allesley, yeoman 0
5160540 2404174 2404174 defendant Grendon Richard yeoman 589631 589631 Grendon, Richard, of Allesley, yeoman 0
5172506 2407684 2407684 defendant Grendon Richard yeoman 589631 589631 Grendon, Richard, of Allesley, yeoman 1
5175307 2408470 2408470 defendant Grendon Richard yeoman 589631 589631 Grendon, Richard, of Allesley, yeoman 0
5191990 2413387 2413387 defendant Grendon Richard yeoman 589631 589631 Grendon, Richard, of Allesley, yeoman 1
5233946 2425518 2425518 defendant Herynge William husbandman 589631 589631 Herynge, William, of Allesley, husbandman 0
5290265 2442157 2442157 defendant Geffrey William yeoman 589631 589631 Geffrey, William, of Allesley, yeoman 0
5328344 2453551 2453551 defendant Colman Richard husbandman 589631 589631 Colman, Richard, of Allesley, husbandman 1
5328345 2453551 2453551 defendant Waren Richard husbandman 589631 589631 Waren, Richard, of Allesley, husbandman 2
5376502 2468248 2468248 defendant Heryng William yeoman 589631 589631 Heryng, William, of Allesley, yeoman 4
5376826 2468346 2468346 defendant Rage Thomas husbandman 589631 589631 Rage, Thomas, of Allesley, husbandman 0
5440734 2487138 2487138 defendant Geffrey William (legal representative) 589631 589631 Geffrey, William, of Allesley, yeoman, administratrix of 0
5440735 2487138 2487138 defendant Gefferey Joan widow 589631 589631 Gefferey, Joan, of Allesley, widow 1
5440739 2487139 2487139 defendant Prudyner John husbandman 589631 589631 Prudyner, John, of Allesley, husbandman 1
5451719 2490388 2490388 defendant Waren Richard husbandman 589631 589631 Waren, Richard, of Allesley, husbandman 0
5451720 2490388 2490388 defendant West William husbandman 589631 589631 West, William, of Allesley, husbandman 1
5500308 2505041 2505041 defendant Crosse Randolph brasier 589631 589631 Crosse, Randolph, of Allesley, brasier 0
5517127 2510193 2510193 defendant Halle Henry husbandman 589631 589631 Halle, Henry, of Allesley, husbandman 2

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);