names

47 rows where place_id = 757297

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4444780 2183343 2183343 plaintiff Conestable Robert   757297 757297 Conestable, Robert, of Flaynburgh 0
4472727 2192139 2192139 plaintiff Conestable Robert   757297 757297 Conestable, Robert, of Flaynburgh, knight 0
4538229 2212245 2212245 plaintiff Toby William   757297 757297 Toby, William, of Flaynburgh 0
4552273 2216665 2216665 defendant Panyerman Richard   757297 757297 Panyerman, Richard, of Flaynburgh 4
4567727 2221472 2221472 plaintiff Toby William   757297 757297 Toby, William, of Flaynburgh 0
4576121 2224031 2224031 defendant Skynner John   757297 757297 Skynner, John, of Flaynburgh 0
4576123 2224032 2224032 defendant Skynner John   757297 757297 Skynner, John, of Flaynburgh 0
4579191 2224975 2224975 plaintiff Constable Robert (legal representative) 757297 757297 Constable, Robert, of Flaynburgh, lord & knight, executrix of 0
4601707 2231752 2231752 plaintiff Walkere John   757297 757297 Walkere, John, of Flaynburgh 0
4629090 2240022 2240022 plaintiff Skynner John   757297 757297 Skynner, John, of Flaynburgh 0
4720492 2271746 2271746 defendant Symson William husbandman 757297 757297 Symson, William, of Flaynburgh, husbandman 2
4725692 2273323 2273323 defendant Patryk Henry husbandman 757297 757297 Patryk, Henry, of Flaynburgh, husbandman 1
4748844 2280150 2280150 defendant Cotes Thomas chaplain 757297 757297 Cotes, Thomas, of Flaynburgh, chaplain 1
4797326 2295335 2295335 defendant Crake Alan husbandman 757297 757297 Crake, Alan, of Flaynburgh, husbandman 1
4803948 2297416 2297416 defendant Kelyng Richard   757297 757297 Kelyng, Richard, of Flaynburgh, shipwright 0
4808256 2298761 2298761 plaintiff Coweton William   757297 757297 Coweton, William, of Flaynburgh 0
4821397 2302775 2302775 defendant Shipherd Richard butcher 757297 757297 Shipherd, Richard, of Flaynburgh, butcher 4
4845779 2310189 2310189 defendant Graynesby Richard husbandman 757297 757297 Graynesby, Richard, of Flaynburgh, husbandman 0
4853163 2312406 2312406 defendant Coweton William husbandman 757297 757297 Coweton, William, of Flaynburgh, husbandman 3
4853166 2312407 2312407 defendant Coweton William husbandman 757297 757297 Coweton, William, of Flaynburgh, husbandman 1
4858902 2314163 2314163 defendant Scotyre John (legal representative) 757297 757297 Scotyre, John, of Flaynburgh, executors of 0
4933320 2336812 2336812 defendant Sawepnay John shipman 757297 757297 (Sawepnay, John, of Flaynburgh, shipman 1
4936798 2337888 2337888 defendant Richardson Adam yeoman 757297 757297 Richardson, Adam, of Flaynburgh, yeoman 2
5080809 2380752 2380752 plaintiff Constable Robert esq 757297 757297 Constable, Robert, of Flaynburgh, esq 0
5080811 2380753 2380753 plaintiff Constable Robert esq 757297 757297 Constable, Robert, of Flaynburgh, esq 0
5080818 2380754 2380754 plaintiff Constable Robert esq 757297 757297 Constable, Robert, of Flaynburgh, esq 0
5105709 2388118 2388118 plaintiff Constable Robert esq 757297 757297 Constable, Robert, of Flaynburgh, esq 0
5105711 2388119 2388119 plaintiff Constable Robert esq 757297 757297 Constable, Robert, of Flaynburgh, esq 0
5121078 2392594 2392594 defendant Richardson Adam yeoman 757297 757297 Richardson, Adam, of Flaynburgh, yeoman 0
5128650 2394861 2394861 plaintiff Constable Robert   757297 757297 Constable, Robert, of Flaynburgh 3
5128653 2394862 2394862 plaintiff Constable Robert esq 757297 757297 Constable, Robert, of Flaynburgh, esq 0
5128655 2394863 2394863 plaintiff Constable Robert esq 757297 757297 Constable, Robert, of Flaynburgh, esq 0
5147841 2400511 2400511 plaintiff Constable Robert esq 757297 757297 Constable, Robert, of Flaynburgh, esq 3
5147844 2400512 2400512 plaintiff Constable Robert esq 757297 757297 Constable, Robert, of Flaynburgh, esq 0
5147846 2400513 2400513 plaintiff Constable Robert esq 757297 757297 Constable, Robert, of Flaynburgh, esq 0
5147848 2400514 2400514 plaintiff Constable Robert esq 757297 757297 Constable, Robert, of Flaynburgh, esq 0
5182822 2410729 2410729 plaintiff Constable Robert esq 757297 757297 Constable, Robert, of Flaynburgh, esq 0
5239110 2427030 2427030 defendant Thomason Peter chapman 757297 757297 Thomason, Peter, of Flaynburgh, chapman 0
5275567 2437924 2437924 defendant Constable Robert   757297 757297 Constable, Robert, of Flaynburgh, knight 0
5275575 2437925 2437925 defendant Constable Robert   757297 757297 Constable, Robert, of Flaynburgh, knight 0
5275583 2437926 2437926 defendant Constable Robert   757297 757297 Constable, Robert, of Flaynburgh, knight 0
5275591 2437927 2437927 defendant Constable Robert   757297 757297 Constable, Robert, of Flaynburgh, knight 0
5294140 2443259 2443259 defendant Constable Robert   757297 757297 Constable, Robert, of Flaynburgh, knight 0
5294146 2443260 2443260 defendant Constable Robert   757297 757297 Constable, Robert, of Flaynburgh, knight 0
5315390 2449663 2449663 defendant Tayllour James fisher 757297 757297 Tayllour, James, of Flaynburgh, fisher 0
5340096 2457110 2457110 defendant Byrsyngton or Brissyngton William beer brewer 757297 757297 Byrsyngton or Brissyngton, William, of Flaynburgh, beer brewer 0
5391032 2472504 2472504 defendant Constable Robert   757297 757297 Constable, Robert, of Flaynburgh, knight 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);